Hi, Arun Isaac <arunis...@systemreboot.net> skribis:
>> Initially, Cuirass was using SQLite but then switched [1] to >> PostgreSQL. The main reason is scalability. > > Ah, I see. I didn't know that. Years before, Hydra (https://nixos.org/hydra) also dropped its SQLite backend in favor of PostgreSQL only. Like you, not being a database person, I liked that SQLite was easy to deploy and had a clear model: it just touches this one file and that’s it. Yet, I’m starting to see a pattern. :-) SQLite may be good enough at a small scale; the problem is that you never know how long it’ll be before the project you’re hosting is no longer small-scale. Ludo’.