[RDBO] ANNOUNCE: Rose::DB::Object 0.54 released

2005-11-30 Thread John Siracusa
This is a double release, with a required new version of Rose::DB. The big new feature is SQLite support, but there have been many internal changes (and bug fixes) as well. This release also includes a bit of experimentation with prepare_cached(). The test suite passes, but let me know if somethi

[RDBO] New benchmark results posted

2005-11-30 Thread John Siracusa
I've updated the benchmarks with results form the latest versions of the ORM modules: http://rose.sourceforge.net/wiki/index.php/RDBO/Benchmark Class Version - --- Class::DBI v3.0.12 Class::DBI::Sweet 0.05 DBIx::Class0.04 Rose::DB::Object 0

[RDBO] DBIC and RDBO compared

2005-11-30 Thread John Siracusa
I just posted this to the Catalyst list, but I thought it might be of interest here as well. -John --- On 11/28/05 6:47 PM, Uwe Voelker wrote: > On Mon, 2005-11-28 at 14:00 +0100, [EMAIL PROTECTED] wrote: >> There are other ORMs available, but only one, DBIx::Class gets >> some attention here.

Re: [RDBO] column_type_class

2005-11-30 Thread Torsten Seemann
> BTW: What about MySQLs enum type? I think this could be emulated in Pg > with (var)char + CHECK: > MySQL: switch enum('off','on') NOT NULL DEFAULT 'off' > Pg:switch char(3) NOT NULL CHECK(switch IN (on,off)) DEFAULT 'off' Just keep in mind that MySQL 'ENUM' stores them as integers, and that

Re: [RDBO] column_type_class

2005-11-30 Thread John Siracusa
On 11/30/05 11:29 PM, Torsten Seemann wrote: > Just keep in mind that MySQL 'ENUM' stores them as integers, and that > integer is ALWAYS reserved to store the empty string '' as 0. So even if > you specify switch ENUM('off','on'), '' will also be valid. Er, is that considered a a feature? I mean,