WebFaction
Community site: login faq

If I need some new SQLite feature not available through the system installed Python module, like Full-Text Search (FTS) support, how can I install and use a newer version on my account?

asked 26 Jul '12, 16:21

Rodolfo
2613
accept rate: 100%


I talked with the support via a ticket, solved the problem and they encouraged me to post the answer here so that other WebFaction customers searching the community OSQA forum would benefit from it.

All the steps I went through are described here: http://blog.rodolfocarvalho.net/2012/07/upgrade-sqlite-version-python-webfaction.html

Basically:

$ wget http://pysqlite.googlecode.com/files/pysqlite-2.6.3.tar.gz

$ tar xf pysqlite-2.6.3.tar.gz

$ cd pysqlite-2.6.3

$ python2.7 setup.py build_static

$ mkdir -p $HOME/lib/python2.7

$ PYTHONPATH=$HOME/lib/python2.7 python2.7 setup.py install --home=$HOME


Optionally, override Python's standard sqlite3 module:

$ echo "from dbapi2 import *" >> $HOME/lib/python2.7/pysqlite2/__init__.py

$ ln -s $HOME/lib/python2.7/{pysqlite2,sqlite3}

permanent link

answered 26 Jul '12, 16:32

Rodolfo
2613
accept rate: 100%

edited 26 Jul '12, 16:34

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×337
×11
×3
×2
×1

question asked: 26 Jul '12, 16:21

question was seen: 8,982 times

last updated: 26 Jul '12, 16:34

WEBFACTION
REACH US
SUPPORT
AFFILIATE PROGRAM
LEGAL
© COPYRIGHT 2003-2020 SWARMA LIMITED - WEBFACTION IS A SERVICE OF SWARMA LIMITED
REGISTERED IN ENGLAND AND WALES 5729350 - VAT REGISTRATION NUMBER 877397162
5TH FLOOR, THE OLD VINYL FACTORY, HAYES, UB3 1HA, UNITED KINGDOM