Re: [CDBI] mysql compress support

[prev] [thread] [next] [Date index for 2005/09/19]

From: John Siracusa
Subject: Re: [CDBI] mysql compress support
Date: 17:18 on 19 Sep 2005
On Tue Aug 30 15:04:01 Matt S Trout wrote:
> Rose::DB has a reasonable interface and is very fast, but it's making the
> same SQL-liberally-sprinkled-in-the-code mistakes that the Tangram project
> is currently working hard to refactor out (and making fantastic progress too
> - you should drop in and see how they're getting on as well).
>
> For example (from Rose::DB::Object::MetaData) -
> 
> sub insert_sql
> {
>   my($self) = shift;
> 
>   no warnings;
>   return $self->{'insert_sql'} ||=
>     'INSERT INTO ' . $self->fq_table_sql . "\n(\n" .
>     join(",\n", map { "  $_" } $self->column_names) .
>     "\n)\nVALUES\n(\n" . join(",\n", map { "  ?" } $self->column_names) .
>     "\n)";
> }

That's not a "mistake" unless it prevents RDBO from achieving its design
goals.  I don't intend to support anything but SQL-based databases via DBI.
OTOH, speed is an important design goal, for which I've traded a lot--but
only in the internals, not in the public or "protected" API (of which the
above code is not part, BTW).  I suffer so you don't have to(tm) ;)

(sorry for the late reply, I just joined :)
-John



_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi

(message missing)

[CDBI] mysql compress support
Ilia Lobsanov 00:18 on 25 Aug 2005

Re: [CDBI] mysql compress support
John Siracusa 17:18 on 19 Sep 2005

[CDBI] mysql compress support
Ilia Lobsanov 01:15 on 29 Aug 2005

Re: [CDBI] mysql compress support
William Ross 12:40 on 30 Aug 2005

Re: [CDBI] mysql compress support
Matt S Trout 14:04 on 30 Aug 2005

Generated at 16:14 on 20 Sep 2005 by mariachi v0.52