27
All you need is PostgreSQL (ebellani.github.io)
submitted 3 months ago by to c/programming@lemmy.ml
9 comments fedilink hide all child comments
you are viewing a single comment's thread
view the rest of the comments
[–] 2 points 3 months ago (4 children)

SQLite is pretty incredible. I think it currently has even faster read performance than postgres.

The only reason to not use it, is if you have a write-heavy DB, or you need some of postgres's extra features.

  • permalink
  • fedilink
  • source
  • parent
  • hideshow 4 child comments
    •
  • [–] 3 points 3 months ago*

    we have more performance issues developing gotosocial with postgres than with sqlite. if we supported multinode deployments or horizontal scaling such that sqlite's concurrency got harder to reason-about I'm sure postgres would shine, but for a single process sqlite has been generally much faster and it hasn't required anywhere near as much prompting to get the query planner to behave as required.

    i also think when people assume sqlite is better for simpler applications, they think smaller. but no, for the same 25+GB databases sqlite has mopped the floor with performance.

    single-process multi-threaded sqlite is fantastic.

  • permalink
  • fedilink
  • source
  • parent