I'm looking for a service that surely exists somewhere. I sorda-kinda took over some website management for a cycling team. Did a quick and dirty redesign (mostly taking their existing site and dropping it into a cleaned up DW template so it was easier to manage). It has a "Results" page where race results are listed, which is currently a static table that has to be updated manually - currently by me whenever they email me results.

I want to make the results page dynamic so they can enter (and maybe edit) results themselves and don't have to email me everything. They have a shitty host and apparently don't have any mySQL databases as part of their package. I could put some databases on my own webhost, but I would rather not tie my personal accounts with their webpage. I could also make some text-file based system (where they would use forms to add/edit a text file, which supplies data to a PHP results page), but that seems like a lot of hassle and is inefficient.

So I think what would be cool would be a free web-database service that would host a database of sorts (at least a table or two), allow user and group login to edit the tables (or an abstracted structure) through automatically created forms, and an API or SQL-type structure where my PHP file could pull the data from the service. I don't want online file hosting/sharing, which is what most of my searching has returned.

I've tried http://baseportal.com/ - but it has a terrible interface, bad table design capabilities, and i'm not even sure if they offer groups or external access to data.
Also I have a beta invitation to the brand new http://dabbledb.com/ - it's a very very slick "web 2.0" online database that is really cool. But it costs $10/application/month and isn't even live yet, and won't offer an API or external access till later.
I've also looked through all the companies here, but they're mostly for file storage - http://www.techcrunch.com/2006/01/31/the-online-storage-gang/

Anyone know of any other services, or offer suggestions that 1) are very minimal for me to setup and upkeep and 2) will allow me to register users who can edit information in a database-type structure that can be 3) accessed via PHP in an API or SQL-type query.

5/2/2006 11:16:32 AM