Just a moment...
kerkour.com

TL;DR?

PRAGMA journal_mode = WAL;
PRAGMA busy_timeout = 5000;
PRAGMA synchronous = NORMAL;
PRAGMA cache_size = 1000000000;
PRAGMA foreign_keys = true;
PRAGMA temp_store = memory ;

  • nezbyte@lemmy.world
    2·
    10 days ago

    I tend to use DuckDB now instead of SQLite for my applications. Though it would be nice if it had better concurrency support.

    • sjpwarren@programming.dev
      3·
      10 days ago

      Thank for your comment. I had heard of DuckDB but never checked it out. “why you would i need that I use postgres”… But I just found the WASM implementation and I have been looking for something like this for years. Thank you!