CTabular Data Stream libraries for Sybase and Microsoft DBMSs
C++database access library similar to
pkgjampackage management organized relationally (on hold, partner needed)
I've worked with
SQL since the the late 1980s. That work intersects naturally with other languages and technologies including Perl and NetBSD.
Relational scales just fine, thanks. There is an onslaught of “Big Data” these days, and there are applications that a bog-standard SQL DBMS can't handle. Not nearly as many as the current fascination with “NoSQL” would have you believe, though. If your database is measured in hundreds of gigabytes, a significant part of it — maybe all of it — can be in RAM. Such a server sounds expensive only until compared to salaries.
We must, indeed, all hang together, or most assuredly we shall all hang separately.
We have met the enemy and he is us.
A great deal of laudable effort is going into open-source “relational” DBMSs. Unfortunately for us all, that effort is not technically unified and most of it merely mimics what is already available from the famous proprietary vendors. Very little is grounded in relational theory or has a goal of a true Relational DBMS.
Unfortunately, the free SQL DBMS projects share no code. They have independent parsers, storage engines, wire protocols, and clients. They have distinct SQL grammars. There is no conference, not even a mailing list or usenet group, where they share information.
Relational: Free at Last discusses the state of free DBMS projects and what has to change if we are ever to move beyond SQL.
The above are “practical” projects; the implement SQL and are chasing the proprietary DBMSs. The most mature by far is Ingres, with Postgres and Firebird probably tied for second. SQLite gets honorable mention for ease of use as a public domain, library-only implementation.
By the way, complete SQL grammars in BNF form were prepared by one Jonathan Leffler. The world owes him applause.
The above projects implement Tutorial D, a relational query language defined by C.J. Date and Hugh Darwen. Unlike SQL, it adheres strictly to relational algebra.
I include sira_prise because of what we can learn from it in terms of its query language and theory. Unfortunately the restrictions make it impossible to build on or use in any significant way.
It is surprisingly difficult to find complete, authoritative information on the web for technologies and ideas that predate it. College course notes and blog entries abound, but thorough treatments are scarce and offline sources nearly always better.
If you, dear reader, have found a better online source that one of the books mentioned below, please tell me.