Installing pysqlite in python with sqlite 3 version with custom file header

Question

I wan to compile sqlite with custom file header I followed the step given here http://trac.edgewall.org/wiki/PySqlite

Download pysqlite 
Extract it 
export  CFLAGS="-DSQLITE_FILE_HEADER=\\\"vivek\\\"" 
Run  python   setup.py build_static 
python   setup.py install  -f

But when run python and check sqlite version

>>> import sqlite3
>>> sqlite3.version
'2.6.0'

It is giving old version of sqlite. I think it should be 3. I tried opening the database but I am getting error

 sqlite3.DatabaseError: file is encrypted or is not a database


Python Version

python --version
Python 2.7.3

It's not so helpful to change your question this much; answerers do not get notified of the changes. Better use a new post next time to ask a new question. — Martijn Pieters
– Martijn Pieters, Commented Jul 17, 2012 at 6:31
possible duplicate of How can I upgrade the sqlite3 package in Python 2.6? — Martijn Pieters
– Martijn Pieters, Commented Jul 17, 2012 at 6:35
@MartijnPieters ok I will close this question and start another one. First I thought it sqlite version problem but as you told that is module version not sqlite. Then I checked for other problems. — Vivek Goel
– Vivek Goel, Commented Jul 17, 2012 at 6:36
No need to close it now; I've already altered my answer too. :-) — Martijn Pieters
– Martijn Pieters, Commented Jul 17, 2012 at 6:36
possible duplicate of force python to forego native sqlite3 and use the (installed) latest sqlite3 version — Martijn Pieters
– Martijn Pieters, Commented Jul 17, 2012 at 7:38

Community · Accepted Answer · 2017-05-23 12:12:29Z

1

From the top of the PySqlite page on the Trac site:

If you're using Python 2.5 and up, you already have a working version of pysqlite 2, bundled as sqlite3. You can stop here ;-)

You are using python 2.7, so there is no need to install a custom version. pysqlite comes bundled with your python version already.

pysqlite is the "glue" that makes sqlite available to python. Your system sqlite itself needs to be upgraded, not the glue library.

See How can I upgrade the sqlite3 package in Python 2.6?

edited May 23, 2017 at 12:12

CommunityBot

11 silver badge

answered Jul 17, 2012 at 6:22

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Vivek Goel Over a year ago

I am getting error sqlite3.DatabaseError: file is encrypted or is not a database

Martijn Pieters Over a year ago

That's a different problem then; what python version are you on in any case?

Vivek Goel Over a year ago

one more thing I am compiling sqlite with custom file header. python version 2.7.3

Vivek Goel Over a year ago

stackoverflow.com/questions/1545479/… This is more better answer.

Martijn Pieters Over a year ago

Glad you found something that helped! You didn't specify what platform you were on so I picked one for you before.

Collectives™ on Stack Overflow

Installing pysqlite in python with sqlite 3 version with custom file header

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related