fbdb
1.8.1, released 3 weeks ago by hipercom.pl
Dart client for Firebird SQL using FFI, providing async API and low‑level bindings.
What it does
It connects to a Firebird database via the native client library, lets you execute queries, manage transactions, blobs and batches, and streams results asynchronously.
AI-written summary of version 1.8.1, based on the package's README and metadata. Report an inaccuracy
Use it when
- You need to access a Firebird database from a Dart or Flutter app.
- You want a fully asynchronous API with isolates and streams for performance.
Skip it when
- You are targeting web or environments without a native Firebird client library.
- You need a cross‑platform database that works out of the box without external binaries.
Strengths
- Fully async with isolates and streams
- Supports transactions, BLOBs, batch execution
- Open‑source BSD‑3 license
- Provides both high‑level and low‑level APIs
Weaknesses
- Requires native Firebird client library and its dependencies
- Not supported on web
- Platform setup can be complex
Setup
- Kind
- FFI (native library)
- Effort
- Medium
- Code generation
- No
- Direct dependencies
- 1
Place the appropriate fbclient.dll (Windows), libfbclient.so (Linux) or libfbclient.dylib (macOS) in the application directory and ensure any required runtime dependencies (e.g., VC++ redistributables on Windows).
import "package:fbdb/fbdb.dart";
void main() async {
FbDb db = await FbDb.attach(
host: "localhost",
database: "employee",
user: "SYSDBA",
password: "masterkey",
);
final q = db.query();
await q.openCursor(
sql: "select FIRST_NAME, LAST_NAME from EMPLOYEE order by LAST_NAME rows 10 ",
);
await for (var r in q.rows()) {
print("${r['LAST_NAME']}, ${r['FIRST_NAME']}");
}
await q.close();
await db.detach();
}Alternatives
Packages that do the same job and could replace fbdb.
- sqflite
SQLite plugin for Flutter supporting iOS, Android and MacOS.
96Compare - sqflite_common
Dart wrapper on SQLite providing the common API for sqflite and desktop FFI implementations.
93Compare - sqlite3
Lightweight and convenient SQLite bindings for Dart using dart:ffi
92Compare - sqflite_common_ffi_web
Sqflite web implementation using sqlite3 ffi and sqlite3 wasm.
90Compare
Works with
Packages commonly used together with fbdb: ones it builds on, ones built on it, and its own family.