1
SQLite is not a toy database
Here is why SQLite is a perfect tool for you - whether you are a developer, data analyst, or geek.
Anton Zhiyanov
Everything about Go, SQL, and software in general.
- Popular posts
- 19
- Total points
- 4,784
- HN comments
- 2,012
- Rank
- #241 personal
Visit antonz.org → RSS feedOn Hacker News Mar 2021 – Sep 2026
Software Engineering 17Databases & Data 7Tools & Productivity 5Programming Languages 4Web & Frontend 2Systems & Performance 1
2
I don't need your query language
Seriously, I don't. I'd prefer SQL.
3
JSON and Virtual Columns in SQLite
Faster JSON handling in a relational database.
4
How to create a 1M record table with a single query
With recursive CTE and randomized data.
5
SQLite 3.44: Interactive release notes
Order by in aggregates, better string concatenation, and thorough date formatting.
6
Trying chDB, an embeddable ClickHouse engine
A lightweight in-process SQL OLAP engine, powered by ClickHouse.
7
Upsert in SQL
Inserting and updating data with a single query.