Inbound CRUD Web Application

Question

Background

A simple database with approximately 20 tables sprinkled with unique constraints, primary keys, and foreign key relationships. This database is for internal use only. Only two or three people will have direct access to the data. Only one of these people is qualified as a database administrator.

The database was developed using DbSchema and PostgreSQL 9.1.

The project itself is designed for a quick and dirty prototype, but using clean data. Authentication and security are not problems.

Problem

I would like to provide a simple CRUD web application so that any data errors can be resolved without having to use DBA.

Question

What software do you recommend by providing a simple web interface that allows non-database administrators the ability to update data?

Example

To clarify if this was a Java application, here is the simplicity that I imagine:

• Download the jar file (e.g. crud-web-app.jar ).
• Run:

   java -jar crud-web-app.jar --username=postgres --password=password --host=localhost:5432 --database=database --listen=127.0.0.1:8080 

• View 127.0.0.1:8080
• Select a table (with one click).
• Change data (saves AJAX).

Related

phpPgAdmin is close, but I thought there might be something simpler (i.e. less intimidating for non-DBA).

Any suggestions?

Thanks!

Answer 1

To generate CRUD without writing code:

• PHP generator

PostgreSQL PHP Generator is a PostgreSQL GUI interface that allows you to create high-quality PHP scripts for selected tables, views and queries for updates over the Internet.

Demo page

• http://demo.sqlmaestro.com/

The free version is quite extensive, the commercial version includes a huge number of functions. Using the tool, it took about 30 minutes (from downloading the software) to create CRUD pages for two dozen tables. The software automatically provides drop-down lists for foreign keys.

Output example

The following screenshot shows the result of the generator:

Answer 2

Another option is DaDaBIK , you can create an external / web-based CRUD application without coding.