Derek Organ Derek Organ - 4 years ago 88
MySQL Question

Building a REST API quickly from a Database model

I've designed my database diagram(11 entites) for my prototype application. I need to have an REST API on top of this that will allow me to build a prototype android tablet application that talks to it.

Considering this is only for prototype purposes. What would be the quickest way to get a API up and running that would allow me to get, put, delete etc..

Security at this point isn't an issue so even if all add edit delete were open that would be fine.

My initial idea is to build this with PHP and MySQL maybe using the Yii framework to help but I feel there might be something that might be faster for my purpose.

Any thoughts or recommendations or advice?

Answer Source

It is worth looking into API rapid-prototyping tools like Apify (tutorial) since you're starting from scratch. If you're planning to have both an API and a Web site accessing the same data, consider using one framework for both as it helps prevent duplicating logic. CakePHP and Yii are good examples of multipurpose frameworks that are suited for this type of development.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download