Pick a programming language with good support for JSON, first ;-). python and the simplejson package work for me, ymmv. If you want to make David happy, write out the json with indent=4.
Other than that, I'd recommend doing the exhibit first, with hand crafted json on a few items. Some of the processing between your data model and your json is easier to grok when you know where you're going. The most obvious datatype in need for conversion are dates, btw, you should get them into the json as exhibit wants them. http://hg.mozilla.org/users/axel_mozilla.com/tooling/?file/27c6e6525814/mozilla/tools/buildbotcustom/buildbotcustom/status/l10ndb.py is stuff that somehow worked for me, but it's currently not in production. python/sqlalchemy code, btw, so not sure how much use it is for you. Axel 2008/2/6, Margaret Leibovic <[EMAIL PROTECTED]>: > Hi, > > I want to make an Exhibit to display the data in my SQL database, and > I'm wondering if anyone has any ideas about how I should go about > dynamically generating the JSON for this. > > Thanks, > Margaret > _______________________________________________ > General mailing list > [email protected] > http://simile.mit.edu/mailman/listinfo/general > _______________________________________________ General mailing list [email protected] http://simile.mit.edu/mailman/listinfo/general
