Small and simple database?

[Scott Rubin]

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.

 

[Zach Dennis]

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

 

[Edgardo Hames]

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.

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

Kind Regards,
Ed

 

[Jamey Cribbs]

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.

 

[Robert Klemme]

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

 

[Hugh Sasse Staff Elec Eng]

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

dbdbd

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

HTH
Hugh

 

[Dick Davies]

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?)

 

[Richard Lyman]

+1, it's fast too.

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

-Rich

 

[Oliver Cromm]

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/>

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