51–60 of 63 posts
Seems like all the NoSQL databases eventually implement SQL, maybe we should use EventuallySQL instead NoSQL
What other prominent NoSQL databases eventually implemented SQL for queries?
https://docs.aws.amazon.com/amazondynamodb/latest/developerg...
Why the f*** couldn't they just build Elasticsearch with a SQL query language from the start? I hate their JSON query syntax and now that this is out I feel like I wasted all the time I spent making my applications work with it.
I guess one question, then, is why the f** you couldn't just have used an rdmbs instead of ES from the start....
A standardized query language is good, but passing in queries as strings will never not feel wrong to me.
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…
Earlier quoted context omitted.
> ...seems we have spent a significant amount of effort avoiding it, but it time and time again is the best way to query your data. It isn't that SQL is the best way (that these solutions keep gravitating towards it), it is just that SQL is pretty much the industry standard at this point. And supporting it is a predictable and usual ploy to expand userbase further. More so for the fact that ClickHouse continues to th…
What query languages have you found that are better than SQL? [edit] Typo.
For anyone with a python background, you can see a good example of (and experiment with) using Datalog style “logic programming” to query existing SQL databases, by checking out the pyDatalog package https://sites.google.com/site/pydatalog/ … keep in mind the level of abstraction in this library, it’s a great place to get familiar with what you could get from Datalog, but working with a database that natively supported Datalog, and had a Datalog query compiler/optimiser would be even more powerful.
I agree sql is almost always better, but heard that many new students and programmers would rather have a piped Grammer. Eg. Unixish https://github.com/opensearch-project/sql/blob/2.x/docs/user...
I look forward to a future where everything is SQL at this point. It seems we have spent a significant amount of effort avoiding it, but it time and time again is the best way to query your data. I recently started using Steampipe and it has made my life about 30x better not having to deal with the AWS or Slack API. Essentially a tool to let you query their APIs using SQL, behind the scenes it boots up a Postgres dat…
The syntax is still backward though. > SELECT blah FROM source vs > FROM source SELECT blah Fixing this would permit some very useful developer features.
prql-lang.org
Why the f*** couldn't they just build Elasticsearch with a SQL query language from the start? I hate their JSON query syntax and now that this is out I feel like I wasted all the time I spent making my applications work with it.