<?xml version="1.0" encoding="windows-1252"?>
<node id="700497" title="Re: Perl ORM comparison (Class::DBI vs. DBIx::Class vs. Rose::DB::Object)" created="2008-07-28 06:42:27" updated="2008-07-28 02:42:27">
<type id="11">
note</type>
<author id="421282">
phaylon</author>
<data>
<field name="doctext">
&lt;p&gt;Just some comments…

&lt;p&gt;As a Class-DBI Con you have

&lt;blockquote&gt;&lt;i&gt;Single author =&gt; single point of failure&lt;/i&gt;&lt;/blockquote&gt;

&lt;p&gt;but then, in the DBIx-Class Cons you have

&lt;blockquote&gt;&lt;i&gt;Multiple contributions =&gt; less coherence expected.&lt;/i&gt;&lt;/blockquote&gt;

&lt;p&gt;What do you think is better now, more or less contributors?

&lt;p&gt;Also, DBIx-Class seems to be both, the &lt;i&gt;"Second worst performance"&lt;/i&gt; and the &lt;i&gt;"Second best performance"&lt;/i&gt; which both are Pros and Cons in your list. Is it really both a pro and a con when it is in the middle?

&lt;blockquote&gt;&lt;i&gt;No support for customizable column inflation/deflation. (is this true?)&lt;/i&gt;&lt;/blockquote&gt;

&lt;p&gt;No, it's not. There are already some column inflation extensions available on CPAN.

&lt;blockquote&gt;&lt;i&gt;No distinction for "primary/essential/other/all" column kinds except for primary key and "others". (Maybe a performance issue for large columns.) (is this true?)&lt;/i&gt;&lt;/blockquote&gt;

&lt;p&gt;DBIx-Class lets you specify what fields you want to have in the resultset.

&lt;p&gt;Also, what do you mean by &lt;i&gt;No support for static class metadata generation.&lt;/i&gt;? If you mean DBIC can't create the classes for you, you haven't taken a look at DBIx-Class-Schema-Loader.

&lt;p&gt;Also, your DBIx-Class Con list contains &lt;b&gt;both&lt;/b&gt; of these:

&lt;blockquote&gt;&lt;i&gt;Does NOt have seamless support for handy database domains (production, test, dev, staging, ...) and types (main, archive, reporting, ...). &lt;br&gt;
…&lt;br&gt;
Supports the innovative concepts of database domain(production, test, dev, staging, ...) and database type (main, arcvhive, reporting, ..).&lt;/i&gt;&lt;/blockquote&gt;

&lt;!-- Node text goes above. Div tags should contain sig only --&gt;
&lt;div class="pmsig"&gt;&lt;div class="pmsig-421282"&gt;
&lt;hr&gt;Ordinary morality is for ordinary people. -- Aleister Crowley
&lt;/div&gt;&lt;/div&gt;</field>
<field name="root_node">
700283</field>
<field name="parent_node">
700283</field>
</data>
</node>
