Simple database front ends?

[mikekn]

Does anyone out there know of a simple, preferably web-based, database front end? We've got two choices on a project at work - either code up a custom interface for the client or find an off the shelf product that can do the job. Unfortunately most of what I've found are too feature rich and complex for what we need (simple form based data entry and a good query interface).

Comments

[sskipstress.livejournal.com]

What kind of database and what have you looked at so far?

[mikekn]

We plan on using MySQL or Postgres, though if it can support ODBC that would be best.

So far I've just done some web searching, looking at stuff like SQL Developer, Aqua Data Studio, TOra, etc. But they are all overkill for the needs.

[sskipstress.livejournal.com]

I've used phpMyAdmin and phpPgAdmin for basic admin access to databases. It isn't terribly slick and needs to be fairly well locked down at the webserver/network levels but they work pretty well for the basics.

[sskipstress.livejournal.com]

And if you're looking for something to quickly make web forms based on the database model and run simplish queries, Symfony does that. It is very strongly based on Pear's database classes, so it can be extended, but is a bit of a bitch to do so, but if you just need a simple web form interface for data entry into tables, it's pretty quick to set up.

[mikekn]

Thanks! I'll take a look at it.