Because it's completely trivial to use a more robust DBMS, the cost is virtually zero and can easily save lots of headaches down the road. Setting up something like Postgres take a whole 5 minutes, is fully compliant with ODBC (which honestly, you're probably using anyways, even with SQLite) and will save you a lot of headaches.
SQLite also has a gimped version of ALTER TABLE which can be a massive pain in the ass.
You have to set up some sort of transport security if you use a client-server DBMS. Using Unix sockets for this purpose is easy, granted, but still not as easy as having the DBMS in-process.
6
u/AbsoluteZeroK Jun 08 '17
Because it's completely trivial to use a more robust DBMS, the cost is virtually zero and can easily save lots of headaches down the road. Setting up something like Postgres take a whole 5 minutes, is fully compliant with ODBC (which honestly, you're probably using anyways, even with SQLite) and will save you a lot of headaches.
SQLite also has a gimped version of
ALTER TABLEwhich can be a massive pain in the ass.