app that auto-generates CRUD UI for database table
database, mysql, perl, php, user-interface
Solution
Thanks for the responses, but none of those exactly fit the bill, so I decided to implement it myself.
The result is a new open source project called DWI, which stands for Database Web Interface. It took me about 3 days to get it working, and I did it in about 600 lines of PHP and javascript.
If you want to check it out, it's located at http://code.google.com/p/dwi.
Problem
I have a MySQL database that has a few very simple tables. I would like to find an app (implemented in Perl, Python or PHP) that will do the following: - Point the app to a database table, and it automatically retrieves the table's schema from the database. - It then generates an HTML view of the table's data. The data is displayed as a grid, with all fields being user-editable. If there are a lot of rows, then it automatically provides pagination. - Bonus points for allowing the user to click a column heading, which would then sort the data by that column. - Bonus points for allowing the data to be filtered by a "where" clause. I have already looked at a few packages (phpMyAdmin, webmysql), but they do not seem to provide the editable table view. They seem more oriented towards database administrators. What I need is something that's more oriented towards someone who wants to view, enter and modify data.