SlackwareThis Forum is for the discussion of Slackware Linux.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
The sqlite3 that's come bundled with python in slackware-current doesn't have fts, I get "no such module: fts4" when trying to run a script that needs it.
I don't know much about python, so I'm not sure how to tackle this.
Do I need to recompile the python package? or just the bundled sqlite somehow?
Just to be clear, the "system" sqlite3 does have fts compiled in, but python uses it's own version of sqlite3.
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.
So adding the following line to python.SlackBuild before ./configure part should do the trick:
Code:
sed -i '/SQLITE_OMIT_LOAD_EXTENSION/d' setup.py
Haven't tested it myself, it's late here, will try to build Python and see if it works tomorrow.
I just tried it using python source from -current on Slackware64-14.2 VM (currently at work and don't have access to my -current machine) and after rebuilding Python compile_options now shows ENABLE_FTS3, I also was able to create FTS3 table as explained in SQLite docs. I see no reason why this patch shouldn't work on -current.
You didn't do anything wrong, it's just that you need FTS4 not FTS3.
FTS4 is currently not built for sqlite because of a bug in sqlite's configure script.
You'd need to add this to sqlite.SlackBuild before ./configure is called:
Quote:
sed -i "s|\$(OPT_FEATURE_FLAGS)|\${OPT_FEATURE_FLAGS}|g" ./configure
and then rebuild sqlite as well.
I'd expect fixes for both of these issues to make it into -current soon though.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.