isar VS Hive

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/.

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.