SuperSQLite: SQLite library for Python (2018)
1–10 of 78 posts
Re: SuperSQLite: SQLite library for Python (2018)
#2Its supports 'Remote Streaming over HTTP' without explaining what that means. Maybe someone here knows?
Re: SuperSQLite: SQLite library for Python (2018)
#3The title would be better as "SuperSQLite: a supercharged SQLite library for Python".
Re: SuperSQLite: SQLite library for Python (2018)
#4> 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.
I keep seeing this statement. Why is it considered one of the most well-engineered software?
Re: SuperSQLite: SQLite library for Python (2018)
#5Looks 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'll just compile my own, thanks...
Re: SuperSQLite: SQLite library for Python (2018)
#6> 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. I keep seeing this statement. Why is it considered one of the most well-engineered software?
A small (?) part of the answer is likely to be found in the massive amount of testing: https://sqlite.org/testing.html
Re: SuperSQLite: SQLite library for Python (2018)
#7> 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. I keep seeing this statement. Why is it considered one of the most well-engineered software?
https://sqlite.org/about.html
The bit about testing.
Re: SuperSQLite: SQLite library for Python (2018)
#8> 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. I keep seeing this statement. Why is it considered one of the most well-engineered software?
I would like not to have to deal with SQLITE_BUSY errors for once. It even throws when trying to obtain a connection. It got so bad I had to put a mutex around obtaining a sqlite connection.
Re: SuperSQLite: SQLite library for Python (2018)
#9Interesting pick from one of the links in the article:
"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."
https://blog.expensify.com/2018/01/08/scaling-sqlite-to-4m-q...
Re: SuperSQLite: SQLite library for Python (2018)
#10> 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. I keep seeing this statement. Why is it considered one of the most well-engineered software?
Not a direct answer but it's certainly the most used, which correlates highly with getting a lot of dev attention :)