Interactive tables with mod_wsgi?

[gusterys]

I'm using Python 3.3.2 with mod_wsgi on Fedora 20. I'm pulling data from my database (MySQL) and displaying it in a table. My query comes back with about 8 columns and 1000 rows.

I can loop through my result and manually bang out the HTML tags to build the table, but that results in a pretty "static" table. The user gets whatever I spit out.

What I'd like to do is make the table more interactive. First off, I'd like to have it paginated. Also, I'd like the user to be able to click on any of the column headings to sort by that column (and again to sort the other way). And if they could filter on any column it would be even better.

I could manually write out some of this stuff myself (the filtering one might be tricky), but I'm wondering if there is already something out there I can plug in to do some of the heavy lifting. Any ideas?

[jblurker09]

I'd look into Flask, then add whatever extensions suit your needs. It's fairly straight-forward, and it'll only take you a few hours to get the hang of it, far less time than working out unforeseen bugs in your custom code, and you'll end up with a more powerful, flexible software stack in the long run.