Looking for a web form creating application for sqlite or mysql

[Chris G]

On Wed, Oct 05, 2011 at 12:11:58AM +0100, Avi Greenbury wrote:
> Chris G wrote:
> 
> > Obviously there will need to be some customisation/configuration but
> > if I can effectively define what is shown by specifying the database
> > columns as I want then that should be it.
> 
> Three options that come to mind are:
> 
> 1) Write an interface in PHP or similar. You'll get exactly what you
> want, but will probably need to learn something. It's not *hard*, but
> there may be several new things to understand.
> 
Yes, I could do that, but it really surprises me that there aren't *any*
ready made applications.


> 2) Use a spreadsheet app, save the filled-in form as a CSV and then
> import that into whatever db you want.
> 
Very clumsy and not usable across the web.  It's the *data entry* on the
web that I'm after.


> 3) Use a db admin app (like PHPMyAdmin) with a user granted only those
> permissions needed (just inserts?). Bit messy, but nice and quick.
> 
PHPMyAdmin (and it's close relatives) are aimed at managing the database
and tables rather than entering data.  I've already tried two or three
of them and they're *horribly* clumsy to use for simply entering data
into a table.

-- 
Chris Green