postgres_crdt VS Hive

sqlite_crdt and postgres_crdt are implementations of the above

Same here, except I'm using shelf + postgres crdt in the backend.

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.