
I cant downgrade libsqlite3-dev since its a dependency for a bunch of other system packages.

#CHANGE SQLITE 3 FROM 2 TO 3 INSTALL#
I doubt that's an issue for you, but if it is, you can just install it -universal, or use a different installer instead of Homebrew. When I try to install an old formula for 3.25 or 3.24 and substitute into the above LDRUNPATH/LDFLAGS variables, I always wind up with 3.31.1 (the Ubuntu system version of libsqlite3-dev). Note that if you follow exactly these steps, you'll get a non-fat version of libsqlite3, meaning that pysqlite2 won't work in 32-bit mode. If you've installed sqlite3 in some other way, you'll need to get the appropriate values-possibly /usr/local/lib and /usr/local/include, but if not, search for libsqlite3.dylib and sqlite3.h. The LDFLAGS and CPPFLAGS variables came from the output of the brew install sqlite3 step. # LDFLAGS=-L/usr/local/opt/sqlite/lib CPPFLAGS=-I/usr/local/opt/sqlite/include pip2.7 install pysqlite The SQLITEDEFAULTCACHESIZE is changed from 2000 to -2000 so the same amount of cache memory is used by default. There are a number of ways to do this, but the simplest is something like this: $ brew install sqlite3 Prior changes from version 3.12.0 (): Potentially Disruptive Change: The SQLITEDEFAULTPAGESIZE is increased from 1024 to 4096.

And you probably don't want to change around your whole path just to deal with this.īut that's fine, as long as the 3.8 is found first at build time, it doesn't matter what comes first at runtime the path to 3.8 will be baked into the module. This means that when you build pysqlite2, by default, it will find and use that 3.7, so it's not doing you any good. The sqlite3 version is still 3.37.2, so how do I make pyenv build a python with a different sqlite version or make the installed python to use a different sqlite version I still beginner, but I willing to learn so if anyone can provide a thorough instructions it will much appreciated. From your comments, your problem is that your pre-installed sqlite 3.7 comes higher on your path than your third-party 3.8.
