Pear DB - should i use it?

[redgorilla]

Hi. I have started right now my first medium sized project in PHP/MySQL and have following questions.
Should i use pear extension to handle db transaction. Is it faster and more secure then write simple db handling class or use existing on? Please advice to rookie - i don't want waste time inventing one more bicycle:-)

[redgorilla]

Is pear db class faster then core php mysql function? Does anyone have some comparison of this 2 option?

[fenway]

Having never used either, I can't speak to speed/performance; however, the mysql functions in PHP aren't part of the "core" function set either; and AFAIK, the PEAR class is much more intuitive and robust.

[redgorilla]

Also is pear protect from sql injection? I really don't sure should i use it or not. I will use MySQL 100%, so no other databases. I think using different database type is strongest side of Pear DB abstract layer. There are a lot of programmers here that developed big projects i think so please advice what do you use to handle database connection.

[fenway]

It may offer such protection, but it's easy to add it yourself. Just because you're only using MySQL now doesn't mean you shouldn't take advantage of a DB-independent abstraction class.