On 9 Aug 2007, at 05:00, Martin Flack wrote: > For the type of thing like Connotea, Class::DBI is way too slow > left to its own devices - a page was taking 800 queries to pull up > all the pieces of data, and we solved that with a scary-looking but > fast-executing query. Another problem might be that it was designed > to be a very flexible query engine, and as it turns out that > flexibility is obscuring some of the functionality, i.e. tightening > the restraints might make prettier source code.
Oops, more on this. One of my associates in Catalyst land has implemented a del.icio.us clone in catalyst | dbic | tt | postgresql called linkmine. It's main flaw is that it uses the "nice-idea- but..." library HTML::Widget - but it's most interesting from the database side. I've only looked at the database superficially, but the schema looks superficially similar (but simpler also). With DBIC_TRACE=1 perl script/linkmine_server you can pretty much see what it's doing straight away. The author is ZBY from CPAN (http:// search.cpan.org/~zby/ , http://perlalchemy.blogspot.com/) and I'm sure he'd be amenable to either showing you the code or uploading the source to somewhere like sourceforge or google code if asked. If you've got relationships declared in your database schema, getting something with the basic functions you need written to disk is as simple as this: perl -MDBIx::Class::Schema::Loader=make_schema_at,dump_to_dir:/path/ to/lib -e \ 'make_schema_at("MySchemaName", {relationships => 1}, ["dbi:mysql:dbname=db", "user", "pass"])' which by default will provide a good deal more than Class::DBI::Loader, and in a sane extendable manner. Aside from this there's a ton of paid and community support for DBIx::Class (go to #dbix-class on irc.perl.org for details), and if there are bugs or missing features, it has a comprehnsive test suite, and commit to the svn is usually given out pretty freely after you've provided a couple of sane patches or tests. ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Connotea-code-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/connotea-code-devel
