Small and simple database?

Ok, I want to make a program that requires a database. But it only requires a local database that can reside in a single file. It doesn't have to be relational or anything. So just about every SQL database is overkill for this application. I thought about something like berkdb and I found ruby-bdb, but it is documented poorly and I can't figure out how to use it. I basically need a flat record table which I can query. I would use csv, but that is actually slightly underpowered.

Can someone make a good suggestion for a database to use and also point to documentation on how to create ruby applications with that database? Thanks.

Scott Rubin wrote:

Ok, I want to make a program that requires a database. But it only requires a local database that can reside in a single file. It doesn't have to be relational or anything. So just about every SQL database is overkill for this application. I thought about something like berkdb and I found ruby-bdb, but it is documented poorly and I can't figure out how to use it. I basically need a flat record table which I can query. I would use csv, but that is actually slightly underpowered.

Can someone make a good suggestion for a database to use and also point to documentation on how to create ruby applications with that database? Thanks.

SQLite is pretty small and easy to use,

http://rubyforge.org/projects/sqlite-ruby/

http://www.sqlite.org/

Zach

You should probably consider XML or YAML. Would that suit your needs?

Kind Regards,
Ed

···

On Wed, 2 Feb 2005 00:20:45 +0900, Scott Rubin <slr2777@cs.rit.edu> wrote:

Ok, I want to make a program that requires a database. But it only requires a
local database that can reside in a single file. It doesn't have to be
relational or anything. So just about every SQL database is overkill for this
application. I thought about something like berkdb and I found ruby-bdb, but it
is documented poorly and I can't figure out how to use it. I basically need a
flat record table which I can query. I would use csv, but that is actually
slightly underpowered.

--
Alcohol is the anesthesia by which we endure the operation of life.
-- George Bernard Shaw

Scott Rubin wrote:

Ok, I want to make a program that requires a database. But it only requires a local database that can reside in a single file. It doesn't have to be relational or anything. So just about every SQL database is overkill for this application. I thought about something like berkdb and I found ruby-bdb, but it is documented poorly and I can't figure out how to use it. I basically need a flat record table which I can query. I would use csv, but that is actually slightly underpowered.

Can someone make a good suggestion for a database to use and also point to documentation on how to create ruby applications with that database? Thanks.

I have a DBMS called KirbyBase that might fit the bill. There is a version written in Ruby and one in Python. I just updated the python version and hope to get the ruby version updated soon.

If you do take a look at it, you will find the updated manual in the python 1.7.1 version much improved over the manual in the ruby 1.6 version. Most of the python version manual will apply to the ruby version.

More info on KirbyBase is at:

http://www.netpromi.com/kirbybase.html

Hope this helps.
Jamey Cribbs

Confidentiality Notice: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and/or privileged information. If you are not the intended recipient(s), you are hereby notified that any dissemination, unauthorized review, use, disclosure or distribution of this email and any materials contained in any attachments is prohibited. If you receive this message in error, or are not the intended recipient(s), please immediately notify the sender by email and destroy all copies of the original message, including attachments.

"Scott Rubin" <slr2777@cs.rit.edu> schrieb im Newsbeitrag
news:41ff9cf0$1@buckaroo.cs.rit.edu...

Ok, I want to make a program that requires a database. But it only

requires a

local database that can reside in a single file. It doesn't have to be
relational or anything. So just about every SQL database is overkill

for this

application. I thought about something like berkdb and I found

ruby-bdb, but it

is documented poorly and I can't figure out how to use it. I basically

need a

flat record table which I can query. I would use csv, but that is

actually

slightly underpowered.

Can someone make a good suggestion for a database to use and also point

to

documentation on how to create ruby applications with that database?

Thanks.

If it fits into memory, you might use ( Hash OR Array OR
YourSelfCreatedContainer ) AND ( Marshal OR Yaml ). Alternatively you can
use rexml and get the query language for free (although it's not SQL but
XPath). PStore is another alternative.

Kind regards

    robert

dbdbd

http://knossos.shu.edu/dblack/dbdbd

         HTH
         Hugh

···

On Wed, 2 Feb 2005, Scott Rubin wrote:

Ok, I want to make a program that requires a database. But it only requires a local database that can reside in a single file. It doesn't have to be relational or anything. So just about every SQL database is overkill for

* Scott Rubin wrote:

Can someone make a good suggestion for a database to use and also point to
documentation on how to create ruby applications with that database? Thanks.

I find QDBM easy to use.
<http://qdbm.sourceforge.net/&gt;

Installation and example for use with Ruby:
<http://qdbm.sourceforge.net/rbspex.html&gt;

···

--
Oliver C.
45n31, 73w34
Temperatur: -4°C

* Zach Dennis <zdennis@mktec.com> [0223 15:23]:

Scott Rubin wrote:
>Ok, I want to make a program that requires a database. But it only
>requires a local database that can reside in a single file. It doesn't
>have to be relational or anything. So just about every SQL database is
>overkill for this application. I thought about something like berkdb
>and I found ruby-bdb, but it is documented poorly and I can't figure out
>how to use it. I basically need a flat record table which I can query.
>I would use csv, but that is actually slightly underpowered.
>
>Can someone make a good suggestion for a database to use and also point
>to documentation on how to create ruby applications with that database?
>Thanks.

SQLite is pretty small and easy to use,

+1, it's fast too.

(It's constraint checking is a bit rubbish, but then you didn't want
an RDBMS anyway, right?)

···

--
'When the door hits you in the ass on the way out, clean off the smudge
your ass leaves, please'
    -- Alien loves Predator
Rasputin :: Jack of All Trades - Master of Nuns

Amen to SQLite - I use it all the time for almost any type of local
data storage.

-Rich

···

On Wed, 2 Feb 2005 01:19:35 +0900, Dick Davies <rasputnik@hellooperator.net> wrote:

* Zach Dennis <zdennis@mktec.com> [0223 15:23]:
> Scott Rubin wrote:
> >Ok, I want to make a program that requires a database. But it only
> >requires a local database that can reside in a single file. It doesn't
> >have to be relational or anything. So just about every SQL database is
> >overkill for this application. I thought about something like berkdb
> >and I found ruby-bdb, but it is documented poorly and I can't figure out
> >how to use it. I basically need a flat record table which I can query.
> >I would use csv, but that is actually slightly underpowered.
> >
> >Can someone make a good suggestion for a database to use and also point
> >to documentation on how to create ruby applications with that database?
> >Thanks.
>
> SQLite is pretty small and easy to use,

+1, it's fast too.