http://simonwillison.net/2018-08-15T15:51:28+00:00Simon Willison2018-08-15T15:51:28+00:002018-08-15T15:51:28+00:00https://simonwillison.net/2018/Aug/15/compiling-sqlite-use-python-applications/#atom-tag

<p><strong><a href="http://charlesleifer.com/blog/compiling-sqlite-for-use-with-python-applications/">Compiling SQLite for use with Python Applications</a></strong></p> Charles Leifer’s recent tutorial on how to compile and build the latest SQLite (with window function support) for use from Python via his pysqlite3 library. <p><small></small>Via <a href="https://github.com/coleifer/pysqlite3/issues/2">Have this generate binary wheels with latest amalgamation and ship them to PyPI</a></small></p> <p>Tags: <a href="https://simonwillison.net/tags/pysqlite">pysqlite</a>, <a href="https://simonwillison.net/tags/python">python</a>, <a href="https://simonwillison.net/tags/sqlite">sqlite</a>, <a href="https://simonwillison.net/tags/charles-leifer">charles-leifer</a></p>

2018-08-15T15:15:34+00:002018-08-15T15:15:34+00:00https://simonwillison.net/2018/Aug/15/pysqlite3/#atom-tag

<p><strong><a href="https://github.com/coleifer/pysqlite3">coleifer/pysqlite3</a></strong></p> Now that the pysqlite package is bundled as part of the Python standard library the original open source project is no longer actively maintained, and has not been upgraded for Python 3. Charles Leifer has been working on pysqlite3, a stand-alone package of the module. Crucially, this should enable compiling the latest version of SQLite (via the amalgamation package) without needing to upgrade the version that ships with the operating system. <p>Tags: <a href="https://simonwillison.net/tags/pysqlite">pysqlite</a>, <a href="https://simonwillison.net/tags/python">python</a>, <a href="https://simonwillison.net/tags/sqlite">sqlite</a>, <a href="https://simonwillison.net/tags/charles-leifer">charles-leifer</a></p>

2003-09-05T09:32:08+00:002003-09-05T09:32:08+00:00https://simonwillison.net/2003/Sep/5/installingPySQLite/#atom-tag

<p>Techno Weenie has a <a href="http://techno-weenie.com/archives/2003/09/04/003227.php" title="PySQLite loaded">detailed guide</a> to setting up <a href="http://pysqlite.sourceforge.net/">PySQLite</a> on boxes you don't have root access to. <a href="http://www.hwaci.com/sw/sqlite/">SQLite</a> looks ideal for small to medium sized applications so I can see this being really useful should I ever write something that uses it.</p> <p>Tags: <a href="https://simonwillison.net/tags/pysqlite">pysqlite</a>, <a href="https://simonwillison.net/tags/python">python</a>, <a href="https://simonwillison.net/tags/sqlite">sqlite</a></p>