Re: mysql-native: Prepared statements: Direction and future

2018-01-16 Thread Martin Nowak via Digitalmars-d-announce

On Monday, 15 January 2018 at 19:41:42 UTC, H. S. Teoh wrote:

https://github.com/mysql-d/mysql-native/issues/95#issuecomment-357757013


I've added some thoughts.
https://github.com/mysql-d/mysql-native/issues/95#issuecomment-358110156

One of these days, we should draft up a "standard" API for SQL 
database bindings in D, so that implementations can benefit 
from a well thought out API design instead of rolling their own 
each time.


I'd hope that sth. emerges from MySQL-Native which is one of the 
more usable APIs atm.
I also like http://biozic.github.io/d2sqlite3/d2sqlite3.html but 
it follows MySQL-Natives bad example in that regard.


This is the design for more complex prepared statements in 
Cassandra.

https://docs.datastax.com/en/developer/java-driver/3.1/manual/statements/prepared/


Re: mysql-native: Prepared statements: Direction and future

2018-01-15 Thread H. S. Teoh via Digitalmars-d-announce
On Mon, Jan 15, 2018 at 01:30:42PM -0500, Nick Sabalausky (Abscissa) via 
Digitalmars-d-announce wrote:
> I've posted (what basically amounts to an article) about my current
> thoughts on addressing Prepared's current downsides in the next
> release (v2.0.0), as well as a little bit of future direction of the
> lib.
> 
> Anyone interested in mysql-native's prepared statements (especially
> their interplay with connection pools) is encouraged to take a look
> and share any thoughts:
> 
> https://github.com/mysql-d/mysql-native/issues/95#issuecomment-357757013

A lot of what you discuss here is pertinent not only to mysql-native,
but to (SQL) database bindings in general.  I've been facing much the
same questions in my own SQLite bindings, which are based on Adam
Ruppe's sqlite.d.

One of these days, we should draft up a "standard" API for SQL database
bindings in D, so that implementations can benefit from a well thought
out API design instead of rolling their own each time.


T

-- 
"If you're arguing, you're losing." -- Mike Thomas


mysql-native: Prepared statements: Direction and future

2018-01-15 Thread Nick Sabalausky (Abscissa) via Digitalmars-d-announce
I've posted (what basically amounts to an article) about my current 
thoughts on addressing Prepared's current downsides in the next release 
(v2.0.0), as well as a little bit of future direction of the lib.


Anyone interested in mysql-native's prepared statements (especially 
their interplay with connection pools) is encouraged to take a look and 
share any thoughts:


https://github.com/mysql-d/mysql-native/issues/95#issuecomment-357757013