Re:Making Database Systems Usable
by Swizec on Tuesday August 20, 2024 @08:09PM
(#41305411)
> 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 :)
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://stackoverflow.com/questions/30109111/at-what-version...