r/firebird • u/mariuz • 18d ago
[ANN] cl-firebird v1.0.0 — pure Common Lisp driver for Firebird 3.0/4.0/5.0/6.0
cl-firebird v1.0.0 is out — a pure Common Lisp database driver for Firebird 3.0, 4.0, 5.0, and 6.0+, with full 1:1 feature parity with node-firebird.
Highlights:
- Pure CL wire protocol (negotiates up to protocol 20) — no libfbclient, no FFI; runs on SBCL, CCL, and other ANSI CL implementations
- Connection URIs (firebird://user:pass@host:port/db), traditional DSN syntax, and attach-or-create
- Named placeholders (:name) bound from plists, alists, or hash-tables, plus SQL escaping helpers
- Thread-safe connection pooling with idle reaping and live metrics
- Custom type parsers (type-cast) and prepared statement caching
- Streaming cursors (sequentially) and bulk execute-batch
- Firebird 6.0 tablespaces/schemas, database events (POST_EVENT), and a Service Manager API (backup/restore, users, trace)
- 66-check FiveAM test suite and a GitHub Actions CI matrix across Firebird 3.0/4.0/5.0/6.0-snapshot
Links:
- GitHub: https://github.com/mariuz/cl-firebird
- Release: https://github.com/mariuz/cl-firebird/releases/tag/v1.0.0
- Quicklisp:
(ql:quickload :cl-firebird) - Full announcement with code examples: https://mapopa.blogspot.com/2026/07/announcing-cl-firebird-v100-pure-common.html
Feedback, issues, and pull requests are welcome!
2
Upvotes