What library functionality would you most like to see in D?
Johann MacDonagh
johann.macdonagh.no at spam.gmail.com
Tue Aug 2 17:03:37 PDT 2011
On 8/2/2011 7:39 PM, Adam Ruppe wrote:
> Johann MacDonagh wrote:
>> Perhaps we should start taking a look at it,
>> making it "Phobos-like", and create bindings for a set of databases.
>
> In my collection, I have (kinda crappy) implementations of my
> interface for mysql, postgres, sqlite and most recently ODBC.
>
> Since they all use C libs though, I'm not really completely sure
> on if they are license compatible with phobos. And, of course, I'm
> happy with a minimal set of features; I'm happy enough with strings
> since it's better than PHP, so mission accomplished.
>
> (I also have a lot of other code. Check out the readme in my github
> for a listing of many of them.)
Sounds like a good starting point. I've also written some code for
allowing "LINQ" style queries in D. You'd be able to do something like:
auto x = new SqliteConnection("mydata.db");
foreach(y; x.MyTable.where("someField > 10"))
{
// y is a wrapper around Variant[string] with some opDispatch magic
writeln(to!string(y.MyField));
writeln(to!int(y.SomeOtherField));
}
There were other things you could chain, such as:
x.MyTable.startAt(20).limit(10).where("blah").select("somefield",
"sometingElse");
You'd also be able to do something like
x.MyTable.select!MyStruct();
which would pull field names out of struct fields, and return a range of
structs rather than something that has to go through the Variant[string]
stuff.
It's just a prototype for now, I have a working POC for sqlite3 (however
it doesn't support the where clause ;) ), but it might be something
useful for quickly prototyping code that deals with databases.
Would you mind if I take some of your ideas and come up with a proposal
for the D community to talk about? Then we can discuss licensing issues
with various databases systems.
More information about the Digitalmars-d
mailing list