<divstyle="padding: 0 0 20px 0; margin: 0 0 20px 0; background-color: #22B24C;">
<divclass="container">
<pclass="banner"><ahref="https://www.gumroad.com/l/python-deployments" style="color: #fff">Learning web development? Check out The Full Stack Python Guide to Deployments book</a>!</p>
</div>
</div><ahref="https://github.com/makaimc/fullstackpython.com"><imgstyle="position: absolute; top: 0; right: 0; border: 0;" src="/img/fork.png" alt="Fork me on GitHub"></a>
<divclass="well see-also">SQLite is an implementation of the <ahref="/databases.html">relational database</a> concept. Learn more in the <ahref="/data.html">data</a> chapter or view the <ahref="/table-of-contents.html">table of contents</a> for all topics.</div>
<h3>SQLite resources</h3>
<ul>
<li>
<p><ahref="https://pymotw.com/2/sqlite3/">sqlite3 - embedded relational database</a> is an
extensive tutorial showing many of the common create, read, update and delete
operations a developer would want to do with SQLite.</p>
to implement virtual tables and aggregates on top of SQLite.</p>
</li>
<li>
<p><ahref="http://flask.pocoo.org/docs/0.10/patterns/sqlite3/">Using SQLite with Flask</a>
explains how Flask code can directly query a SQLite database without an ORM.</p>
</li>
<li>
<p><ahref="http://sqlitebrowser.org/">SQLite Browser</a> is an open source graphical user
interface for working with SQLite.</p>
</li>
<li>
<p>The official
<ahref="https://docs.python.org/3/library/sqlite3.html">sqlite3 module in the Python stdlib docs</a>
contains a bunch of scenarios with code for how to use the database from
a Python application.</p>
</li>
<li>
<p><ahref="http://charlesleifer.com/blog/using-the-sqlite-json1-and-fts5-extensions-with-python/">Using the SQLite JSON1 and FTS5 Extensions with Python</a>
shows how to compile SQLite 3.9.0+ with json1 and fts5 (full-text search)
support to use these new features.</p>
</li>
<li>
<p><ahref="http://blog.regehr.org/archives/1292">SQLite with a fine-toothed comb</a>
digs into the internals of SQLite and shows some bugs found (and
since fixed) while the author was researching the SQLite source code.</p>
</li>
</ul>
<h3>What do you want to learn next about data?</h3>
<ahref="http://www.deploypython.com/"><imgsrc="/img/sponsored/fsp-deployment-guide.png" alt="The Full Stack Python Guide to Deployments" width="100%"></a>
<pstyle="font-size: .8em; margin-top: 10px;">Searching for a complete, step-by-step deployment walkthrough? Learn more about <ahref="http://www.deploypython.com/">The Full Stack Python Guide to Deployments book</a>.