Metadata-Version: 2.4
Name: pinboard-sqlite
Version: 0.1.0a1
Requires-Dist: pinboard-sdk>=0.18.1 ; extra == 'pinboard'
Provides-Extra: pinboard
Summary: SQLite on S3 for singleton durable objects: a sqlite3-style connection whose commits land in packed LTX segments
License-Expression: MIT
Requires-Python: >=3.11
Description-Content-Type: text/markdown; charset=UTF-8; variant=GFM
Project-URL: Repository, https://github.com/assistant-ui/harness-sdk

# pinboard-sqlite

SQLite on S3 for singleton durable objects. Imports as `pinboard_sqlite`. v0.1 alpha.

```python
import pinboard_sqlite

conn = pinboard_sqlite.connect("s3://my-bucket/app.db")
conn.execute("CREATE TABLE IF NOT EXISTS notes (text TEXT)")
conn.execute("INSERT INTO notes VALUES (?)", ["hi"])
conn.commit()  # returns once the commit is on S3
conn.close()   # drains, then releases the database
```

`SQLiteStore` is the lower-level async handle (`open`, `force_claim`, `durable`, `release`). With a Pinboard object, `pip install "pinboard-sqlite[pinboard]"` and use `pinboard_sqlite.pinboard.sqlite`: the claim opens the object's database, commits ride its Frontier, and the disclaim releases it.

Docs: [rust/pinboard-sqlite/README.md](https://github.com/assistant-ui/harness-sdk/blob/main/rust/pinboard-sqlite/README.md).

