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
Apple’s $9 engineering marvel no one wants (2017)
It’s the Lightning to 3.5 mm headphone jack adapter. I figured Apple got rid of the headphone jack and came up with this simple adapter to send analog audio signals from the phone to a 3.5 mm jack. Simple, right?
3
CTEs as lookup tables
How to use a CTE instead of complicated CASE expressions
4
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:
5
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.