Sqlite 3.30.0
Glad to see SQLite on then front page -- it&#x27;s one of the  silent workhorses of the modern programming&#x2F;database world. It <i>is</i> the most widely deployed database[0]. If you haven&#x27;t given it a look&#x2F;aren&#x27;t interested in it since it seems to be a &quot;toy&quot; database (often the &quot;test&quot; or &quot;local&quot; db for frameworks like rails or django), you owe it to yourself to see what it can really do. Easy to use full text search[1][2], CTEs[3], JSON support via extension[4] (also the extension system is worth looking at[5]) and much much more. There are certainly things that SQLite does <i>not</i> do, and that&#x27;s well documented too[6].<p>If all this doesn&#x27;t convince you to <i>use</i> SQLite, it&#x27;s also one of the most well documented large C codebases that is fantastic to learn from.<p>I&#x27;d go as far as to say that many modern startups could get pretty far with SQLite + aggressive caching before even bringing in a big database like Postgres (though with recent deployment&#x2F;ops advancements it&#x27;s easier than ever to run postgres).<p>[0]: <a href="https:&#x2F;&#x2F;sqlite.org&#x2F;mostdeployed.html" rel="nofollow">https:&#x2F;&#x2F;sqlite.org&#x2F;mostdeployed.html</a><p>[1]: <a href="https:&#x2F;&#x2F;www.sqlite.org&#x2F;fts5.html" rel="nofollow">https:&#x2F;&#x2F;www.sqlite.org&#x2F;fts5.html</a><p>[2]: <a href="https:&#x2F;&#x2F;sqlite.org&#x2F;fts3.html" rel="nofollow">https:&#x2F;&#x2F;sqlite.org&#x2F;fts3.html</a><p>[3]: <a href="https:&#x2F;&#x2F;sqlite.org&#x2F;lang_with.html" rel="nofollow">https:&#x2F;&#x2F;sqlite.org&#x2F;lang_with.html</a><p>[4]: <a href="https:&#x2F;&#x2F;www.sqlite.org&#x2F;json1.html" rel="nofollow">https:&#x2F;&#x2F;www.sqlite.org&#x2F;json1.html</a><p>[5]: <a href="https:&#x2F;&#x2F;www.sqlite.org&#x2F;loadext.html" rel="nofollow">https:&#x2F;&#x2F;www.sqlite.org&#x2F;loadext.html</a><p>[6]: <a href="https:&#x2F;&#x2F;www.sqlite.org&#x2F;whentouse.html" rel="nofollow">https:&#x2F;&#x2F;www.sqlite.org&#x2F;whentouse.html</a>