Hey all.
I'm working on a project requiring client-side data storage based on
the new HTML 5 Offline applications spec. Having a database on the
client like Google Gears is a great idea, but it'd be nice to have a
framework to manage the database.
I was thinking of running up a jQuery plugin that does Rails-esque
migrations for client-side storage but thought I'd better check
whether anyone's working on this sort of thing already.
Also, any thoughts on how people would like to see this done would be
appreciated. Personally I've always wished Rails used XML to define
migrations, something like this:
<migration onfail="rollback|abort">
<up text="Creating table user" success="Done!" fail="Error">
<createtable name="User" existscheck="true">
<column name="ID" datatype="integer" size="32"
null="false"
autoincrement="true" />
<column name="Name" datatype="string"
default="Unknown" />
<options>
<option for="mysql" name=""
value="MyISAM" />
</options>
</createtable>
</up>
</migration>
Should be easy enough to do something similar based on JSON. One day
I'd love to see that XSD'd and standardized to make a fairly cross-
platform framework for maintaining databases, but that's just my own
little personal crusade : )
So: anyone doing this already? Any thoughts on how you'd like to see
this done?
I'm all ears.
WN
