SuperSQLite: SQLite library for Python (2018)

Interesting pick from one of the links in the article:<p>&quot;SQLite has fantastic write performance as well. By default SQLite uses database-level locking (minimal concurrency), and there is an “out of the box” option to enable WAL mode to get fantastic read concurrency — as shown by this test. But lesser known is that there is a branch of SQLite that has page locking, which enables for fantastic concurrent write performance.&quot;<p><a href="https:&#x2F;&#x2F;blog.expensify.com&#x2F;2018&#x2F;01&#x2F;08&#x2F;scaling-sqlite-to-4m-qps-on-a-single-server&#x2F;" rel="nofollow">https:&#x2F;&#x2F;blog.expensify.com&#x2F;2018&#x2F;01&#x2F;08&#x2F;scaling-sqlite-to-4m-q...</a>

Looks like it just bundles a full build of the sqlite shared library, along with some kind of gross hacks. It bundles pysqlite2, which notably is missing a ton of features and improvements from upstream. I&#x27;ll just compile my own, thanks...

Hi, I&#x27;m the author and founder at Plasticity (YCS17) and built this for some internal use cases our startup. This is actually a Work-in-Progress and not meant to be released yet, but it seems like someone has found it online. I will re-submit this here when it is ready as a Show HN given the interest, shoot me an e-mail at ajay@plasticityai.com if you would like to be kept up to date!

This looks like a dead project that just bundles together the built-in sqlite3 And another wrapper library APSW which itself is more active than this project. Why is this on hn?

Any features in this library you&#x27;d like to see standard library&#x27;s sqlite3 [1]? Maybe a PEP [2, python enhancement proposal] could do it.<p>[1] <a href="https:&#x2F;&#x2F;docs.python.org&#x2F;3&#x2F;library&#x2F;sqlite3.html" rel="nofollow">https:&#x2F;&#x2F;docs.python.org&#x2F;3&#x2F;library&#x2F;sqlite3.html</a><p>[2] <a href="https:&#x2F;&#x2F;www.python.org&#x2F;dev&#x2F;peps&#x2F;pep-0001&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.python.org&#x2F;dev&#x2F;peps&#x2F;pep-0001&#x2F;</a>

&gt; SQLite is extremely reliable and durable for large amounts of data (up to 140TB). It is considered one of the most well-engineered and well-tested software solutions today, with 711x more test code than implementation code.<p>I keep seeing this statement. Why is it considered one of the most well-engineered software?

Its supports &#x27;Remote Streaming over HTTP&#x27; without explaining what that means. Maybe someone here knows?

Title is misleading. It needs to add something like `python-library`. I thought they supercharged sqlite itself.

&gt; SQLite is extremely reliable and durable for large amounts of data (up to 140TB).<p>This has not been our experience. Our experience is that it sort of bogs down around 12GB in file size. linux box, ext3&#x2F;4, spinning disk (not SSD)

I&#x27;ve been toying with the idea of using SQLite as a data exchange format instead of JSON or XML. I can&#x27;t stand navigating through complex JSON trees, I want to just use SQL queries. Has anyone else tried this?

How accurate is this statement? &quot;SQLite is faster than nearly every other database&quot;. It links to a page that&#x27;s decades old.

The title would be better as &quot;SuperSQLite: a supercharged SQLite library for Python&quot;.