I’m still trying to justify my effort writing the MagicCGI code. It let you get an XML or JSON feed for any database, with some basic conditionals, limits etc. The existing demo is for my blog database.
I think this one is kinda cool – showing off all your blog posts/articles on a timeline:
To get the timeline working with the schema output from the Magic CGI, I needed to write my own Timeline EventSource. Currently I don’t do anything fancy with the generated bubbles – I just use the defaults.
The MagicCGI query gets all wp_posts (WordPress schema) rows, where “post_status=publish” and only returns fields that are relevant (notably ignores the large post_content field holding the blog content):
cap1 update (note the dubious use of capistrano 1… I still… haven’t… converted… to 2.0…)
So, no details here, just a fun example.
svn co http://drnicwilliams.com/svn/blog_timeline/trunk blog_timeline
If the MagicCGI tickles your fancy, its also only on svn at the moment, though its docco should be pretty good. I think.
svn co http://rubyforge.org/var/svn/magicmodels/magic_cgi/trunk magic_cgi