Re: Imperative Query Languages

From: "dandl" <david(at)andl(dot)org>
To: "'Jason Dusek'" <jason(dot)dusek(at)gmail(dot)com>, "'Peter Geoghegan'" <pg(at)bowt(dot)ie>, "'Merlin Moncure'" <mmoncure(at)gmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Imperative Query Languages
Date: 2017-07-06 01:23:28
Message-ID: 001701d2f5f6$7a89b210$6f9d1630$@andl.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Jason Dusek

SQL is great and I am fully on board with the idea. Everywhere I go, I promote the greatness of SQL, of the relational model, and of Postgres. I didn’t write in so much to challenge SQL or pitch navigational databases, as to ask about examples of “pseudo-imperative” languages.

Brief comments.

1. LINQ has some of what you describe, and certainly provides some of the benefits you mention.

2. The Third Manifesto http://thethirdmanifesto.com specifies a pure relational language (a ‘better SQL’) in largely imperative terms, and there is an implementation https://reldb.org that is mainly imperative.

3. My own project http://www.andl.org/ is functional rather than imperative but still fulfils the same purpose. On SQLite and Postgres, it generates SQL.

No, SQL is not great. It’s actually full of holes at every level, from basic language design to serious breaches of the relational model to monstrous incompatibilities between implementations. However, the concept of SQL is great (which is why it’s been so successful), and existing implementations have done extraordinarily well, all things considered. As they say, the good enough is the enemy of the great. SQL is here to stay.

Regards

David M Bennett FACS

_____

Andl - A New Database Language - andl.org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2017-07-06 04:55:57 Re: Is PL-PGSQL interpreted or complied?
Previous Message John R Pierce 2017-07-06 00:58:08 Re: Is PL-PGSQL interpreted or complied?