News for hackers. Stuff that matters.
Re:Elasticsearch SQL by abraxas on Monday October 24, 2022 @03:11PM (#33321038)
I’m conflicted on efforts like this. On the one hand SQL is for better or worse the Lingua Franca of database interfaces. On the other hand these half hearted, castrated implementations rarely work with tools geared towards working with true relational stores. The only real gain here is the surface level familiarity and of course the big fat check mark that the marketing team can put on the brochure to say “why, yes of course we support SQL!”
Re:Elasticsearch SQL by showerst on Monday October 24, 2022 @03:30PM (#33321315)
Having spent entirely too much of my life working with Elastic's annoyingly verbose and confusing JSON query syntax, the SQL is a big upgrade here even if it's not 1:1 with relational DBs.
Re:Elasticsearch SQL by HyperSane on Monday October 24, 2022 @07:20PM (#33323950)
Anything is better than Elasticsearch's terrible JSON query language. I actually try to avoid it because of how painful querying it is.