News for hackers. Stuff that matters.
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 :)

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...

Re:Making Database Systems Usable by josephg on Wednesday August 21, 2024 @10:37AM (#41310732)
I didn't know that - thanks!