I came to a descision today that I was going to learn a Python ORM framework to use. My project is going to require a lot of database access and using an ORM framework simplifies this. The ORM also hides many of the complexities. If you are interested, I’d highly recomend following this tutorial.
In doing some research into my CGI + SQLite issue I have been constantly asked “…but why are you using CGI”. It turns out that CGI + Python is not really used much. Many people recomend using mod_wsgi, and I think that instead of using raw wsgi I would like to use a framework. So far, CherryPy is what is sticking out to me because it is very lightweight and includes its own development server. This makes it easier to test my code because I (hopefully) would be able to use the Eclipse/Pydev debugger. This is something I have wanted to for quite some time. The main reason I am looking into CherryPy is that it seems to not worry itself with forcing a templating system on you.
In a related note, I found a JavaScript jQuery plugin which looks really neat and could prove to be very valuable. It is called TableSorter. There is an example of a pagination system that really caught my eye here.