Linux issue of `Failed to load dynamic library 'libsqlite3.x64.linux.so'` after version3 upgrade

[denvaki]

The OS

$ uname -a
Linux acerSwift3 6.17.9-arch1-1 #1 SMP PREEMPT_DYNAMIC Mon, 24 Nov 2025 15:21:09 +0000 x86_64 GNU/Linux

Error

After upgrading to version 3 I started to encounter following error:

[ERROR:flutter/runtime/dart_vm_initializer.cc(40)] Unhandled Exception: SqfliteFfiException(error, Invalid argument(s): Couldn't resolve native function 'sqlite3_initialize' in 'package:sqlite3/src/ffi/libsqlite3.g.dart' : Failed to load dynamic library 'libsqlite3.x64.linux.so': Failed to load dynamic library 'libsqlite3.x64.linux.so': libsqlite3.x64.linux.so: cannot open shared object file: No such file or directory.
}) DatabaseException(Invalid argument(s): Couldn't resolve native function 'sqlite3_initialize' in 'package:sqlite3/src/ffi/libsqlite3.g.dart' : Failed to load dynamic library 'libsqlite3.x64.linux.so': Failed to load dynamic library 'libsqlite3.x64.linux.so': libsqlite3.x64.linux.so: cannot open shared object file: No such file or directory.
)

What helped

ensure you have installed sqlite3 package aka sudo pacman -S sqlite

then make linking

$ cd /usr/lib
$ sudo ln -s libsqlite3.so libsqlite3.x64.linux.so

[alextekartik]

It should work without your workaround. It seems you are using sqflite_common_ffi. Make sure you are using version 2.4.0 or above (compatible with sqlite3 or above). If you are on flutter, make sure to perform a clean first. For dart (not flutter) use dart run xxx.dart instead of dart xxx.dart (Intellij does not use dart run it seems) to make sure build hooks are triggered (well at least once, in my experiment I have to use dart run xxx.dart once and then can run dart xxx.dart.

I just added some similar notes about this here:
https://github.com/tekartik/sqflite/blob/master/sqflite_common_ffi/doc/troubleshooting.md#sqlite3-v3-support