firebase_dart_sdk icon indicating copy to clipboard operation
firebase_dart_sdk copied to clipboard

Use Embedded NoSQL instead of SQLite for Persistence

Open rizalkotlin opened this issue 6 years ago • 6 comments

We already have persistent embedded document-oriented NoSQL database for Dart which support multi platform like objectdb or sembast. Using SQLite gives us downsize, too many implementation for every platform. On mobile we can use sqflite, on dart vm we use dart-sqlite, but on Flutter Desktop we can't use both of them, dart-sqlite can't be used since Flutter doesn't support reflection/mirror

rizalkotlin avatar Feb 09 '19 04:02 rizalkotlin

My suggestion is to build a platform plugin for desktop. You only need a few methods.

long1eu avatar Feb 11 '19 11:02 long1eu

you can use SQLite with FFI support on desktop right?

rodydavis avatar Aug 27 '19 15:08 rodydavis

Awesome idea. I was thinking about this also.

long1eu avatar Aug 27 '19 15:08 long1eu

flutter_moor does this on the experimental branch!

rodydavis avatar Aug 27 '19 20:08 rodydavis

Dart:ffi is far from ready. From their readme there are significant limitations when using it, like only for x64 or working only in Jit compiling, but that's not how flutter work. It looks like sembast is plausible solution when working in desktop, but still it will have performance degradation when working with large data set. I was hoping for mongodb embedable release for flutter, but still no news there.

talamaska avatar Aug 30 '19 21:08 talamaska

since nobody mentioned hive I will

iapicca avatar Mar 06 '21 13:03 iapicca