title: Drop-in CRUD web application
body: <h1>Background</h1>
  
  <p>A simple database with about 20 tables, sprinkled with unique constraints, primary keys, and foreign key relationships. This is a database for internal use only. Only two or three people will have direct access to the data. Only one of those people is qualified to be a DBA.</p>
  
  <p>The database was developed using DbSchema and PostgreSQL 9.1.</p>
  
  <p>The project itself is meant to be a quick-and-dirty prototype, but using clean data. Authentication and security are non-issues.</p>
  
  <h1>Problem</h1>
  
  <p>I'd like to supply a simple web-based CRUD application so that any data errors can be resolved without having to get the DBA involved.</p>
  
  <h1>Question</h1>
  
  <p>What software would you recommend that exposes a simple web interface that allows non-DBAs the ability to update data?</p>
  
  <h1>Example</h1>
  
  <p>To clarify, if it was a Java application, here is the simplicity I envision:</p>
  
  <ol>
  <li>Download a <code>jar</code> file (e.g., <code>crud-web-app.jar</code>).</li>
  <li>Run:<pre><code>java -jar crud-web-app.jar --username=postgres --password=password --host=localhost:5432 --database=database --listen=127.0.0.1:8080
  </code></pre></li>
  <li>Browse to 127.0.0.1:8080</li>
  <li>Select a table (one click).</li>
  <li>Edit data (saves over AJAX).</li>
  </ol>
  
  <h1>Related</h1>
  
  <p><a href="http://phppgadmin.sourceforge.net/" rel="noreferrer">phpPgAdmin</a> comes close, but I thought there might be something simpler (i.e., less intimidating for non-DBAs).</p>
  
  <p>Any suggestions?</p>
  
  <p>Thank you!</p>