Database comparisons
Posted: Sat Apr 01, 2006 4:06 pm
So I've looked into the code behind PEAR MDB, AdoDB and a few other PHP database abstraction layers in order to get a glimpse of what each one does and how each is better or worse than the others...
I have to say, most I've reviewed are quite poorly written in comparison to MDB or AdoDB.
There are actually more caveat's than I originally thought there would be when taking on the project of writing a DB abstraction layer
MDB and Ado have shown me this...
So now I'm looking for any quality articles you database experts may know of which depict the differences between popuplar databases?
For example, I had no idea (only ever using MySQL) that primary keys don't exist in many other databases, they use a technique called sequencing???
Also, MySQL doesn't handle "affected rows" for DELETE statements so MDG uses a tricky little hack to circumvent this issue in the MySQL driver
So I ask, anyone know of some good articles (hopefully brief - outlining differences) I should be aware of so I can accelerate my writing an abstraction layer???
Cheers
I have to say, most I've reviewed are quite poorly written in comparison to MDB or AdoDB.
There are actually more caveat's than I originally thought there would be when taking on the project of writing a DB abstraction layer
MDB and Ado have shown me this...
So now I'm looking for any quality articles you database experts may know of which depict the differences between popuplar databases?
For example, I had no idea (only ever using MySQL) that primary keys don't exist in many other databases, they use a technique called sequencing???
Also, MySQL doesn't handle "affected rows" for DELETE statements so MDG uses a tricky little hack to circumvent this issue in the MySQL driver
So I ask, anyone know of some good articles (hopefully brief - outlining differences) I should be aware of so I can accelerate my writing an abstraction layer???
Cheers