Most of the modules that I write for such applications inherit from a common base database class (think home grown Class::DBI) and have intrinsic class-based handle sharing but its all the same idea.
None of the website code cares about database details whatsoever. Abstraction and website code simplification are your friends. Well, abstraction and efficient caching and code simplification. And ... :)
Hi Andrew,
Yeah something like that does seem to make sense. However when you say you've abstracted everything from the website code, how abstracted do you mean? For example what I do now is do a connect in each file (with variables from a config file for username, db, etc) and then use the DBI interface to run a sql query or insert data, etc. How would your method be better? Are you removing all sql statements from your code and just making calls to the module which returns data? Is it just neater that way?
Have a look at a couple of my sites, http://catstevens.com/ and http://robbiefulks.com/ . They are both running the same software, in fact the code is in a main directory on the server and symlinked into each sites document root. This way I'm forced to make my code portable or I'll break things! :-) See the forums and community features (feel free to sign up for instance).
Anyhow there are so many database calls and things going on that are unique to each section of the site that I'm not sure how much abstraction would be possible. That is depending on what you mean by that.
I'm in the middle of a major upgrade right now that is focused on XHTML/CSS standards compliance and I figured now is the time to atone for some sins since I'm already ripping the code apart. :-)
As I said before I could easily do something like this, and have an interest in it. But I wouldn't want to step on anyones toes. If someone else had plans to do it then that's great. But if not I'd be happy to. I would just like a site like that to exist, regardless of who does it. Gerald, any thoughts?There was talk of setting up something like this not-quite-so-recently. Gerald has adapted several posts into HOWTO's and the like but I can't recall a specific site.
I'd certainly be interested.
Cheers, John
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
