Re:PartiQL: One query language for all your data
by manigandham on Thursday August 01, 2019 @05:18PM
(#20588456)
This is pretty nice. If only because using a SQL dotted syntax seamlessly with JSON data.
[ Parent
| on HN ]
Re:PartiQL: One query language for all your data
by smt88 on Thursday August 01, 2019 @07:39PM
(#20589408)
Postres has had this for years. It's arrows instead of dots, but that's the only visual difference.
Re:PartiQL: One query language for all your data
by manigandham on Thursday August 01, 2019 @11:25PM
(#20590489)
It's not the same at all, and it gets much more verbose with minor complexity and lacks functionality.
PG is working on adding SQL/JSON support for JSON Path queries for the next version. It'll be a major improvement but still not as nice as what PartiQL has here.
Re:PartiQL: One query language for all your data
by dangoor on Thursday August 01, 2019 @10:56PM
(#20590389)
The SQL standard includes JSON support: https://modern-sql.com/blog/2017-06/whats-new-in-sql-2016
Re:PartiQL: One query language for all your data
by manigandham on Thursday August 01, 2019 @11:14PM
(#20590455)
The SQL standard is different from what databases actually support. No RDBMS supports this yet. Only Elasticsearch, Couchbase, and managed services like Rockset and CosmosDB.
Re:PartiQL: One query language for all your data
by sixbrx on Friday August 02, 2019 @11:05AM
(#20593513)
Oracle 12.2+ reportedly supports the ISO SQL/JSON though I haven't tried it. Which btw looks like mostly just renames of Postgres functions.
https://docs.oracle.com/en/database/oracle/oracle-database/1...