4 ms·
> Like, you can't make a column of lists-of-strings. Most relational databases have supported lists-of-strings (arrays) for about 10 years now. All of them sup
by Swizec 2y ago
> Like, you can't make a column of lists-of-strings.
Most relational databases have supported lists-of-strings (arrays) for about 10 years now. All of them supported lists-of-strings even before that, if you were okay doing a bit of app-level work on top of your SQL.
Relational databases these days support full JSON. And they're faster at it than many json-first databases :)
edit: Actually I'm wrong. SQL added support for arrays in 1999, a full 25 years ago.
https://en.wikipedia.org/wiki/SQL:1999 https://en.wikipedia.org/wiki/SQL:1999 https://stackoverflow.com/questions/30109111/at-what-version-of-the-sql-standard-did-arrays-appear https://stackoverflow.com/questions/30109111/at-what-version...
- josephg 2y agoI didn't know that - thanks!