1
Inserting a billion rows in SQLite under a minute
This is a chronicle of my experiment where I set out to insert 1B rows in SQLite
Avinash Sajjanshetty
v: Go and Rust programmer from India.
- Popular posts
- 9
- Total points
- 2,658
- HN comments
- 1,079
- Rank
- #566 personal
Visit avi.im → On Hacker News Jul 2021 – Sep 2025
Databases & Data 8Systems & Performance 4Security & Privacy 2Software Engineering 2Programming Languages 1History & Retro Computing 1
2
How bloom filters made SQLite 10x faster
This is the fascinating story of how researchers used Bloom filters cleverly to make SQLite 10x faster for analytical queries. These are my five-minute notes on the paper SQLite: Past, Present, and Future
3
Fun facts about SQLite
Some of the interesting and insane facts I learned about SQLite
4
In Search of a Faster SQLite
Researchers at the University of Helsinki and Cambridge attempted to build a faster SQLite using modern programming paradigms like io_uring and disaggregated storage. They demonstrate up to a 100x reduction in tail latency. These are my notes.
5
PSA: SQLite WAL checksums fail silently and may lose data
SQLite WAL has checksums, but on corruption it drops all the data and does not raise error
6
Oldest recorded transaction
The oldest recorded transaction was in 3100 BC
7
Hacking the Go compiler to add a new keyword
I forked and modified Go compiler to add a new keyword called let, as alias for var
8
SQLite does not do checksums
SQLite does not do checksums by default. Disk corruptions go silently unnoticed.
9
SQLite (with WAL) doesn't do `fsync` on each commit under default settings
SQLite doesn’t do fsync unless specified.