SQLite Forum

Latest .expert fails when any table schema includes extension function
Login
Because the .expert facility creates new database connections to achieve some of its functionality, those extension functions need to be available for those connections too, along with the one you explicitly create.

The extension load/usage options described in <u>[Automatically Load Statically Linked Extensions](https://sqlite.org/c3ref/auto_extension.html)</u> and <u>[Persistent Loadable Extensions](https://sqlite.org/loadext.html#persist)</u> can be used to arrange that availability and cure the problem you see without having to modify your schema.