SQLite Isn't Enough

• edge-db-benchmarks

  6 0 7.5 C++

  Benchmarking SQLite vs. ObjectBox vs. Isar

  

https://github.com/ente-io/edge-db-benchmarks/blob/43273607d...

If this is how you are doing reads, this is your problem. Limit/offset reads are slow.

You'll get much better results if you do a proper pagination implementation.

This article describes the problem and solution that'd give you much better read results.

https://use-the-index-luke.com/sql/partial-results/fetch-nex...

• isar

  20 3,345 8.1 Dart

  Extremely fast, easy to use, and fully async NoSQL database for Flutter

  

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/

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• sqlite_async.dart

  1 36 7.9 Dart

  High-performance asynchronous interface for SQLite on Dart & Flutter

  

So the problem is with dart library sqlite_async.dart [1] and not with sqlite itself.

Kind of a misleading title, TBH.

[1] https://github.com/powersync-ja/sqlite_async.dart

Reference to HN comment - https://news.ycombinator.com/item?id=39290411

Suggest a related project