Indeed, you're right - there was a multitude of products like that, and linked in libraries for managing databases.
That said, I'm not aware of anyone doing that with SQL before SQLite. Though I might well have missed some.
That said, I'm not aware of anyone doing that with SQL before SQLite. Though I might well have missed some.
It wasn't just used by MS Access, its was used from VB and other languages because it was just an ODBC/OLEDB driver.
https://en.wikipedia.org/wiki/Access_Database_Engine
FoxPro looks like it supported SQL in V2 in 1991
https://www.landley.net/history/mirror/collate/foxpro/foxpro...
> You can also create a Dynaset variable using an SQL string instead of the name of an existing table or query:
Dim db As Database, dsSomeData As Dynaset, SQL
Set db = OpenDatabase("NWIND.MDB")
SQL = "SELECT * FROM Employees WHERE Employees![City] = 'London';"
Set dsSomeData = db.CreateDynaset(SQL)
It had a nice visual builder for queries took me a while to appreciate writing them in SQL, many people never knew it was in there.
There were also minimalist SQL interfaces to say BerkeleyDB and DBM around.
It was a rival of MySQL for a while. The article says "mSQL was the first low-cost SQL-based database management system" but notes citation needed. Certainly matches my memory though.
Home page: https://hughestech.com.au/products/msql/
[I thought it could run serverless but maybe that was very early versions if at all]
I also vaguely remember an optional SQL interface for Btrieve circa 1990, but I might be mistaken.
We had it in an application written in C.