Welcome!
This is the community forum for my apps Pythonista and Editorial.
For individual support questions, you can also send an email. If you have a very short question or just want to say hello — I'm @olemoritz on Twitter.
Any way to enable loadable extension support for sqllite3?
-
Hi - just wondering if this is possible.
I am trying to learn some basic sqllite and want to try the full text search extension. I attempted to run the example script from the python docs but it generates an AttributeError: 'sqllite 3 connection object has no attribute enable_load_extension'. The script begins like this:
import sqlite3 con = sqlite3.connect(":memory:") # enable extension loading con.enable_load_extension(True) # Load the fulltext search extension con.execute("select load_extension('./fts3.so')")
I assume the issue is the one pointed out in the note below. Is it possible to turn this feature on?:
"The sqlite3 module is not built with loadable extension support by default, because some platforms (notably Mac OS X) have SQLite libraries which are compiled without this feature. To get loadable extension support, you must modify setup.py and remove the line that sets SQLITE_OMIT_LOAD_EXTENSION."
Thanks again for this amazing app and for any help with this question!