Simple CRUD Generation

Question

This is what I have:

• Entity-relational schema modeled for Doctrine 2.0 (in PHP);
• The generated database on the MySQL server.

This is what I want:

The simplest CRUD web interface for a database that allows me (you guessed it!) To create, read, update and delete records, with additional credit for performing CRUD operations on entities and relationships instead of records.

Now it’s terrible for me to write my own web applications (read: I'm lazy). Are there any options for creating a CRUD web application from a MySQL database or from a Doctrine entity set?

---

• I would like to stop using PHP (and thus rewrite entities for JPA, Ruby ActiveRecord, etc.), but not MySQL.
• I see many similar questions: however, most of these questions have answers that give CRUD operations for PHP code or recommend using Doctrine.
• An answer such as “No such tool, stop being lazy” will also be appreciated.

Answer 1

Symfony does this (at least for the 1.x series I'm used to). I should think that version 2.0 also works under Doctrine or Propel (and both of them will work with MySQL).

Answer 2

CakePHP ( User Guide ) accepts databases and generates controllers that perform basic CRUD operations for all of your tables. It also includes views and a basic style sheet.

Answer 3

If your hosting setup can handle Python, the web2py platform offers instant CRUD for the database and a very user-friendly (and user-friendly) online developer environment. I don’t think it was designed to lay the top of an existing database, but you can import a CSV file with the contents of your database. http://www.web2py.com

One of the great things about web2py is that creating custom (public) CRUD pages is also very easy. In the controller file, it is as simple as

form = CRUD.create(db.myTable) return dict(form = form) 

Then in the view file you just add

 {{=form}} 

And this! All forms of creation, input validation, etc. Processed for you. I should also add that the level of data abstraction in web2py is very easy to learn and easy to use with mySQL. One great thing is that web2py performs on-the-fly changes to your data structure or even migrations from one back-end DB to another.

Not every hosting company knows how to support web2py, but it is easy to deploy to Google App Engine or to a company such as Fluxflex.com

Answer 4

I was also looking for such a control panel while I have 3:

AjaxCrud - http://ajaxcrud.com/ Peek from Code Canyon - http://bit.ly/toKKrB SQLBuddy - http://www.sqlbuddy.com/

Nice to hear any other suggestions!

Answer 5

You should take a look at Grocery CRUD.

Really simple, easy to use / deploy and neat interface.

http://www.web-and-development.com/grocery_crud/

I did a full web CRUD of my DB in a couple of hours (including additional PHP web services). Amazing :-)

Answer 6

Ruby on Rails "Forests" should be exactly what you are looking for ...

Answer 7

As per this answer , I tried Xataface , which gave me a decent result that CakePHP or Web2Py would give me. Now I'm trying to use Symfony 2.0 (which is much more complicated than I expected) for extra credit.