News for hackers. Stuff that matters.
Re:We Can Do Better Than SQL by marcolussetti on Thursday May 09, 2019 @05:41PM (#19872711)
If I recall correctly, Oracle's support for JSON is not at the same level as PostgreSQL. By that I mean seamlessly store JSON as a data type like any other. In Oracle JSON is stored as VARCHAR/CLOB and then you implement tests to validate whereas in PostgreSQL and MSSQL is its own data type.
Re:We Can Do Better Than SQL by GordonS on Friday May 10, 2019 @02:38AM (#19875566)
Similar story with SQL Server. I believe JSON support is a bit better in SQL Server 2019, but still far lacking behind that of Postgres.