By Date: <-- -->
By Thread: <-- -->

MySQL all the way

Mark Frawley wrote:
> We use MySQL exclusively, added my vote for it, seems to be the 
> favourite so
> far, with Postgres close behind which is what I would have guessed. Just
> curious, are any steps planned to deprecate support for unpopular databases
> or is this just to know which systems are most important for testing?

Both, i guess. We obviously already know that mysql and postgres are 
the two popular ones. I created the poll in the hope to get a feel for 
the numbers on the others. (is it a 10:1 or a 1000:1 ratio?) 
Maintaining the code for many database backends requires a lot of 
testing and there are not many who have say, oracle, available for 
testing, let alone be proficient enough to maintain our middleware.

It is not enough to say, "hey, adodb supports 20 backends, so do we". 
Every new backend added over time added new issues which required 
changes to the code to make them work. Sometimes these were changes 
for those backends specifically (because it didnt support a construct 
that was used), sometimes the changes were more global, making all of 
the code more backend independent.

Especially in the 2.x development line we're looking at shifting some 
of the responsibilities from php code to the database backend, using 
somewhat more advanced features; making php code easier, but the 'SQL 
code' more complex. Doing this in a backend indepedent way is no easy 
task.

So, in short, we're making inventory on which battle to choose i guess.

marcel
_______________________________________________
Xaraya_devel mailing list
Xaraya_devel (at) xaraya.com
http://xaraya.com/mailman/listinfo/xaraya_devel