On Thursday, 8 June 2017 at 13:06:55 UTC, Ozan (O/N/S) wrote:
> Your sqlite-d solution would be complete if writing sqlite files are also possible. Ignore the SQL parsing stuff, it does not fit in a world of fast data processing.

Writing or rather modifying sqlite-dbs is a bit harder then reading them.
Since the B-Tree should not get to imbalanced.

I started on write support a while back, but at that time I did not understand the structure well enough to guarantee efficient write-support. (which would also require you to keep the index updated and so on ...)

As for parsing sql.
Unfortunately the column information is stored in form of a create table statement which forces me to parse at-least that much sql.
In order to provide a nice interface in which you don't have to look up the position of your columns manually.

On Thursday, 8 June 2017 at 13:37:41 UTC, Russel Winder wrote:

> Exactly my point. Using SQLAlchemy made me actually enjoy writing database code. Which I did last year having avoided it

Using ORM like SQLAlchemy certainly has benefits but like any other ORM, it generates hideous SQL code, sometimes terribly slow...

On Thu, 2017-06-08 at 14:55 +0000, Dejan Lekic via Digitalmars-d wrote:
> On Thursday, 8 June 2017 at 13:37:41 UTC, Russel Winder wrote:
> 
> > Exactly my point. Using SQLAlchemy made me actually enjoy writing database code. Which I did last year having avoided it
> 
> Using ORM like SQLAlchemy certainly has benefits but like any other ORM, it generates hideous SQL code, sometimes terribly slow...

SQLAlchemy is not just an ORM, though there is an ORM, there is also the expression language which is an internal DSL for writing SQL.

Also the authors of SQLAlchemy do optimise the generated SQL. Though obviously if you are needing the optimal dark corner optimisation of Oracle 11.2.0.4 say, then you are on your own.

-- 
Russel. ============================================================================= Dr Russel Winder      t: +44 20 7585 2200   voip: sip:russel.winder@ekiga.net 41 Buckmaster Road    m: +44 7770 465 077   xmpp: russel@winder.org.uk London SW11 1EN, UK   w: www.russel.org.uk  skype: russel_winder

On Thursday, 8 June 2017 at 08:44:56 UTC, Russel Winder wrote:
> But what is D's equivalent to Python's SQLAlchemy? C++ now has sqlpp11.

There is HibernateD.

http://code.dlang.org/packages/hibernated

For my own project, I used handwritten SQL. It is still on my todo list to replace that with HibernateD. So, no practical experience, yet.