<story><title>SQLite is likely used more than all other database engines combined</title><url>https://sqlite.org/mostdeployed.html</url></story><parent_chain></parent_chain><comment><author>paradox460</author><text>In the past, I&amp;#x27;ve used it as a file format for an online application. Users often wanted to download bits and bobs of data from the app, not to view it or edit it on their desktop, but more as backups or to share a particular configuration
Previously we&amp;#x27;d used a json+zip pair, but the lack of enforced schema became a problem. Switching over to a gzipped sqlite db with a &amp;quot;custom&amp;quot; file extension worked incredibly well</text></comment>
<story><title>SQLite is likely used more than all other database engines combined</title><url>https://sqlite.org/mostdeployed.html</url></story><parent_chain></parent_chain><comment><author>qazxcvbnmlp</author><text>SQLite solves a lot of problems well enough that you can focus on other things.&lt;p&gt;Have an mvp you’re not sure you’ll ever have more that 2 users - yep.&lt;p&gt;Storing a little data for an application on the disk and don’t want to write your own schema.&lt;p&gt;Want to teach someone how databases work without setting up a sever - sure.</text></comment>