From: "Hal E. Fulton" Date: 2003-05-30T04:34:18+09:00 Subject: Re: Metakit for Ruby - Would you want it? ----- Original Message ----- From: "Brian Candler" To: "ruby-talk ML" Sent: Thursday, May 29, 2003 2:11 PM Subject: Re: Metakit for Ruby - Would you want it? > On Fri, May 30, 2003 at 04:02:07AM +0900, Anders Borch wrote: > > what I would like is an embedded sql database. It seems to me that > > metakit does not have an sql parser. having an sql parser would let me > > make a dbi interface and use an embedded database w/o changing a single > > line of code. I'm also interested in this. I suppose the db code is all part of the app, and the database data is more or less a single file? That's my idea of small footprint. > You mean like sqlite? http://www.sqlite.com/ > > There are ruby bindings which work more or less (get the latest ruby-dbi-all > from CVS) Hmm. Can it do record-level locking? E.g., suppose multiple threads or processes are accessing the database? > However, IMO, SQL makes for a dreadful API. I have been writing some code > which I try to run with sqlite (for Unit testing), mysql (for a staging > area) and Oracle (for live production). It's been a complete nightmare. It's > all just so non-standardised when it gets down to the nitty gritty. Ha... I once did ANSI compliance testing for a SQL implementation. Boy, that was entertaining. At that time, there were as many errors in the test suite as in the database code. I've toyed with the idea of "RQL" (Ruby Query Language) which would be similar in spirit to SQL but allow things like "MATCHES regex" and so on. But that's something that will never actually materialize. There are a dozen higher-priority things on my list, many of which will also never get implemented. :) Cheers, Hal