Advice from the gurus of Web 2.0 required
Oct. 15th, 2005 06:41 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
We're currently seeing a resurgence of collaboration software - I've seen Word and Excel clones for the web. But I'm not seeing anyone allowing for structured data - is there anyone out there selling access to a MySQL database with a pretty front end stuck on the front of it, so that people can share lists of things?
The data is currently being stored in Excel spreadsheets being emailed back and forth, and frankly it's (a) perfect for sticking in a database table, as it's just text stored in columns and (b)silly to be emailing it back and forth rather than sticking it on a server. But nobody seems to be selling pretty front ends for structured lists...
Anyone help me with this?
The data is currently being stored in Excel spreadsheets being emailed back and forth, and frankly it's (a) perfect for sticking in a database table, as it's just text stored in columns and (b)silly to be emailing it back and forth rather than sticking it on a server. But nobody seems to be selling pretty front ends for structured lists...
Anyone help me with this?
no subject
Date: 2005-10-15 05:49 pm (UTC)You should be able to build it yourself pretty quickly using some AMP implementation or other...
no subject
Date: 2005-10-15 07:18 pm (UTC)no subject
Date: 2005-10-15 07:26 pm (UTC)However, yes, in practice I'd be more inclined to knock up a simple form-driven app in PHP that would manage a directory where the data was stored as XML, and use the built in PHP XML parser to handle display and edit, where the content of the XML was used to build the form on the fly - giving you an editable surface with write-back and simple file locking...
/me goes off and codes...
no subject
Date: 2005-10-15 05:57 pm (UTC)no subject
Date: 2005-10-15 11:05 pm (UTC).NET also has their generic DataGrid / DataList for web access. At its most basic level, you bind it to a DataSet (which you can connect to MySql using a standard SQL query and the System.Data.OleDb.DataAdapter object), and it generates the HTML layout. You can automate paging, editing, and other cool stuff.
The problem is if you want to get even slightly away from what Microsoft thinks you want, you have to tear out all that automated code and start hacking at it. I hear .NET 2.0 has more flexibility, but haven't messed with that lately.
At the most base level, you can port out MySql to XML, and then use XSLT to generate a web page. However, having the ability to either edit that XML, or provide continuous integration between MySql and XML would be kind of a pain.
no subject
Date: 2005-10-16 11:04 am (UTC)no subject
Date: 2005-10-17 06:35 am (UTC)