Mod_python is an Apache module that embeds the python interpreter within the server. With mod_python you can write web-based applications in python that will run many times faster than traditional CGI and will have access to advanced features such as ability to retain database connections and other data between hits and access to Apache internals. A more detailed description of what mod_python can do is available in this O Reilly article.
