title: app that auto-generates CRUD UI for database table
body: <p>I have a MySQL database that has a few very simple tables.</p>
  
  <p>I would like to find an app (implemented in Perl, Python or PHP) that will do the following:</p>
  
  <ol>
  <li>Point the app to a database table, and it automatically retrieves the table's schema from the database.</li>
  <li>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.</li>
  <li>Bonus points for allowing the user to click a column heading, which would then sort the data by that column.</li>
  <li>Bonus points for allowing the data to be filtered by a "where" clause.</li>
  </ol>
  
  <p>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.</p>