www.digitalmars.com         C & C++   DMDScript  

digitalmars.D - DSQLite a libraryri using sqlite

reply bioinfornatics <bioinfornatics fedoraproject.rog> writes:
Dear,

i have wrote a litlle lib using etc.c.sqlite3 for use sqlite in D
Now it is  most easier to use sqlite in D than directly use C interface

I have put here :
https://github.com/bioinfornatics/DSQLite/blob/master/examples/test_sql.d

an example of use

I need now comment my code

any help or feed back is welcome

kind regards
Nov 04 2011
next sibling parent mta`chrono <chrono mta-international.net> writes:
Hi bioinfornatics,

I recognized you'd used "Variant" as datatype. Did you define your own
Variant Type or is that the default one? But neverthenless your code
simplyfiecs using sqlite.

- mta`chrono
Nov 07 2011
prev sibling next sibling parent reply bls <bizprac orange.fr> writes:
On 11/04/2011 11:47 AM, bioinfornatics wrote:
 i have wrote a litlle lib using etc.c.sqlite3 for use sqlite in D
 Now it is  most easier to use sqlite in D than directly use C interface

 I have put here :
 https://github.com/bioinfornatics/DSQLite/blob/master/examples/test_sql.d

Here we are again. Again, Zero coordination in Phobos development. -You are working on SQLite, -Steve is working on MySQL / and more important .. on std.database -Piotr is working on PostgreSQL, Steve started his development based a the MySQL CAPI, works almost fine until - Ultra-nervous License obsessed people bashed that approach... Sad. //Beside what was the CAPI manifesto good for ?. A fee weeks ago I wrote a mail to Steve, in which I mention that a Top-Down development would make more sense . Means Interfaces/ Design first.. detail implementation later. It is indeed very frustrating but I have to say : Sorry Steve, IMHO you don't see the big picture. std.database will fail. _SQLite_ Now you came up with a higher level wrapper around sqlite, which is for sure not compatible to whatever Steve or Piotr have in mind. -- .....I am afraid that Phobos will take another 3 years to consolidate. std.database is just another indication for that.. my 2 Euro cents ( pretty weak nowadays :) Bjoern.
Nov 07 2011
next sibling parent Dejan Lekic <dejan.lekic gmail.com> writes:
bls wrote:

 Here we are again.
 Again, Zero coordination in Phobos development.

Pardon me, how this relates to Phobos? The projects you mentioned are all independent ones... OK, they might one day be merged with Phobos, but it seems to me like they are all independently developed because respecful authors have a need for them... :)
Nov 07 2011
prev sibling next sibling parent Jesse Phillips <jessekphillips+D gmail.com> writes:
bls Wrote:

 Here we are again.
 Again, Zero coordination in Phobos development.
 -You are working on SQLite,
 -Steve is working on MySQL / and more important .. on std.database
 -Piotr is working on PostgreSQL,

One thing that stands out at me is that your list includes work for three different databases. Of such probably because the developer wanted to use such database, and use it with a D interface. But this means we have three people who have some familiarity of what is needed to use a database, that know what they like, and hopefully can communicate with each other to develop a good proposal for how std.database should be done. If you are going to develop an interface it is good to research different approaches, it is even better to try them out. I've mostly refrained from comment as I don't know what I want. I like the looks of this one, but I don't understand the underlining that is the DB network.
Nov 07 2011
prev sibling next sibling parent Jacob Carlborg <doob me.com> writes:
On 2011-11-07 18:18, bls wrote:
 On 11/04/2011 11:47 AM, bioinfornatics wrote:
 i have wrote a litlle lib using etc.c.sqlite3 for use sqlite in D
 Now it is most easier to use sqlite in D than directly use C interface

 I have put here :
 https://github.com/bioinfornatics/DSQLite/blob/master/examples/test_sql.d

Here we are again. Again, Zero coordination in Phobos development. -You are working on SQLite, -Steve is working on MySQL / and more important .. on std.database -Piotr is working on PostgreSQL, Steve started his development based a the MySQL CAPI, works almost fine until - Ultra-nervous License obsessed people bashed that approach... Sad. //Beside what was the CAPI manifesto good for ?.

I think the CAPI manifest was not for inclusion in Phobos which mean the license doesn't matter and it's up to the user to choose if he/she wants to use it. -- /Jacob Carlborg
Nov 07 2011
prev sibling parent mta`chrono <chrono mta-international.net> writes:
 .....I am afraid that Phobos will take another 3 years to consolidate.
 std.database is just another indication for that..
 my 2 Euro cents   ( pretty weak nowadays :)
 Bjoern.

Yes, you're right there is no coordination in development. Some are talking about CAPI Manifesto and some others are talking about deimos. There is https://github.com/D-Programming-Language/deimos And there is: https://github.com/D-Programming-Deimos/ There are pending pull requests, so what are we waiting for?
Nov 08 2011
prev sibling next sibling parent Steve Teale <steve.teale britseyeview.com> writes:
 Again, Zero coordination in Phobos development. -You are working on
 SQLite,
 -Steve is working on MySQL / and more important .. on std.database
 -Piotr is working on PostgreSQL,
 
 Steve started his development based a the MySQL CAPI, works almost fine
 until - Ultra-nervous License obsessed people bashed that approach...
 Sad.
 //Beside what was the CAPI manifesto good for ?.
 
 A fee weeks ago I wrote a mail to Steve, in which I mention that a
 Top-Down development would make more sense . Means Interfaces/ Design
 first.. detail implementation later.
 It is indeed very frustrating but I have to say : Sorry Steve, IMHO you
 don't see the big picture. std.database will fail.
 
 _SQLite_
 Now you came up with a higher level wrapper around sqlite, which is for
 sure not compatible to whatever Steve or Piotr have in mind. --
 .....I am afraid that Phobos will take another 3 years to consolidate.
 std.database is just another indication for that.. my 2 Euro cents   (
 pretty weak nowadays.

Bjoern, There was little consensus in the discussion about the higher-level std.database, so I feel that I need to know more about what is possible before we start on what may well be a lowest common denominator approach that will suit nobody. I've looked at Piotr's stuff, and I can see more similarities than differences in the end result of what he is doing and what I am doing. There is at least one other person I've been in contact with who is working on SQLite. I have done something in this general direction with ODBC in the past, and have a fairly clear idea of what can be done there. Once we have a firm Idea of the set of common facilities that are available given licensing restrictions etc I want to provoke the higher level discussion again with the focusing element of a background paper that summarizes what can be done, and what is actually available as building blocks. Then the ORM people and the rest can fight it out and we'll see if some sort of consensus can emerge. In a situation where you are herding cats it might be good to have some bait. In this case the prospect of a relatively rapid outcome if people could agree on what is needed. I think that this approach is more likely to work than one where I do some sort of high level design and then we just have another round of disagreement. If you have a strong view about what the higher level approach should look like, please do a sketch of it. I have no problem if someone else is the primary author. Steve.
Nov 07 2011
prev sibling parent bioinfornatics <bioinfornatics fedoraproject.rog> writes:
Le lundi 07 novembre 2011 =C3=A0 12:27 +0100, mta`chrono a =C3=A9crit :
=20
 I recognized you'd used "Variant" as datatype. Did you define your own
 Variant Type or is that the default one? But neverthenless your code
 simplyfiecs using sqlite.
=20
 - mta`chrono=20

Thanks mta`chrono i have use Variot from std.variant (default)=20 Currently this code is released to GPLv3 but i could give this code to phobos is not a problem or to anyone who would like doing std.database. Take the code and enhance it kind regards
Nov 08 2011