This is the challenge that I accept, with Andl. SQL has been astonishingly successful, partly because of sound foundations and partly because it's a monopoly. It's not a bad language, but on the other hand it many ways it's not a language at all. Up until the 1992 version and including the SQLite dialect, there are many things that a programming language should provide that it does not.
I have some specific criticisms of SQL, but I'm not here to bury it. I'd just like to offer something better. That's the point of Andl. I have reviewed the SQL 'challenge' you posted some little while back, and there is no doubt that Andl can handle it, and (IMHO) the code is somewhat shorter and somewhat cleaner than the SQL. I'll see what I can do to respond to the challenge. I assume there is an SQLite database somewhere I can check it on. Regards David M Bennett FACS Andl - A New Database Language - andl.org -----Original Message----- From: sqlite-users-boun...@mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Richard Hipp Sent: Friday, 5 June 2015 9:11 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] User-defined types On 6/4/15, Darko Volaric <lists at darko.org> wrote: > > What is motivating this for me is that I generate many unique queries > in my code for almost any operation. Converting those to SQL is error > prone and uses a lot of memory compared to the operation involved. The > database engine is so fast and efficient yet I'm wasting resources making SQL! > You are welcomed to go off and try to come up with a new and better interface. That's the beauty of open-source. Maybe you will come up with some new and innovative ideas that will change the industry! It's happened before! I just want to ensure that if, after working on your new approach for a while, you eventually decide that SQL isn't quite as bad a language as you originally thought it was, that you don't come back and say I didn't warn you. -- D. Richard Hipp drh at sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users at mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users