Gizmo - Security & Performance
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·
    2 years 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
      3·
      2 years 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!

  • earmuff@lemmy.dbzer0.com
    21·
    2 years ago

    And why would anyone use SQLite outside the embedded world, when you can get way more performance with ClickHouse?

    • 0x0OP
      41·
      2 years ago

      Did you read the article?

      There’s more to SQLite than the embedded world and not everyone requires ClickHouse’s performance.

      • earmuff@lemmy.dbzer0.com
        11·
        2 years ago

        I actually did. There is still no reason to be wasteful with ressources. Why should I need to use a 4 core machine, when I could just use a single core machine?

        Only because „it works“, does not make it a valid reason to use it.

        • 0x0OP
          21·
          2 years ago

          Why should I need to use a 4 core machine

          Just 'cos the article writer used one doesn’t mean you have to and i doubt “multiple CPUs” is a requirement for SQLite.