alt Hacker NewsI have always loved SQLite.
I have also heard that some firms ban its use.
Why?
Because it makes it SO easy to set up a database for your app that you end up with a super critical component of your application that looks exactly like a file. A file that can have any extension. And that file can be copied around to other servers. Even if there is PII in that file. Multiply this times the number of applications in your firm and you can see how this could get a little nuts.
DevOps and DBA teams would prefer that the database be a big, heavy iron thing that is very obviously a database server. And when you connect to it, that's also very obvious etc etc.
I still love SQLite though.
Replies
There are interesting uses for sqlite, like this one: https://sqlite.org/sqlar.html
That's so dumb
> DevOps and DBA teams
Ah so two teams nobody should listen to.
The question is, do the same firms ban Excel? Excel spreadsheets often end up as shadow databases in unlikely places.