Python / Django : emulating a multidimensionnal layer on a mySql database
- by Sébastien Piquemal
Hi,
I'm working on a Django project where I need to provide a lot of different visualizations on the same data (for example average of a value for each month, for each year / for a location, etc ...).
I have been using OLAP database once in college, and I thought that it would fit my needs, but it appears that it is much to heavy for what I need. Actually the volume of data is not very big, so I don't need any optimization, just a way to present different visualizations of the same data without having to write 1000 times the same code.
So let's recap : I need a python library :
to emulate a multidimensional database (OLAP style would be nice because I think it is quite convenient : stat structure, and everything)
non-intrusive, because I can't modify anything on the existing mysql database
easy-to-use, because otherwise there's no point in replacing some overhead by another.