[cumbria_lug] Dilemma...

[Martin Alderson]

On 16 Apr 2004, at 10:22, Schwuk wrote:

> I'm in process of writing YACMS (Yet Another Content Managment 
> System), but before I get too far into the development I need to 
> overcome a dilemma I'm having...
>
> Is it better to design technically, or for portability?
>
> My first real experience of RDBMS's was MySQL with Perl & PHP, doing 
> all the clever stuff in code. Then I moved onto MSSQL and ASP.NET, 
> moving stuff from code into the DB where applicable (views, stored 
> procedures and triggers) and producing much leaner code.
>
> For my YACMS, my preference would be to use PostgreSQL over MySQL as 
> that would allow me to use the DB features I'm used to, but I believe 
> (hope) other people may want to use it. I'll be using a DB extraction 
> layer like PEARs DB, so porting between DBs should be straight 
> forward, but it's the database features I want to design for, not a 
> particular database. The project will be OSS, so people can change it 
> as they see fit, but I don't really want to lock out non-developers 
> either.
>
> So, should I go the technical high road or the portability low road?

Write as much stuff as possible in code. Portability is vital in open 
source projects, and you need to appeal to the majority of people who 
will be using mySQL.

Martin Alderson,
IntechHosting

Email: martin at intechhosting.co.uk
Web: http://www.intechhosting.co.uk