News for hackers. Stuff that matters.
Re:We Can Do Better Than SQL by enjo on Tuesday August 11, 2020 @01:49AM (#24117511)
XKCD’s comic on competing standards feels appropriate here:

https://xkcd.com/927/

Re:We Can Do Better Than SQL by CodesInChaos on Tuesday August 11, 2020 @08:10AM (#24119458)
I don't think treating query languages as a standard is the right comparison here. I think it's great that programming languages have evolved from C or PHP quality languages. I view SQL like PHP, I can write it if I have to, but it's certainly not a language I enjoy working with. EdgeQL has its flaws, but it still looks like a big improvement over SQL to me.
Re:We Can Do Better Than SQL by WesleyJohnson on Tuesday August 11, 2020 @08:58AM (#24119801)
I must be in the minority. I enjoy writing SQL and figuring out clever ways to construct queries to get what I need out of the data. Conversely, I am not a fan of PHP at all, but as you said, will write it if I have to.

EdgeQL looks... interesting, but I need to see more to decide for sure. Would be cool if they built out a translator, so you could pass in SQL and get back EdgeQL.

Re:We Can Do Better Than SQL by CodesInChaos on Tuesday August 11, 2020 @11:31AM (#24121390)
It's a translator, but in the opposite direction. EdgeDB is a postgres frontend that translates EdgeQL and its schema definition language to SQL which it then sends to postgres. (It can also translate GraphQL to EdgeQL to SQL)

I don't think translating from SQL to take a look at the EdgeQL it produces makes much sense, since it'd result in very unidiomatic queries. SQL prefers joins and flat rows, while EdgeQL is based on following links and has great support for nested data output.

Re:We Can Do Better Than SQL by agumonkey on Tuesday August 11, 2020 @02:28AM (#24117684)
is xkcd ever not appropriate ? there's probably an xkcd about it
Re:We Can Do Better Than SQL by kybernetikos on Tuesday August 11, 2020 @05:22AM (#24118612)
Not a munroe original, but I like this one https://thomaspark.co/2017/01/relevant-xkcd/
Re:We Can Do Better Than SQL by agumonkey on Tuesday August 11, 2020 @06:08AM (#24118813)
oh I thought he did that :)