I've got a MySQL database which has a couple of quite simple tables.

I must locate an application (implemented in Perl, Python or PHP) that is going to do the next:

  1. Point the application to some database table, also it instantly retrieves the table's schema in the database.
  2. After that it creates an HTML look at the table's data. The information is displayed like a power grid, with all of fields being user-editable. If you will find lots of rows, it instantly provides pagination.
  3. Bonuses for permitting the consumer to click a column heading, which may then sort the information with that column.
  4. Bonuses for permitting the information to become strained with a "where" clause.

I've already checked out a couple of packages (phpMyAdmin, webmysql), but they don't appear to supply the editable table view. They appear more oriented towards database managers. Things I require is something that's more oriented towards someone who would like to view, enter and modify data.

Use CakeApp.com, it will exactly what you would like!

CakePHP's Bake Functionality can make this happen. But it might not be as trivial to complete as you would like.

If you're able to use groovy then Grails can enable you to get jump began. It'll build an ORM of the entire DB, build sights as well as your fundamental CRUD is built-in.

For those who have a genuine aversion to anything thats Java-based then perl's Catalyst might help build all of your mappings but may not enable you to get the entire 9 yards. You will have to write a number of your fundamental CRUD, that is simple and easy , could be accomplished by simple following a Catalyst tutorial.

Find out if Java NakedObejcts is what you would like. http://www.nakedobjects.org

Just reactions, but none of them of individuals exactly suit you perfectly, and so i made the decision to implement it myself.

It makes sense a brand new free project known as DWI, which means Database Web Interface. It required me about three days to have it working, and that i made it happen within 600 lines of PHP and javascript.

If you wish to take a look, it's situated at http://code.google.com/p/dwi.