HTTP server + SQLite?

[John Nagle]

Gilles Ganault wrote:
> Hello
> 
> 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.
> 
> Thank you for any hint.

    There's no reason you can't do that.  Whether you want to is another issue.
There are, after all, plenty of web servers out there.  Also, SQLite really
is a "lite" database.  Although there's good read concurrency, multiple
updates from multiple processes tend to result in sizable delays, since
the locking is via file locks and wait/retry logic.

					John Nagle