This post originated from an RSS feed registered with Python Buzz by Ng Pheng Siong. Original Post: Client-Server SQLite Feed Title: (render-blog Ng Pheng Siong) Feed URL: http://sandbox.rulemaker.net/ngps/rdf10_xml Feed Description: Just another this here thing blog. Latest Python Buzz Posts Latest Python Buzz Posts by Ng Pheng Siong Latest Posts From (render-blog Ng Pheng Siong)

Pg is a Common Lisp implementation of the PostgreSQL frontend/backend protocol.

SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.

Because of potential database corruption due to OS file locking bugs, the SQLite wiki suggests that one "should avoid using SQLite in situations where the same database will be accessed simultaneously from many computers over a network filesystem."

Periodically, people ask about a client/server version of SQLite on the mailing list. The wiki also has a page on ideas for client/server enhancements.

Here's one more: use the PostgreSQL protocol for SQLite client/server operation. Using the aforementioned Pg as a starting point, implement a Common Lisp network server that

• speaks the server-side PostgreSQL protocol;
• FFIs SQLite.