isar VS drift

I would have appreciated some more details on the benchmark. SQLite has notoriously slow writes in the default journal mode, but proper configuration and WAL/WAL2 mode should be a starting point for any comparison.

It's the first time I've heard of Isar[1] though. I'm always surprised at how many solid-but-underused Apache projects are out there, chugging along.

[0] https://phiresky.github.io/blog/2020/sqlite-performance-tuni...

[1] https://isar.dev/

I have a few flutter projects that have used Hive and have been fairly happy with it (except for a recent schema change that crashed production...but a story for another time), though will need support for more structured queries for a future project. Isar seemed to fit the ticket: made by same developer, nice API, supports queries, etc, except there is an ongoing discussion raising concerns I share. In short, it is not actively maintained, or at least inconsistently maintained. Isar v4 is on the horizon, but not ready for production, while v3 seems to have some serious bugs. It seems like a great project by a talented developer, but having only a single contributor is a serious risk.

Tracking stuff helps me in being motivated and can be the decision point if I do something or not. I'm sure there are some flaws in the app, so I'll be grateful for every feedback. It's written in Flutter. - [Isar](https://isar.dev/) for database. - [Stacked](https://pub.dev/packages/stacked) for the architecture. - [Syncfusion](https://pub.dev/packages/syncfusion\_flutter\_charts) for the charts. Here are some links, if anyone is interested: [Youtube video link](https://www.youtube.com/watch?v=dgQUU8AmtkY) [Play Store Link](https://play.google.com/store/apps/details?id=com.vinsho.tally\_tracker)

- Isar for database. I tried sqflite and hive but ended up with Isar.

Hive is a good option. Though I would also suggest checking out isar which is really powerfull offline storage db and its quite fast. Its built by the author of Hive himself so its quite reliable. https://isar.dev/

Read here: https://github.com/isar/isar/issues/686

I'd definitely recommend looking at Isar, https://isar.dev/.

I don't have a preference for SQL vs NoSQL; the app data is simple enough (think something like a note-taking app that can sync if you have multiple devices) that I do not think it matters. However, it would be really nice if direct device-to-device sync is supported so I don't need to bother with accounts or cloud. Some of the options I've found: - Couchbase Lite for Dart - sync is an enterprise feature, but Couchbase Lite for Dart is a community-built solution. Not sure how well that will work. - firebase - doesn't seem offline-first, just allows for temporary loss of connectivity - realm with Device Sync - seems most promising - ObjectBox Sync - no user-specific data sync. All data is sent to all app users! - drift + roll my own sync: yikes!

I have been using drift (since back when it was still called moor) for a long time now and really like it. The developer is responsive and quickly updates his package when new Dart versions come out.

There are a few people using https://github.com/simolus3/drift/tree/develop/extras/drift_postgres

You could try https://github.com/simolus3/drift/ with https://litesync.io/en/ it would be uncharted territory but if it worked it would be really interesting. The forum, https://litesync.io/forum/?q=mobile says its available for React Native. So it would probably work just fine in Dart. It does not support ConflictResolution. It appears you can evaluate it for free and the license cost is fairly inexpensive.

For an expense tracking app, we need to store the user's expenses and categories. At least for the first version, we're just going to store the data locally on the user's device. For this, I went with Drift, which is built on top of sqflite. For less critical data such as the theme and user preferences, shared_preferences is used instead.

I'd personally take a look at Drift instead. I've used it on a few different commercial projects now and it's very well built, one of the gems of the Flutter community IMO: https://drift.simonbinder.eu/

I'd run with Moor/Drift all the way then. https://drift.simonbinder.eu/