How can I use SQLite extensions with fastlite?

[FrLars21]

Hi there,

I am using fastlite for my FastHTML app. I am using the sqlite-vec extension installed via its sqlite-utils plugin. When I access the database via sqlite-utils' Database object, I can access the sqlite-vec functionality without any issues. If I access the same database via fastlite's Database object, I get the following error:

sqlite no such module: vec0

Given that fastlite is described as a "thin wrapper around sqlite-utils", I expected the sqlite-vec extension to work seamlessly here as well. Is there a known configuration step I might be missing, or does fastlite handle extensions differently?

I'd appreciate any guidance or suggestions on how to resolve this.

Thanks in advance for your help!

Best regards,
Frederik

[asg017]

@FrLars21 it's undocumented, but try passing in execute_plugins to the sqlite-utils Database class. Plugins (like sqlite-utils-sqlite-vec) don't automatically enable in the Python API unless execute_plugins=True in the constructor.

[alonsosilvaallende]

@FrLars21 it's undocumented, but try passing in execute_plugins to the sqlite-utils Database class. Plugins (like sqlite-utils-sqlite-vec) don't automatically enable in the Python API unless execute_plugins=True in the constructor.

I think the possibility to use plugins was lost after fastlite version 0.0.5.
See previously: https://gist.github.com/alonsosilvaallende/9a304bf9514446c5a92b11445f084961
After fastlite version 0.0.5: https://gist.github.com/alonsosilvaallende/7cc32f777e8f20cacb5b537b8eaa13d4

By reading the release it was when fastlite passed from sqlite-utils to sqlite-minutils. I wonder if it's possible to just add the possibility to add plugins such as sqlite-vec (of which I'm a big fan) and not add all the other cli options (redundant for a Python library).

[alonsosilvaallende]

For information, I opened an issue related to this to sqlite-minutils: AnswerDotAI/sqlite-minutils#16