Skip to content

Misframe personal blog

CTEs as lookup tables

by Preetam Jinka misfra.me 1 min read

How to use a CTE instead of complicated CASE expressions

Read on misfra.me → Discuss on HN (112) Archived copy

Points: 177
HN comments: 112
Submissions: 1
Cited by: 0 commenters

Databases & Data Software Engineering 2023

On Hacker News

Submitted	Title on HN	Points	Comments
Jan 11, 2023	CTEs as lookup tables by preetamjinka	177	112

More from Misframe

All 5 posts →

SQLite's Automatic Indexes

2022216 points40 comments Databases & Data details

Apple’s $9 engineering marvel no one wants (2017)

2019214 points253 comments Hardware & Electronics details

Catena: A time series storage engine written in Go

2015134 points21 comments Databases & Data details

SQLite transactions and virtual tables

2025104 points9 comments Databases & Data details

Related posts from the same era

I'm all-in on server-side SQLite

Fly.io Blog20221,353 points565 commentscited by 16 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

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

csvbase Blog20231,024 points265 comments details

Suspicious data pattern in recent Venezuelan election

Andrew Gelman2024903 points470 comments details

Health insurers just published close to a trillion hospital prices

DoltHub Blog2022901 points526 comments details