This is an illustrative sample for how to use
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)