Languages
Same behaviour, same error codes and same file format in every language.
| Language | Interface | Package | Status | Guide |
|---|---|---|---|---|
| Rust | native crate | crates.io | Built | Guide – Rust |
| C | header file | C library and pkg-config | Built | Guide – C |
| C++ | header-only, RAII | with the C library | Built | Guide – C++ |
| C (SQLite) | sqlite3.h subset, drop-in library | library | Built | – |
| CLI | command-line tool | binary | Built | – |
| Python | DB-API 2.0 module | PyPI psorvia-base | Built | Guide – Python |
| PHP | PDO driver and FFI package | PECL pdo_psob / Composer petitsouris/psorvia-base | Built | Guide – PHP |
| Go | database/sql driver | Go module (the path follows when the repository host is fixed) | Built | Guide – Go |
| JavaScript / TypeScript | Node-API module, synchronous and Promise interface, TypeScript types | npm @petitsouris/psorvia-base (name is a placeholder) | Built | Guide – JavaScript / TypeScript |
| Swift | Swift package over the C module | Swift Package Manager | Planned for 1.0 | – |
| Java / Kotlin | JDBC driver and core API over the Java foreign function API, no JNI | Maven Central io.psorvia:psorvia-base (group id is a placeholder) | Built | Guide – Java / Kotlin |
| C# / .NET | ADO.NET provider over P/Invoke, Native AOT compatible | NuGet PSOrvia.Base (id is a placeholder) | Built | Guide – C# / .NET |
| Dart / Flutter | dart:ffi package with synchronous and isolate API | pub.dev psorvia_base (name is a placeholder) | Built | Guide – Dart / Flutter |
| Ruby | gem over Fiddle, no extra gem needed | RubyGems psorvia-base (name is a placeholder) | Built | Guide – Ruby |
| PostgreSQL wire | server mode for psql and PostgreSQL drivers | binary | Planned for 1.0 | – |
ORMs (Django, SQLAlchemy, Doctrine, Laravel, Prisma, Entity Framework, Hibernate, GORM), ODBC, Lua, Zig, R, Julia, Perl and Elixir come after 1.0, on demand or from contributors.
Shared rules
- Lifetime in this order, closed in reverse: database, connection, statement. Each language uses its own mechanism for it.
- A connection is used by one thread at a time; open one connection per thread.
- Errors keep the same numeric code and message in every language.
- Values map as integer, real, text, blob and null. Parameters are bound, never joined into SQL strings.
- Every binding runs the same conformance suite on Linux, macOS and Windows and ships with a runnable example.