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 reply 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
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
prev 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 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 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