[std.database]

[Robert Jacques]

On Mon, 10 Oct 2011 23:08:30 -0400, Johann MacDonagh <johann.macdonagh.no at spam.gmail.com> wrote:
> On 10/8/2011 2:43 AM, Steve Teale wrote:
>> I use this title at Andrei's suggestion, and repeat his idea that it be used
>> as a prefix for discussions as we navigate toward a design. Unless there is
>> resistance to the idea, I will on the job of implementing whatever we decide
>> is appropriate. I am retired, and have the time to do it.
>>
>> It seems that every man, and possibly his dog, has a private implementation
>> for at least a favorite DB, so we should have plenty of material to build on.
>>
>> At this point I would like to get responses from those who feel they are
>> likely to contribute to the design through to completion.
>>
>> I'd also like to get a feel for the magnitude of the task, so I'd like to ask
>> what database systems you think should be supported.
>>
>> I have started a github account, and will put my mysqld stuff there shortly,
>> then you can kick me out if you don't like what you see.
>>
>> Steve
>
> I've written up a prototype for a "LINQ" style database querying
> mechanism in D (read about "LINQ to SQL" if you've never heard of it).
> Legally speaking, it has very little to do with LINQ, but the concept is
> similar.
>
> Basically, it allows you to write code like this:
>
> 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));
> }

For what it's worth, my Variant proposal has this kind of opDispatch magic built-in.