Prev: problem with variable and function
Next: Python unicode and Windows cmd.exe
From: Laszlo Nagy on 12 Mar 2010 00:48
gandalf(a)ubuntu:~$ python
Python 2.6.2 (release26-maint, Apr 19 2009, 01:56:41)
[GCC 4.3.3] on linux2
Type "help", "copyright", "credits" or "license" for more information.
>>> import sqlite3
>>> sqlite3.version
'2.4.1'

Is it possible to install a real sqlite version 3 somehow? I really need
it because I have to use savepoint/rollback to. That is only supported
from sqlite 3.6.8. Is it enough if I upgrade to Ubuntu Karmic? I know
that is not a question about Python itself.

But still, it is interesting that a module named "sqlite3" can actually
be used for something called "sqlite 2".

Thanks

Laszlo

From: Ryan Kelly on 14 Mar 2010 16:10
On Fri, 2010-03-12 at 06:48 +0100, Laszlo Nagy wrote:
> gandalf(a)ubuntu:~$ python
> Python 2.6.2 (release26-maint, Apr 19 2009, 01:56:41)
> [GCC 4.3.3] on linux2
> Type "help", "copyright", "credits" or "license" for more information.
> >>> import sqlite3
> >>> sqlite3.version
> '2.4.1'
>
> Is it possible to install a real sqlite version 3 somehow? I really need
> it because I have to use savepoint/rollback to. That is only supported
> from sqlite 3.6.8. Is it enough if I upgrade to Ubuntu Karmic? I know
> that is not a question about Python itself.

That's the sqlite *bindings* version:

>>> sqlite3.version
'2.4.1'
>>> sqlite3.sqlite_version
'3.6.16'
>>>

So this is "pysqlite" version 2.4.1, which wraps sqlite version 3.6.16.

Cheers,

Ryan


--
Ryan Kelly
http://www.rfk.id.au | This message is digitally signed. Please visit
ryan(a)rfk.id.au | http://www.rfk.id.au/ramblings/gpg/ for details

From: John Bokma on 14 Mar 2010 16:14
Laszlo Nagy <gandalf(a)shopzeus.com> writes:

> gandalf(a)ubuntu:~$ python
> Python 2.6.2 (release26-maint, Apr 19 2009, 01:56:41)
> [GCC 4.3.3] on linux2
> Type "help", "copyright", "credits" or "license" for more information.
>>>> import sqlite3
>>>> sqlite3.version
> '2.4.1'
>
> Is it possible to install a real sqlite version 3 somehow? I really
> need it because I have to use savepoint/rollback to. That is only
> supported from sqlite 3.6.8. Is it enough if I upgrade to Ubuntu
> Karmic? I know that is not a question about Python itself.
>
> But still, it is interesting that a module named "sqlite3" can
> actually be used for something called "sqlite 2".

You're mistaking the *module* version with the version of the database,
unless I am mistaken.

--
John Bokma j3b

Hacking & Hiking in Mexico - http://johnbokma.com/
http://castleamber.com/ - Perl & Python Development
 | 
Pages: 1
Prev: problem with variable and function
Next: Python unicode and Windows cmd.exe