Python and sqlite versions

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed.xs4all.nl!newsfeed1a.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path	<python-python-list@m.gmane.org>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.001
X-Spam-Evidence	'H': 1.00; 'S': 0.00; 'tutorial': 0.03; 'output': 0.05; 'subject:Python': 0.06; 'steve': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'python': 0.11; 'from:addr:steve': 0.16; 'received:80.91.229.3': 0.16; 'received:plane.gmane.org': 0.16; 'sqlite': 0.16; 'subject:versions': 0.16; 'version?': 0.16; 'library': 0.18; 'later': 0.20; '>>>': 0.22; 'import': 0.22; 'header:User-Agent:1': 0.23; "i've": 0.25; 'post': 0.26; 'header:X -Complaints-To:1': 0.27; 'installed': 0.27; "doesn't": 0.30; "i'm": 0.30; 'run': 0.32; 'display': 0.35; 'version': 0.36; 'library.': 0.36; 'next': 0.36; 'so,': 0.37; 'starting': 0.37; 'step': 0.37; 'to:addr:python-list': 0.38; 'to:addr:python.org': 0.39; 'received:org': 0.40; 'how': 0.40; 'first': 0.61; 'between': 0.67; 'off,': 0.84; 'received:2': 0.84; 'shape.': 0.84
X-Injected-Via-Gmane	http://gmane.org/
To	python-list@python.org
From	Simmo <steve@bellissimmo.com>
Subject	Python and sqlite versions
Date	Fri, 10 Oct 2014 19:13:53 +0100
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding	7bit
X-Gmane-NNTP-Posting-Host	2.122.189.77
User-Agent	Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.6.0
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.15
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.14759.1412966708.18130.python-list@python.org> (permalink)
Lines	26
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1412966708 news.xs4all.nl 2880 [2001:888:2000:d::a6]:41541
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:78961

Show key headers only | View raw

First off, this is my first attempt to post via Thunderbird newsgroup, 
so apologies (and please let me know) if it doesn't arrive in good shape.

I'm just starting to get to grips with using a database (sqlite) and 
I've run into some confusion as to how Python 'ties in' to sqlite.

First step in the tutorial is to import sqlite3 and display 
sqlite3.version and sqlite3.sqlite_version.  Output below...

 >>> sqlite3.version
'2.6.0'
 >>> sqlite3.sqlite_version
'3.7.12'

Next step is to run up sqlite.  Output below...

SQLite version 3.8.6 2014-08-15 11:46:33
Enter ".help" for usage hints.

So, I have a disparity between installed sqlite and the Python sqlite 
library.  Do I need to find a 3.7.12 version of sqlite and , if so, 
where might I find it or can I change the Python library for the later 
version?

Steve

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

Python and sqlite versions Simmo <steve@bellissimmo.com> - 2014-10-10 19:13 +0100

csiph-web