3d graph with papervision3d and air/sqlite

I’m building on a little 3D graph app for work, based on AIR and Papervision3D.

It’s a graph on which one axis contains all the days in the year, another one contains all the half-hours in a day, and the third is the level of … um … some kind of level the client wants to show changing through the year, I guess (it’s for Energy Australia so I guess it has something to do with energy consumption).

So far I’ve just made a prototype using Papervision3D to see how well my (very average) computer copes with handling all the sprites involved. It renders fine, with animation, if I reduce the dataset tenfold … anything closer to the full dataset and it drags horribly (we are talking about 17500 sprites here, though, so that’s understable).

The brief for the project suggests the data should be stored in XML … but I’m using SQLite (via flash.data.SQLConnection etc) instead. It’s nice writing data access code again – in ActionScript! AIR is brilliant.

I would upload the AIR app but I’m still working out how to create a working digital signature for it … so in the meantime here’s a little teaser screen grab. As I mentioned, it’s just a prototype, so it ain’t pretty …