DEV Community

Discussion on: SQLite is Not a Server

Collapse
 
martinhaeusler profile image
Martin Häusler

I'm using SQLite for a web application. I store primarily configutation and log data in there. It's working really well. If there are problems, they always originate from the (a bit lackluster) Java SQL driver, or from the SQLite browser UI which has some quirks as well. The only thing I wish SQLite had was full support for ALTER TABLE commands. I find myself creating new tables and copying data a lot, because many ALTER TABLE statements are not supported.