News for hackers. Stuff that matters.
Re:SQLite is all you need for durable workflows by mr_toad on Friday May 29, 2026 @03:39PM (#48328191)
That’s a comprehensive list of single user devices.
Re:SQLite is all you need for durable workflows by ibejoeb on Friday May 29, 2026 @04:25PM (#48328750)
Single-user, a single natural person, doesn't striclty mean single-accessor though. I don't think anyone here is suggesting that sqlite is a viable replacement a for any networked client/server postgresql system, but it is certainly capable of handling more than the most basic 1:1 tasks. Beyond that, the point is that you only need a file, so when you have natural data boundaries, a lot of problems decompose to that single user/single concern paradigm.
Re:SQLite is all you need for durable workflows by larubbio on Friday May 29, 2026 @04:55PM (#48329128)
'production' doesn't equal 'multi-user concurrent access'. There are production uses where sqlite is a valid choice even if it may not be the best choice for multi-user production use cases.
Re:SQLite is all you need for durable workflows by therealdrag0 on Friday May 29, 2026 @06:42PM (#48330289)
strawman? I have seen a dozens of these debates and never once have I seen someone questioned the validity of it for embedded usecases.