objectdb 0.0.12

Persistent embedded document-oriented NoSQL database for Dart and Flutter. 100% Dart.

ObjectDB

Persistent embedded document-oriented NoSQL database for Dart and Flutter. 100% Dart.

CAUTION This plugin is still in development. Use at your own risk. If you notice any bugs you can create an issue on GitHub. You're also welcome to contribute using pull requests. Please open an issue before spending time on any pull request.

How to use

final path = Directory.current.path + '/my.db';

// create database instance and open
final db = ObjectDB(path);
await db.open();

// insert document into database
db.insert({'name': {'first': 'Some', 'last': 'Body'}, 'age': 18, 'active': false);
db.insert({'name': {'first': 'Someone', 'last': 'Else'}, 'age': 25, 'active': false);

// update documents
db.update({Op.gte: {'age': 80}}, {'active': false});

// delete documents
db.delete({'active': false});

// search documents in database
var result = await db.find({'active': true});

// 'tidy up' the db file
await db.tidy();

// close db
await db.close();

Methods

• Future<ObjectDB> db.open([bool tidy = true]) opens database
• Future<void> db.tidy() 'tidy up' the .db file
• Future<void> db.close() closes database

find

• List<Map> db.find(Map query) List with all matched documents
• Map db.first(Map query) first matched document
• Map db.last(Map query) last matched document

insert

• Future<ObjectId> db.insert(Map document) insert single document
• Future<List<ObjectId>> db.insertMany(List<Map> documents) insert many documents

update (TODO: return count)

• Future<void> db.update(Map query, Map changes, [bool replace = false]) update documents that mach query with changes (optionally replace whole document)

delete (TODO: return count)

• Future<void> db.delete(Map query) delete documents that match query

Query

// Match fields in subdocuments
{Op.gte: {
    'birthday.year': 18
}}

// or-operator
{Op.or:{
    'active': true,
    Op.inArray: {'group': ['admin', 'moderator']}
}}

// not equal to
{Op.not: {'active': false}}

NOTE Querying arrays is not supportet yet.

Operators

Logical

• and (default operator on first level)
• or
• not

Comparison

• lt, lte: less than, less than or equal
• gt, gte: greater than, greater than or equal
• inList, notInList: value in list, value not in list

Examples

// query
var result = db.find({
    'active': true,
    Op.or: {
        Op.inList: {'state': ['Florida', 'Virginia', 'New Jersey']},
        Op.gte: {'age': 30},
    }
});

// same as
var match = (result['active'] == true && (['Florida', 'Virginia', 'New Jersey'].contains(result['state']) || result['age'] >= 30));

License

See License