1
SQLite's Automatic Indexes
SQLite's optimizer creates indexes automatically to improve query performance with only nested loop joins.
Misframe
- Popular posts
- 5
- Total points
- 845
- HN comments
- 435
- Rank
- #2,684 personal
Visit misfra.me → RSS feedOn Hacker News Mar 2015 – Apr 2025
Software Engineering 4Databases & Data 4Hardware & Electronics 1Tech Industry & Business 1
2
CTEs as lookup tables
How to use a CTE instead of complicated CASE expressions
3
Catena: A time series storage engine written in Go
First, I suggest reading Baron’s “Time-Series Database Requirements” blog post to get some more context for this post. I read that and, as I usually do, had my mind set on low-level thoughts. I wrote the following comment:
4
SQLite transactions and virtual tables
In my previous post I introduced SQL virtual tables and how to use them in Go—registering modules per connection, defining schemas, and querying external sources as regular tables.