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>
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

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