News for hackers. Stuff that matters.
Re:Show HN: Querying JSON documents using SQL-like language ... by collyw on Wednesday February 26, 2020 @04:23AM (#22421590)
SQL isn't the good part about relational databases, its the relational model that is the good part. The ability to query your data from multiple different angles.

In saying that, I guess its still better than having yet another custom query language a la mongo.

Re:Show HN: Querying JSON documents using SQL-like language ... by mmalek06 on Wednesday February 26, 2020 @04:59AM (#22421734)
I don't agree :). SQL nicely abstracts what would have been more difficult or technical to do otherwise. Yep, it was create in order to enable non strictly technical people to query their data, but does it make it bad? I don't think so. Also authors of great many NoSql databases (and other technologies, ever heard about the widely loved LINQ technology in C#?) think, giving their users the possibility to query data using what they already know. Also: can you honestly, from the bottom of your heart, say that you'd rather filter json documents using some form of XPath? Besides: I'm not trying to criticize relational model, as well as I'm not saying that JSON is the way to go when storing data :D I just wanted to create a tool for people that are trying to implement a very specific business case I described and, due to lack of tools, are having some issues with it.
Re:Show HN: Querying JSON documents using SQL-like language ... by collyw on Wednesday February 26, 2020 @08:12AM (#22422568)
> Also: can you honestly, from the bottom of your heart, say that you'd rather filter json documents using some form of XPath?

Come one read the second line of my reply before strawmanning.

Re:Show HN: Querying JSON documents using SQL-like language ... by mmalek06 on Wednesday February 26, 2020 @10:07AM (#22423546)
Ok, maybe I got too defensive and assigned to much weight to the first part of your first sentence. No strawmanning intended :)
Re:Show HN: Querying JSON documents using SQL-like language ... by mmalek06 on Wednesday February 26, 2020 @05:11AM (#22421785)
Also: please look at my first comment, from 13 hours ago - it should shed some light on the "why" part.