Re:SQLite-Web: Web-based SQLite database browser written in ...
by willsmith72 on Thursday February 08, 2024 @06:24AM
(#39300703)
i tend to lean the other way. postgres is just so easy. with managed db services, you dont have to think about backups, version upgrades, all the rest. you never have to worry about running into a rough edge or missing feature. the maturity and huge community make it hard to go wrong
Re:SQLite-Web: Web-based SQLite database browser written in ...
by tracker1 on Thursday February 08, 2024 @07:19AM
(#39301075)
Agreed... As soon as you need shared access to multiple systems, PG it is, usually in Docker though if it doesn't need a dedicated instance.
Though I have used Firebird when I needed to scale it support local and remote data before. I don't think Figured gets nearly enough attention.
Re:SQLite-Web: Web-based SQLite database browser written in ...
by tracker1 on Thursday February 08, 2024 @07:14AM
(#39301043)
I remember really pushing for SQLite for a specific application that used MS SQL... The main data in practice has requirements to be archived by event. And didn't need more than a few dozen users with low transactions in practice. Easy backup, archive etc.
In the end, there was a complex solution with a all the business logic in stored procedures and functions. With a lot of variability and difficulty supporting the application.
This was for a petition verification system. So each petition could have easily fit into a SQLite database. Been portable and easy to archive, backup, transport etc.
But no,. We had to put all the logic in the database... Because integritai...
Generally though, I want developers to justify why SQLite isn't good enough for their app before they build on something else. In a lot of cases SQLite absolutely is good enough, and it removes an insane amount of complexity, especially from things like database backups.