Re: Data Entry Tool for PostgreSQL

On 9/25/05 8:49 PM, "Brent Wood" <b(dot)wood(at)niwa(dot)co(dot)nz> wrote:

>
>
> On Fri, 23 Sep 2005, Ian Overton wrote:
>
>> Hello,
>>
>> We have a web application using PHP, Linux and PostgreSQL. We need a
>> simple data entry tool to allow non-IT people to edit data in our database
>> through a web-browser. Are there any free or commercial data management
>> tools out there, not database management tools like pgAdmin.
>
> I would have thought a php appliction would be able to this fairly
> easily. My data entry scripts insert the new records with just a primary
> key, then iterate through the various fields using an update sql for each
> one which is not null.
>
> This sort of approach coul easily be used to populate an on-screen table
> using php, then update any changed fields as required.

These types of applications are typically called "CRUD" applications
(Create, Read, Update, and Delete). Perl, Ruby, and Java, at least, have
frameworks for building CRUD applications in a fairly straightforward
(depending on needs and customization).

Sean