HNGlance

Top Best New Show

Queryability and the Sublime Mediocrity of SQL

https://buttondown.email/hillelwayne/archive/queryability-and-the-sublime-mediocrity-of-sql/

by quercusa • 3 years ago

13 3 3 years ago

BU

buttondown.email

Related Stories

Loading related stories...

Comments

3

bdcravens• 3 years ago

SQL is like Javascript: it succeeds by ubiquity, not quality.

elchief• 3 years ago

bad model

you should use sql table inheritance to represent an individual scientist or a group of scientists as the same (abstract) thing

then you can point a foreign key at an individual scientist or a group

and if you use single table inheritance, querying is trivial (but you have to live w some null columns)

smitty1e• 3 years ago

There are also a lot of queries that SQL is awful at, like most things involving graphs. That's why things like graph- and time-series databases have market niches.

Criticizing a general-purpose tool for special-purpose shortcomings never fails to fail at impressing.

Source preview

buttondown.email

HNGlance

© 2024-2026 HN Glance. Story content belongs to its original sources.

Privacy
Terms