I am looking for an application that will let me create simple online
databases that can be edited by multiple users.  Something like <a
href="http://www.bigprof.com/appgini/">Appgini</a> would do the trick,
except that I want a web-only interface for modifying the database,
not a desktop windows client.  I am running OS X 10.3 with php,
apache2, and mysql. Free and open source would be great, but I could
by a commercial product if it wasn't too painful to install and use.

What I'm not looking for: 

some script that nobody has ever tried or is inflexible.
filemaker pro in any form (too buggy)
any solution that isn't php based, with the exception of a really
great perl setup with lots of users and great docs.
"write it yourself" or any other custom solution

Hi, 

Well this is a simple one. phpMyAdmin is your tool. Very well
documented, very stable, highly recommended even if you didn't want a
web only interface. phpMyAdmin can be secured on many levels,
restricting logged in users to certain databases or even certain
tables in those databases.

http://www.phpmyadmin.net/home_page/

Setup should take you about 20 minutes or so for the first round.
After that, you can mess with settings and security states. If you
have any questions on the basic setup, just post them in here, as a
Clarification Request and I'll be glad to help you with them. I really
couldn't tell you how many times I've set phpMyAdmin up, but it takes
me about 8 minutes these days.

Once set up you can do everything with MySql you would want to, and it
has some very nice export, and reporting features which I use all the
time.

Expect to play with it for a few hours after you have it up and
running, and check the website for documentation. It really is a very
good program, which is why most ISP's use it as the MySQL interface
for thier users (includeing Yahoo and most major ISP companies).

thanks, 

webadept-ga

---

Request for Answer Clarification by craniac-ga on 12 Apr 2005 21:36 PDT

Can phpmyadmin be locked down and modified to the point where
non-techy users can use it to search and modify data?  And if it meets
my specs, do you want to get paid for this question or the previous
one that you didn't follow up on?

---

Clarification of Answer by webadept-ga on 13 Apr 2005 00:51 PDT

Actually, the phpMyAdmin is for creating and modifying databases, not
data overall. You can modify the data in the database using
phpMyAdmin, but not easily. You asked for a tool for creating and
modifying databases here, which is very common in PHP development.

I'm still looking for a simple database schedule program for the other
question, and I'm still considering creating the mod. According to
your other question (if memory serves) you are currently using an
Excel spread sheet for this? if so, can you post the spread sheet
(don't need the data really, just the headings) on a webserver
somewhere so I can take a look at it, and see what creating the mod is
going to take. If not, could you post your exact needs for the
scheduler so that I can use that.

As to your other question, your call on that. You will probably want
and need phpMyAdmin anyway to setup your database and help install
your new program or maintain and backup the data as required.

thanks, 

webadept-ga

---

Request for Answer Clarification by craniac-ga on 13 Apr 2005 05:39 PDT

I think that conceptually it's a mistake to think of this as a
scheduler, and that it throws people off when I call it such.  I'll
pay you for one of these questions, and the moodle mod would be cool,
but please don't answer this question the next time I post it because
it keeps other people from addressing it who might have other ideas.

All I need is a simple web database, modifiable by browser, usable by
non-techies, that could import and export csv or tab delimited text.