Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

PHP frameworks that aren't tightly coupled to the database and work with stored procedures?

This has been coming up at work recently, and Google's been...eh, minimally useful.

We're using Yii, but company policy is that all database access has to be done through MySQL stored procedures, which "breaks" quite a bit of Yii and renders some of its attempts at making life easier, well, irrelevant. (To be clear, the decision to require only SPs was made after Yii had been implemented.)

Are there any PHP frameworks out there that would work better under this limitation? We're using YiiBooster, so any other framework has to be Bootstrap-compatible or the UI/UX department will start screaming.

TLDR version:

My initial impression, from Googling and searching here, is that any other PHP framework will have the exact same limitations. Is this correct?

like image 214
Janet Avatar asked Apr 03 '13 15:04

Janet


1 Answers

You are correct. Any other framework will also have this limitation.

This is because a Framework itself is an abstraction from the underlying language. The framework abstracts the php code and the orm abstracts the storage in e.g. MySQL.

What you want is another abstraction layer between the ORM and the database 'manager'. I'm afraid but you'll need to write your own orm or extend and orm in order to accomplish this task.

like image 126
cb0 Avatar answered Oct 09 '22 02:10

cb0