v1.0.0

The general-purpose release: a multi-table Database layer next to the original
single-table MSQLite helper, both on one retry implementation. Existing
MSQLite(path, table, schema) code keeps working unchanged.

Added

• Database(path, *, wal=True, timeout_s=30.0, ...) with write() (BEGIN IMMEDIATE, or
  mode="exclusive") and read() (BEGIN DEFERRED) transactions. Under WAL, the default,
  readers never wait for a writer.
• Transaction with execute, executemany, executescript, fetchone, fetchall,
  lastrowid, rowcount, row_factory and connection.
• One connection per thread reused across transactions (persistent=True); close() and
  context-manager support release them. Connections are never carried across a fork.
• Lock errors detected by SQLite result code (SQLITE_BUSY, SQLITE_LOCKED) instead of
  message text; SQLITE_BUSY_SNAPSHOT is raised immediately since a retry cannot succeed.
• Retry on BEGIN, on each single execute inside the transaction and on COMMIT, with
  jittered exponential backoff capped at retry_cap_s. Statement retry re-executes only the
  failed statement; the transaction stays open.
• timeout_s wall-clock deadline on total lock wait, raising MSQLiteTimeoutError(elapsed_s, attempts).
  MSQLiteMaxRetriesError is now its subclass, so except MSQLiteTimeoutError catches both.
• SQLite's own busy timeout (busy_timeout_s, default 5 s) set on every connection and capped to
  the remaining deadline.
• pragmas=(...) and on_open(connection) for per-connection setup.
• Database.migrate(steps) keyed on PRAGMA user_version.
• on_retry(attempt, elapsed_s, error) callback and a Stats dataclass
  (executions, retries, max_execution_s, max_wait_s) exposed as .stats on both classes.
• MSQLite accepts timeout_s, retry_cap_s, busy_timeout_s, wal, mode and on_retry,
  and a str path as well as a Path.
• Logging goes to the msqlite.msqlite logger instead of the root logger.
• Tests for readers during writes under WAL (threads and processes), the deadline error,
  statement-level and commit retry, migrations and the deprecation shims.
• scripts/benchmark.py and a benchmark table in the README.
• Python 3.15 in the test matrix (the tests run without beartype on a Python it does not support yet); ruff (lint and format) and strict mypy in CI.

Changed

• Connections are opened with autocommit=True and the library issues BEGIN/COMMIT/ROLLBACK
  itself, so executescript no longer risks an implicit commit.
• MSQLite.__exit__ closes every cursor it handed out before closing the connection, so an
  unconsumed SELECT can no longer keep the file lock alive until garbage collection.
• Backoff is exponential with jitter (retry_scale remains the base unit) rather than a fixed
  jittered sleep.

Deprecated

• MSQLite.max_execution_time, MSQLite.execution_count and MSQLite.retry_count now warn
  with DeprecationWarning; read MSQLite.stats.max_execution_s, .executions and .retries.
  They will be removed in 1.1.