3 ms·
Two I particularly like: - CREATE DOMAIN - ON UPDATE CASCADE Oh, and yeah, a BOOLEAN datatype. That's one in the eye to Larry Ellison. What would make it ab
by jfb 15y ago
Two I particularly like:
- CREATE DOMAIN
- ON UPDATE CASCADE
Oh, and yeah, a BOOLEAN datatype. That's one in the eye to Larry Ellison.
What would make it absolutely the bee's knees would be a decent data language on top of that lovely data engine. Something closed over composition, with a simple, orthogonal syntax. NoSQL in the truest form — not a blind rejection of Codd's algebra, but something LESS DUMB STUPID THAN THE WRETCHEDNESS THAT IS SQL.
- pvh 15y agoI've been agitating for an API that would allow developers to build their own query languages on top of Postgres alongside of SQL. Some day.
- luriel 15y agoYes! Please! The time for saner alternatives to SQL for querying relational databases is long overdue. Is sad that Postgres completely replaced QUEL with SQL, it was not the best language ever, but some competition and alternatives in this area would be good. Probably the sanest alternative around today to SQL would be Date's D (not to be confused with the "C++ on steroids" D language), see: http://en.wikipedia.org/wiki/D_(data_language_specification) http://en.wikipedia.org/wiki/D_(data_language_specification) and http://www.thethirdmanifesto.com/ http://www.thethirdmanifesto.com/ (evidence that database types should never be allowed to design websites :))