Activities

May 2010
M T W T F S S
« Apr   Jun »
 12
3456789
10111213141516
17181920212223
24252627282930
31  

Upgrading SQLite from 2.x.y to 3.x.z

I’m using on Centos5.3 server.

1. Downloading and installing the latest sqllite package
#wget http://www.sqlite.org/sqlite-3.6.23.1.tar.gz
# tar-zxvf sqlite-3.6.23.1.tar.gz && cd sqlite-3.6.23.1
#mkdir bld
#cd bld
#../configure
#make && make install

2. Verify the python-binding is correctly configured.

[root@rc-170 bd]# python
Python 2.4.3 (#1, Jan 21 2009, 01:10:13)
[GCC 4.1.2 20071124 (Red Hat 4.1.2-42)] on linux2
Type “help”, “copyright”, “credits” or “license” for more information.
>>> import sqlite
>>> sqlite.version
‘1.1.7’
>>> sqlite._sqlite.sqlite_version()
‘3.6.23.1’
>>>

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>