Skip to content

Avinash Sajjanshetty personal blog

Fun facts about SQLite

avi.im 6 min read

Some of the interesting and insane facts I learned about SQLite

Read on avi.im → Discuss on HN (191) Archived copy

Points: 393
HN comments: 191
Submissions: 1
Cited by: 0 commenters

Databases & Data Software Engineering 2024

On Hacker News

Submitted	Title on HN	Points	Comments
Dec 30, 2024	Fun facts about SQLite by avinassh	393	191

More from Avinash Sajjanshetty

All 9 posts →

Inserting a billion rows in SQLite under a minute

2021573 points146 comments Databases & Data details

How bloom filters made SQLite 10x faster

2024504 points121 comments Databases & Data details

In Search of a Faster SQLite

2024355 points149 comments Databases & Data details

PSA: SQLite WAL checksums fail silently and may lose data

2025279 points128 comments Databases & Data details

Oldest recorded transaction

2025182 points106 comments Databases & Data details

Hacking the Go compiler to add a new keyword

2021134 points49 comments Programming Languages details

Related posts from the same era

Ingesting PDFs and why Gemini 2.0 changes everything

Sergey's Blog20251,303 points447 comments details

GPT in 500 Lines of SQL

Explain Extended20241,111 points76 commentscited by 3 details

Datomic is Free

Datomic Blog20231,099 points368 commentscited by 5 details

Postgres IDE in VS Code

Microsoft Tech Community20251,040 points407 comments details

My favourite API is a zipfile on the European Central Bank's website

csvbase Blog20231,024 points265 comments details

The DuckDB Local UI

DuckDB Blog2025926 points188 commentscited by 3 details