drift VS Hive

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/

The extension by default does not save any state, so we can use local storage like hive DB it's a NoSQL DB for flutter which actually stores data in Indexed DB in browser

Even the Hive readme recommends Isar https://github.com/hivedb/hive

I'm trying to learn new database for my app, it's called HiveDB (the database, not my app). In their docs, they mentions a lot about "lexicographical order". I tried to read the explanation on Wikipedia and answers from Stackoverflow but it still doesn't make any sense for me. What is that actually?

Hive is popular but there was an issue which was closed just a month ago after 2 whole years. An issue like this would be a disaster for a primary database

Here's type registry implementation code in hive if you want to check.

hive is a lightweight key-value database written in Dart for Flutter applications, inspired by Bitcask.

I'm using HiveDB for the history part, I thought I'd use SQLite, but I decided to try something I didn't know (and don't use at work)

Moor is a well-maintained ORM for sqlite3, a relational database management system. Hive is a fast but buggy key-value store. It's not an apple to apple comparison, they serve different purposes. Make the choice based on the type of data you want to store and how you need to access it.