sql

Santiago 2024-04-25T09:10:40.189029Z

👋 I've been reading some blog posts about using SQLite as a server database, and it got me curious. Anyone that tried it could share their experience? My use-case would have low traffic, low amount of writes and def low concurrency, so it sounds like a great fit without the overhead of Postgres. DB would be backed up via https://litestream.io/

Cora (she/her) 2024-04-25T10:34:18.315719Z

cljdoc uses sqlite for its db, and it's open source

igrishaev 2024-04-25T10:57:31.170809Z

SQLite is mostly used for one-user applications like browsers, messagers, etc. When it's used on the server, your client may face blocking exceptions when two clients write something. Even if you think it's rarely, it's still possible. Why not using postgres/mysql?

Santiago 2024-04-25T11:39:49.038789Z

@igrishaev I'm familiar with SQLite for mobile and single-user. However, with some tweaks it looks like it's fine e.g. https://fly.io/blog/all-in-on-sqlite-litestream/, also the official docs mention this https://www.sqlite.org/whentouse.html Reg "why not postgres/mysql": eh why not? I like SQLite and I'm curious about using it in this manner. Instant benefits are: one less thing to manage, easy backups, fast. Downsides are what you mentioned, but see linked docs. @corasaurus-hex nice thanks I'll check it out