4 ms·

I like this. You can use traditional SQL along side it. It proves NoSql is a special case of SQL. I'd like to see Postgres eventually offer an official NoSql

by ape4 11y ago

I like this. You can use traditional SQL along side it. It proves NoSql is a special case of SQL. I'd like to see Postgres eventually offer an official NoSql api.

chris_wot 11y ago
The biggest issue with the traditional relational model is that it doesn't do trees very well. Aside from that, it's pretty robust.
- ape4 11y ago
  Yes, that would be hard! Maybe you could use Postgres's newish JSON for that. (Of course, that's not traditional SQL)
  - chris_wot 11y ago
    Oracle does have something - CONNECT BY (part of their hierachical queries). Sadly, to do something similar in PostreSQL you need to use a recursive CTE.