HTTP server + SQLite?

[Chris Rebert]

On Mon, May 3, 2010 at 12:46 AM, Gilles Ganault <nospam at nospam.com> wrote:
> I'd like to build a prototype that will combine a web server as
> front-end (it must support GZIPping data to the remote client when
> there are a lot of data to return), and SQLite as back-end, call the
> server from a VB.Net application, and see how well this works. I want
> to see if performance is significantly lower than using a server that
> uses a binary protocol.
>
> I'm no Python expert, so would appreciate any information on how to
> combine a web server and SQLite into a single Python application. This
> is just for a proof-of-concept, so it doesn't need to be
> shipping-quality.

If your want to write a basic/low-level HTTP server:
http://docs.python.org/library/basehttpserver.html
Looks like you'd use HTTPServer and a custom subclass of BaseHTTPRequestHandler.

If you want to write at the slightly higher WSGI
(http://www.python.org/dev/peps/pep-0333/) level of abstraction, you
can have your WSGI application run by a simple Python HTTP server such
as:
http://pythonpaste.org/modules/httpserver.html

As Alex said, SQLite is in the std lib:
http://docs.python.org/library/sqlite3

Cheers,
Chris
--
http://blog.rebertia.com