Avinash Sajjanshetty
avi.im · Personal blog · on HN since 2015
Avinash Sajjanshetty's blog on SQLite performance, database storage architecture, checksums, and bloom filters.
What HN saysHN links it for fast SQLite insert benchmarks and the post noting SQLite lacks checksums; one commenter calls other posts hype-heavy, another disputes that.
19HN people shared it
4linked it in comments
45stories submitted
2.9Kstory points
3 months agolast shared
2015people per year2026
Most-shared posts
- 1Inserting a billion rows in SQLite under a minute6 people · 579 points · first shared 2021 · 146 comments on HN
- 2Zero Disk Architecture4 people · 14 points · first shared 2024 · discussion on HN
- 3Setsum – order agnostic, additive, subtractive checksum4 people · 9 points · first shared 2025 · 1 comments on HN
- 4In Search of a Faster SQLite3 people · 376 points · first shared 2024 · 149 comments on HN
- 5Disaggregated Storage – A Brief Introduction3 people · 6 points · first shared 2024 · discussion on HN
- 6PSA: Most databases do not do checksums by default3 people · 3 points · first shared 2024 · discussion on HN
- 7How bloom filters made SQLite 10x faster2 people · 504 points · first shared 2024 · 121 comments on HN
- 8SQLite does not do checksums2 people · 132 points · first shared 2024 · 98 comments on HN
- 9It is becoming difficult for me to be productive in Python2 people · 6 points · first shared 2023 · 1 comments on HN
- 10Django v1 to v4 Upgrade2 people · 2 points · first shared 2021 · discussion on HN
- 11SQLite prefixes its temp files with `etilqs_`2 people · 2 points · first shared 2026 · discussion on HN
- 12Fun facts about SQLite1 people · 393 points · first shared 2024 · 191 comments on HN
- 13PSA: SQLite WAL checksums fail silently and may lose data1 people · 279 points · first shared 2025 · 129 comments on HN
- 14Oldest recorded transaction1 people · 182 points · first shared 2025 · 106 comments on HN
- 15Hacking the Go compiler to add a new keyword1 people · 134 points · first shared 2021 · 49 comments on HN
What HN people wrote when they linked it
avinassh · 2025-04-01
> There are plenty of large projects written in Python.
There are, but they are certainly a pain in the ass to work with.
I once had to work on a semi-large Python codebase and got so frustrated that I wanted to port the code to some other language. The best part? I wrote the majority of that codebase myself, just months earlier.
I ranted about it here: https://avi.im/blag/2023/refactoring-python/
dist-epoch · 2026-08-17
SQLite has it's own issues - for example it doesn't support checksums. Quite bizarre for a database file format where integrity is supposedly highly valued.
With a zip file at least you know your file was corrupted.
https://avi.im/blag/2024/sqlite-bit-flip/
johnfn · 2024-12-30
> I'd personally prefer deeper thinking which this blog's previous posts-- high in hype and low in technical rigor-- have not yet provided.
Really? Something like this[1] (literally the previous post made by the author!) is "high in hype and low in technical rigor"? Or do you just have an axe to grind?
[1]: https://avi.im/blag/2024/sqlite-past-present-future/
ledgerdev · 2022-09-01
Here's sqlite doing 100 million inserts in 33 seconds which should fit into nearly every workload, though it is batched. https://avi.im/blag/2021/fast-sqlite-inserts/
So write contention from multiple connections is what you're talking about, versus a single process using sqlite?