• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 465
  • Last Modified:

Database Abstraction Layer in PHP

Hi Friends,

I am working on a very big project using PHP.  The database can change from client to client like MySQL, Oracle etc. It will be very helpful if you could give some good info on Database Abstraction Layers for PHP. There are many available on net, the two I shortlisted is Pear MDB2 and AdoDB. I think AdoDB is better. Any ideas/suggestions is highly appreciated.

Regards,
Kiranvj
0
Kiran Paul VJ
Asked:
Kiran Paul VJ
  • 2
  • 2
2 Solutions
 
alain34Commented:
Hello kiranvj,

Have you had a look here to help you decide
http://www.greaterscope.net/documentation/php_database_abstraction_class_comparison.html

Regards,

alain34
0
 
alain34Commented:
Forgot to say. I personally use AdoDB.
0
 
NoiSCommented:
I recomend One of these (I tested a lot of Classes...)

PDO
ADODB
Pear MDB2

In this order.

If you will work only with MySQL or Postgre, PDO is the best choice (my decision).

If you will work with Oracle too, Maybe PDO isnĀ“t the good choice cause PDO don't work will REF Cursos (usually returned by Stored Procedures) but works great for all other functionality.
0
 
Kiran Paul VJComputer EngineerAuthor Commented:
Thank you for the suggestions
0
 
Kiran Paul VJComputer EngineerAuthor Commented:
I think I will go with ADODB
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now