fbdb 1.4.0

A Firebird SQL database access library for Dart and Flutter.

example/README.md

fbdb examples

All fbdb examples are split between three subdirectories.

1. The fbdb directory contains examples for the high-level, Dart-idiomatic API of FbDb:
   • ex_01_simple_select.dart - shows how to connect to a database, execute a SELECT statement and fetch the results,
   • ex_02_createdb_dropdb.dart - shows how to create and drop databases using the FbDb attachments,
   • ex_03_transactions.dart - illustrates transaction handling,
   • ex_04_fetching.dart - shows different methods of fetching rows from the query result set,
   • ex_05_blobs.dart - shows how to handle BLOB data,
   • ex_06_output_params.dart - shows how to obtain results from a stored procedure that is not selectable, i.e. returns its results via output parameters,
   • ex_07_affected_rows.dart - shows how to check how many rows have been affected by a DML query,
   • ex_08_multiple_connections.dart - shows how to open multiple concurrent connections in FbDb,
   • ex_09_lock_wait.dart - illustrates the difference between wait and no wait transactions and the role of the lock timeout parameter,
   • ex_10_errors.dart - shows how to detect and handle errors reported by the server,
   • ex_11_mem_benchmark.dart - strictly speaking it'snot an example, but a simple memory usage benchmark, using a custom TracingAllocator to record all allocations and releases of native memory blocks (including the background worker isolate).
   • ex_12_prepared_statements.dart - shows how to use prepared statements (supported from version 1.3 of fbdb) to speed up repetitive queries. This example inserts 30000 records to a table using traditional queries and prepared queries, and then compares the time each process took, displaying the percentage speedup prepared queries may get you in such scenarios.
2. The interfaces directory contains some examples for the low-level API, i.e. the direct FFI bindings to the Firebird client library interfaces. Those are mainly re-implementations of the C++ examples, distributed together with the Firebird server (usually available in the examples/interfaces subdirectory of the Firebird root directory). The examples re-implemented in fbdb are:
   • ex_01_create.dart (an equivalent of 01.create.cpp from the Firebird examples) - shows how to create a new database using the IAttachment interface,
   • ex_02_update.dart (an equivalent of 02.update.cpp from the Firebird examples) - shows how to execute UPDATE queries, both with and without prepared statements,
   • ex_03_select.dart (an equivalent of 03.select.cpp from Firebird examples) - demonstrates simple SELECT statements with cursors and row fetching,
   • ex_04_print_table.dart (an equivalent of 04.print_table.cpp from the Firebird examples) - displays all tables from the database by querying a system table,
   • ex_07_blob.dart (an equivalent of 07.blob.cpp from the Firebird examples) - shows how to handle both writing and reading of BLOBs,
   • ex_09_service.dart (an equivalent of 09.service.cpp from the Firebird examples) - shows how to communicate with the service manager to obtain database information,
   • ex_10_backup.dart (an equivalent of 10.backup.cpp from the Firebird examples) - shows how to use services manager to make a backup of a database.
3. The tutorial directory contains the complete source code and project files for the FbDb Tutorial application.