Simple database.

Hi. I'm looking for a simple database that I can embed in a D application I'm writing. Apart from SQLite and Firebird what databases are available for embeding? I don't need a full fledge SQL server. Something that allows me to store a couple of tables with indexes for fast retrieval would be sufficient. SQL is not needed. Thanks.

In article <drrb8o$2dgr$1@digitaldaemon.com>, Roberto Baena says... > >Hi. > >I'm looking for a simple database that I can embed in a D application I'm writing. Apart from SQLite and Firebird what databases are available for embeding? > >I don't need a full fledge SQL server. Something that allows me to store a couple of tables with indexes for fast retrieval would be sufficient. SQL is not needed. > >Thanks. > Just curious, why not SQLite?

"Roberto Baena" <Roberto_member@pathlink.com> wrote in message news:drrb8o$2dgr$1@digitaldaemon.com... > Hi. > > I'm looking for a simple database that I can embed in a D application I'm writing. Apart from SQLite and Firebird what databases are available for embeding? > > I don't need a full fledge SQL server. Something that allows me to store a > couple of tables with indexes for fast retrieval would be sufficient. SQL > is not > needed. > Try one from Konstantin Knizhnik's databases : http://www.garret.ru/~knizhnik/databases.html In particular you can consider dyBase http://www.garret.ru/~knizhnik/dybase.html It has plain C API. Each record (aka object) is variable length set (array) of values. Records can contain references to other records - thus you can have tree like structure. And also you can create indexes on records. It has transactions and builtin GC (to delete all unreferenced records). And it is about 40k in binary or so. Andrew Fedoniouk. http://terrainformatica.com

February 02, 2006

Re: Simple database.

Posted by James Dunne
in reply to Dave

Permalink

James Dunne

Posted in reply to Dave

Permalink

Dave wrote:
> In article <drrb8o$2dgr$1@digitaldaemon.com>, Roberto Baena says...
> 
>>Hi.
>>
>>I'm looking for a simple database that I can embed in a D application I'm
>>writing. Apart from SQLite and Firebird what databases are available for
>>embeding?
>>
>>I don't need a full fledge SQL server. Something that allows me to store a
>>couple of tables with indexes for fast retrieval would be sufficient. SQL is not
>>needed.
>>
>>Thanks.
>>
> 
> 
> Just curious, why not SQLite?
> 
> 
> 

Believe me, don't go this route.  I had nothing but problems with it, especially in a multi-threaded context.  I'd get random sqlite error messages back with no rhyme or reason.  I must've read the docs on it at least a dozen times - still no help.  FYI - I used DDBI for the project, way back in its infancy.

-- 
-----BEGIN GEEK CODE BLOCK-----
Version: 3.1
GCS/MU/S d-pu s:+ a-->? C++++$ UL+++ P--- L+++ !E W-- N++ o? K? w--- O M--@ V? PS PE Y+ PGP- t+ 5 X+ !R tv-->!tv b- DI++(+) D++ G e++>e h>--->++ r+++ y+++
------END GEEK CODE BLOCK------

James Dunne

In article <drs6qq$1re$1@digitaldaemon.com>, Walter Bright says... > > >"Roberto Baena" <Roberto_member@pathlink.com> wrote in message news:drrb8o$2dgr$1@digitaldaemon.com... >> Hi. >> >> I'm looking for a simple database that I can embed in a D application I'm writing. Apart from SQLite and Firebird what databases are available for embeding? >> >> I don't need a full fledge SQL server. Something that allows me to store a couple of tables with indexes for fast retrieval would be sufficient. SQL is not needed. > >www.digitalmars.com/d/phobos/std_openrj.html Is there a facility to add records and then write the openrj database back to disk, or does one just foreach { printf(...); } the contents each time? Kevin

"Kevin Bealer" <Kevin_member@pathlink.com> wrote in message news:drtkp9$18h5$1@digitaldaemon.com... > In article <drs6qq$1re$1@digitaldaemon.com>, Walter Bright says... >>www.digitalmars.com/d/phobos/std_openrj.html > > Is there a facility to add records and then write the openrj database back > to > disk, or does one just foreach { printf(...); } the contents each time? It's just a text file, so rewriting it each time is the most practical.

"Walter Bright" <newshound@digitalmars.com> wrote in message news:drtt69$1gp4$1@digitaldaemon.com... > > "Kevin Bealer" <Kevin_member@pathlink.com> wrote in message news:drtkp9$18h5$1@digitaldaemon.com... > > In article <drs6qq$1re$1@digitaldaemon.com>, Walter Bright says... > >>www.digitalmars.com/d/phobos/std_openrj.html > > > > Is there a facility to add records and then write the openrj database back > > to > > disk, or does one just foreach { printf(...); } the contents each time? > > It's just a text file, so rewriting it each time is the most practical. Lars had some ideas last year about adding that functionality, but I never got time to address them. I still hope to do it, once I'm over my current hump. (I recognise the contradiction in this with my other post <g>. Tools & Libraries. Tools & Libraries. Tools & Libraries. . . . )

Roberto Baena wrote: > Hi. > > I'm looking for a simple database that I can embed in a D application I'm > writing. Apart from SQLite and Firebird what databases are available for > embeding? > > I don't need a full fledge SQL server. Something that allows me to store a > couple of tables with indexes for fast retrieval would be sufficient. SQL is not > needed. > > Thanks. > > May I suggest using whatever database you are most familiar with, setting up an ODBC datasource, and using DDBI to easily establish a connection to it? Certainly, I'm biased, because I finished this integration only a few days ago, but I'd be happy to help you if anything comes up. :) Of course, it does require issuing SQL commands... I can't quite tell if you mean that it's not "needed" or if it's not "needed or wanted!" ;) You shouldn't have any trouble setting up an ODBC connection to just about anything... -Mark D

Forums