Package selection guidance compiled from public package information, community data, and project usage.
quds_db is a Flutter/Dart package that extends sqflite to simplify database management. It streamlines the creation of databases and tables, supports CRUD operations, and enables model-based queries. By abstracting complex SQL logic, it allows developers to work with structured data using Dart models, reducing boilerplate code. The package is designed for efficient, type-safe interactions with local SQLite databases across multiple platforms.
Use cases
Local data persistence in mobile apps
Simplifying CRUD operations with models
Building offline-first applications
Managing structured app data
Streamlining database setup and migrations
Key features
Model-driven database operations
Built-in CRUD methods
Automatic table creation from models
Support for complex queries with model mapping
Cross-platform SQLite integration
Suitable for
Developers seeking sqflite simplification
Projects requiring local database storage
Apps needing offline functionality
Teams prioritizing code readability
Flutter apps with structured data needs
Considerations
Requires understanding of sqflite fundamentals
Limited to SQLite database backend
May need additional setup for advanced queries
Depends on proper model class definitions
Not suitable for cloud-based or real-time data
Original README
Original README snapshot from the linked source repository. Visit the repository for the latest content.
Quds Db
Is an automated version of sqflite!
How to use
1. To create a model
Model classes should extend DbModel class.
Define the schema of your model,
Supported field type:
Integers
Strings
DateTimes
Others
IdField
StringField
DateTimeField (saved as num)
BlobField
IntField
DateTimeStringField (Saved as string)
BoolField
NumField
JsonField ListField
DoubleField
ColorField
EnumField
classNoteextendsDbModel{
var title = StringField(columnName: 'title');
var content = StringField(columnName: 'content');
var isImportant = BoolField(columnName: 'isImportant');
var color = ColorField(columnName: 'color');
@overrideList<FieldWithValue>? getFields() => [title, content, isImportant, color];
}
Note that:
Every model has default fields:
id (Auto incremental integer field)
creationTime (automatically set once when created)
modificationTime (automatically set when created, and with every update operation)