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:
- Point the application to some database table, also it instantly retrieves the table's schema in the database.
- 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.
- Bonuses for permitting the consumer to click a column heading, which may then sort the information with that column.
- 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!
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.
If you wish to take a look, it's situated at http://code.google.com/p/dwi.