error on Windows: Invalid argument(s): Couldn't resolve native function 'sqlite3_initialize' in 'package:sqlite3/src/ffi/libsqlite3.g.dart'

[alibaqery-222]

Hi,
on run Dart in Windows I take this:

Unhandled exception:
Invalid argument(s): Couldn't resolve native function 'sqlite3_initialize' in 'package:sqlite3/src/ffi/libsqlite3.g.dart' : No asset with id 'package:sqlite3/src/ffi/libsqlite3.g.dart' found. No available native assets. Attempted to fallback to process lookup. None of the loaded modules contained the requested symbol 'sqlite3_initialize'..

#0 Native._ffi_resolver.#ffiClosure0 (dart:ffi-patch/ffi_patch.dart)
#1 Native._ffi_resolver_function (dart:ffi-patch/ffi_patch.dart:1943:20)
#2 sqlite3_initialize (package:sqlite3/src/ffi/libsqlite3.g.dart)
#3 FfiBindings.sqlite3_initialize (package:sqlite3/src/ffi/bindings.dart:202:23)

Windows 10
Dart version: 3.12.2

[Gioee]

Hi @alibaqery-222

I suspect you're missing the native sqlite3 library. This package should provide you native sqlite3 for your windows machine.

dart pub add sqlite3_native_assets

Alternatively you need to add sqlite3 to the PATH in any other way.
Please let me know if you need any further assistance.

Gioele,
SQLite AI