wsqlite3

WSQLite3 (v0.7 under development)

versions <0.5 are dysfunctional

versions <0.7 contains unclean thread management, which can cause zombie processes

python -m pip install wsqlite3 --upgrade

WSQLite3 (WebSocket SQLite3) is a simple and lightweight solution to manage access from multiple processes (or threads) to SQLite3 databases.

What it is and what it is not:

The focus of WSQLite3 is on simple local session management of multiple instances of a program or compatibilization of different programs. WSQLite3 is not intended as a database in a wide-ranging system for multiple end users. For this, other advanced database systems with client servers should be used.

WSQLite3 in the basic version is designed for friendly connections, an SSL is NOT implemented and there is NO permission handling (Caution: WSQLite3 also allows remote code execution).

How it works and properties:

WSQLite3 manages connections to SQLite3 databases for multiple clients per server. The communication via the WebSocket protocol with JSON data provides simple and high compatibility between different programs and programming languages. The focus of the project is on the WSQLite3 service, which is intended as an independent process. For complex projects, a separate implementation of the client side should be embedded.

---

▶   Documentation