How do you talk to a BerkeleyDB database from Ruby or Ruby on Rails?

views:

343

answers:

+1 Q:

How do you talk to a BerkeleyDB database from Ruby or Ruby on Rails?

I have no idea how I would set up a BerkelyDB database in a Ruby or Rails project.

Does anyone have any experience configuring one, that they could talk about?

Maybe using ActiveRecord or Datamapper?

i think you can use MySQL and use the BerkeleyDB storage engine and use ActiveRecord or DataMapper as usual. Will be cool to use BDB that way. try this: http://dev.mysql.com/doc/refman/5.0/en/bdb-storage-engine.html

auvi 2009-06-14 02:21:01

You can't use it with ActiveRecord or DataMapper (unless you're using MySQL with BerkeleyDB as the storage engine, as auvi said), but you can use the BDB library. Here is some basic example code.

I don't know if there's a specific reason you need BerkeleyDB, but chances are that you don't. Unless all you need is to store one big huge hash table, I'd stick to SQLite or, even better, MySQL or PostgreSQL. Berkeley doesn't give you any relational functionality such as joins, so you have to write those yourself (not to mention the API is kind of messy).

musicfreak 2009-06-14 02:31:13

Downvoted because Sql databases don't automatically equal "better", which is a highly subjective term anyway. There are loads of reasons why someone or a company might choose BDB and just hand-waving a BS answer like "just use a sql database" id too dismissive of the OP's question. Also downvoted because "get" and "put" are about as simple and elegant as APIs can come...

Shaun 2009-08-15 16:06:27

@Shaun: I gave a legitimate answer, and then I stated that it *may* not be necessary to use BDB, considering the OP wants to use it with ActiveRecord. I don't know the OP's specific situation, and if he has a perfectly valid reason to use BDB, more power to him. However, most of the time, people try to use a non-relational database just for the sake of being different, which I don't think makes any sense. Either way, I don't know why I got a downvote because I did answer his question in the first part of my answer.

musicfreak 2009-08-15 19:15:52

+2 A:

I would use Moneta: http://github.com/wycats/moneta/tree/master

BJ Clark 2009-06-14 05:07:34

Me too. That's great. Thanks. Btw, I'd like to persist an entity, in case you have any ideas: http://stackoverflow.com/questions/992173/how-would-you-represent-a-relational-entity-as-a-single-unit-of-retrievable-data/992223#992223

Hank 2009-06-14 06:03:04

ansaurus

tags:

views:

answers:

How do you talk to a BerkeleyDB database from Ruby or Ruby on Rails?

related questions