I have downloaded the extension I want in sqlite3 which is spellfix and when I open sqlite3 to enable it the cli is not able to recognize the sqlite function
Not sure how to load the extension spellfix.dll
pretty much I have the same error descriped here (I checked the answers too and not working)
I have tried the following
discordbotdatabase> sqlite3 database.db
SQLite version 3.42.0 2023-05-16 12:36:15
Enter ".help" for usage hints.
sqlite> .load ./spellfix
Error: unknown command or invalid arguments: "load". Enter ".help" for help
sqlite> .dbconfig load_extension on
load_extension on
sqlite> SELECT load_extension('./spellfix');
Parse error: no such function: load_extension
SELECT load_extension('./spellfix');
^--- error here
sqlite> SELECT load_extension('spellfix');
Parse error: no such function: load_extension
SELECT load_extension('spellfix');
^--- error here
sqlite>
First check your current directory in the sqlite shell (assuming that your are on Windows here given the .dll file).
sqlite> .shell cd
The output of this command will tell you where on your filesystem to place the extension. For example, you might be working in a specific project directory. Then, place your .dll file in that location. Then, within the sqlite shell you can load your extension.
sqlite> .load spellfix.dll