This is an illustrative sample for how to use dart:ffi
.
For Windows, Linux, and MacOS, you should make sure, sqlite dev lib installed on your system.
Windows user can download dll from https://www.sqlite.org/download.html
If you do not have any sqlite3.dll or so file, you may found error message:
Unhandled exception: Invalid argument(s): Failed to load dynamic library (126) #0 _open (dart:ffi-patch/ffi_dynamic_library_patch.dart:13:55) #1 new DynamicLibrary.open (dart:ffi-patch/ffi_dynamic_library_patch.dart:22:12)
Building and running this sample is done through pub. Running dart run example/main
should produce the following output.
$ dart run example/main 1 Chocolade chip cookie Chocolade cookie foo 2 Ginger cookie null 42 3 Cinnamon roll null null 1 Chocolade chip cookie Chocolade cookie foo 2 Ginger cookie null 42 expected exception on accessing result data after close: The result has already been closed. expected this query to fail: no such column: non_existing_column (Code 1: SQL logic error)
A tutorial walking through the code is available in docs/sqlite-tutorial.md. For information on how to use this package within a Flutter app, see docs/android.md. (Note: iOS is not yet supported).