I am afraid this discussion has done more to confuse me then clear things up. I am in the process of building an application builder that reads database table definitions and creates the base pages for the application. I want to do this in a database generic way. From the start of this discussion I thought DBIx::AnyDBD was possibly more flexible, but in later parts of the thread it seems that it isn't flexible.
What is currently the most flexible module available - I define flexible as: - Capable of complex query statements - Support for all DBD drives without recoding ( I understand there will be exceptions ) - Support for auto_increment style fields that return the last ID What are other people using? I had started the development of my project making it MySQL depenedent, but that was simply a comfort thing for me. Also the statement made by Stephen about the fact that supporting complex queries isn't always the anwser rings more true to me then what others have said, but if there is a module that supports these things and allows for correct cross table data combination in a format that is digestable by humans I would like to know. I have been using separate queries. Part of my application builder uses data aggregation for the results display. I have used it in a production environment and by limiting the size of the dataset returned I don't find speed to be an issue, even when implemented as CGI on a non mod_perl web server. Aaron Johnson Dave Rolsky wrote: > > On Wed, 27 Feb 2002, Matt Sergeant wrote: > > > Right, so how would I go about writing an application that used Class::DBI > > that absolutely needed outer joins (say, for example, a bulletin board > > type application that supported anonymous postings), and I wanted it to > > work cross platform? > > Just like with DBIx::AnyDBD, you'd have to have one subclass per RDBMS, > and custom code it for each (well, actually MySQL and Postgres share the > same syntax for outer joins these days). > > But with Alzabo you wouldn't need to do that! Of course, it only support > MySQL and Pg right now ;) > > -dave > > /*================== > www.urth.org > we await the New Sun > ==================*/
