Welcome to Sqlcool’s documentation!

The objectives of this lib is to provide a simple api while staying close to sql.

Crud operations

• Schema definition
  • Columns
  • Methods
• Initialize database
  • Initialize an empty database
  • Initialize a database from an Sqlite asset file
  • Multiple databases
  • Verbosity
• Database operations
  • Insert
  • Select
  • Update
  • Delete
  • Upsert
  • Join
  • Exists
  • Raw query
• Batch insert

Reactivity

• Using the bloc pattern for select
  • Select bloc
  • Join queries
• Reactivity
  • Changefeed
  • Reactive select bloc

Database models

• Declare the model
  • Extend with DbModel
  • Override getters
  • Declare a schema
  • Define serializers
• Data mutations
  • Insert
  • Update
  • Upsert
  • Delete
• Select operations
• Foreign keys support

Indices and tables

• Index
• Module Index
• Search Page