php-the-right-way/_posts/07-05-01-Abstraction-Layers.md

isChild, title, anchor

isChild	title	anchor
true	Abstraction Layers	databases_abstraction_layers

Abstraction Layers

Many frameworks provide their own abstraction layer which may or may not sit on top of PDO. These will often emulate features for one database system that is missing from another by wrapping your queries in PHP methods, giving you actual database abstraction instead of just the connection abstraction that PDO provides. This will of course add a little overhead, but if you are building a portable application that needs to work with MySQL, PostgreSQL and SQLite then a little overhead will be worth it for the sake of code cleanliness.

Some abstraction layers have been built using the PSR-0 or PSR-4 namespace standards so can be installed in any application you like:

• Atlas
• Aura SQL
• Doctrine2 DBAL
• Medoo
• Propel
• laminas-db