News for hackers. Stuff that matters.
Re:Huly – Open-Source All-in-One Project Management Platform by danpalmer on Monday October 14, 2024 @01:13AM (#41834394)
Every decision for an external dependency that a self-hosted service makes is another chance for it to have that impedance mismatch you mentioned.

Postgres is a relatively uncontroversial one, but I had the benefit of working for a company already operating a production postgres cluster where I could easily spin up a new database for a service. I went with SQLite/on disk storage because for most companies, providing a resilient block storage device, with backups, is likely trivial, regardless of which cloud they're on, being on bare metal, etc.

Re:Huly – Open-Source All-in-One Project Management Platform by nine_k on Monday October 14, 2024 @02:15AM (#41834708)
SQLite is fine and dandy as long as you don't do a lot of updates. SQLite locks the entire database for a transaction. It may be fine for quite long, or you may face slowdowns with just a few parallel users, depending on your use case.