Compatibility¶

Python¶

Package	Constraint	Tested range (CI)	Role
sqlmodel	`>=0.0.14`	0.0.14+ (via pip resolve)	Physical models, engine integration
triplemodel	`>=0.12.0`	0.12.0+ (via pip resolve)	RDF export, CURIE expansion
typing-extensions	`>=4.0`	4.x	Typing backports

SQLAlchemy and Pydantic are transitive via SQLModel. Pin and test your target SQLModel/Pydantic major versions in staging before production deploys.

OntoSQL does not cap upper bounds on core dependencies in 0.5.x; verify upgrades in a staging environment.

Extra	Key packages	Notes
`async`	aiosqlite `>=0.20`, greenlet `>=3.0`	`AsyncOntoSession` with SQLite
`fastapi`	fastapi `>=0.100`, orjson `>=3.9`	`OntoRouter` (async; requires auth `dependencies` for public exposure)
`jsonld`	PyLD `>=3.0`	Compaction and framing
`sparql`	sparqlmodel `>=0.13.1`	Graph sync adapter
`shacl`	pyshacl `>=0.29`	Shape generation and validation

PyPI classifier: Development Status :: 4 - Beta (0.5.x). API may evolve until 1.0; see ROADMAP.md and the API stability section in SPECS.md.

Database	CI coverage	Production notes
SQLite	Full test matrix (Python 3.10–3.13)	Enable `PRAGMA foreign_keys=ON` for FK enforcement with REPLACE cascade
PostgreSQL	Dedicated CI job (`test_postgres.py`) — session CRUD, nested reads, save/delete	Recommended for production; see postgres-dialect.md

Other SQLAlchemy-supported databases may work but are not CI-tested.

triplemodel is a required core dependency (not optional), even when you use SQL CRUD only without RDF export.

Implication	Detail
Install footprint	Pulls TripleModel and transitive RDF stack (pyoxigraph via TripleModel)
SQL-only apps	Still used for `PrefixRegistry.expand()` and optional `to_jsonld()` / `to_rdf()`
Supply chain	Include TripleModel in security review and version pinning
Disabling RDF	You can omit RDF from app code; you cannot omit the dependency without forking

Database	Sync driver (examples)	Async driver (examples)	CI
SQLite	stdlib / built-in	`aiosqlite` via `ontosql[async]`	Tested
PostgreSQL	`psycopg` (v3)	`asyncpg`	Postgres job (sync); async not in dedicated CI job

Connection URLs:

Other async drivers supported by SQLAlchemy may work but are not documented or CI-tested.

Package	Notes
TripleModel	Core RDF dependency — use `triplemodel.Store` for graph manipulation in app code
SparqlModel	Optional via `ontosql[sparql]`

For RDF graph operations, prefer TripleModel APIs over direct pyoxigraph imports (pyoxigraph is a transitive implementation detail).