Our great sponsors
-
fast-sqlite3-inserts
Some bunch of test scripts to generate a SQLite DB with 1B rows in fastest possible way
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
I am working on this side project where I am trying to figure out the quickest way possible to generate an SQLite DB with 1B rows. The CPython version was able to 100M rows in 520 seconds and the same code under Pypy completed in 160 seconds. Here is the github code - https://github.com/avinassh/fast-sqlite3-inserts
A comment on 2, (It is still early days), but mypy is effectively this. Enforcing types and with mypyc, it is possible to compile all the scripts to statically typed c.
A comment on 2, (It is still early days), but mypy is effectively this. Enforcing types and with mypyc, it is possible to compile all the scripts to statically typed c.