On Thursday, 31 December 2015 at 17:14:55 UTC, Piotrek wrote:
The goal of this post is to measure the craziness of an idea to
embed a database engine into the D language ;)
I think about a database engine which would meet my three main
requirements:
- integrated with D (ranges)
- ACID
- fast
Since the days when I was working on financing data SW I become
allergic to SQL. I though that NoSQL databases would fill the
bill. Unfortunately they didn't. And I want to have an ability
to write a code like this without too much effort:
struct Person
{
string name;
string surname;
ubyte age;
Address address;
}
DataBase db = new DataBase("file.db");
auto coll = db.collection!Person("NSA.Registry");
auto visitationList = coll.filter!(p => p.name == "James");
writeln (visitationList);
And other things like updating and deleting from db. I think
you get my point.
So I started a PoC project based on SQLite design:
https://github.com/PiotrekDlang/AirLock/blob/master/docs/database/design.md#architecture
The PoC code:
https://github.com/PiotrekDlang/AirLock/tree/master/src/database
Can you please share your thoughts and experience on the topic?
Has anyone tried similar things?
Piotrek
You know someone needs to maintain all that code base
continuously. When SQLite is a separate project, it has its own
developers and we just bind to its library; it is same for other
DBs. Your proposal is nice, but creating another standard, and a
group of people needs to take care of it in both documentation
and coding wise continuously are biggest issues.
