Return-Path: <zachary.ware@gmail.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.015
X-Spam-Evidence: '*H*': 0.97; '*S*': 0.00; 'tutorial': 0.03; 'output': 0.05; 'subject:Python': 0.06; 'things,': 0.09; 'python': 0.11; '1:13': 0.16; 'sqlite': 0.16; 'subject:versions': 0.16; 'uses,': 0.16; 'version?': 0.16; 'sender:addr:gmail.com': 0.17; 'wrote:': 0.18; 'library': 0.18; 'later': 0.20; 'import': 0.22; 'to:name :python-list@python.org': 0.22; "aren't": 0.24; 'fine': 0.24; 'versions': 0.24; 'looks': 0.24; "i've": 0.25; 'possibly': 0.26; 'post': 0.26; 'header:In-Reply-To:1': 0.27; 'installed': 0.27; "doesn't": 0.30; 'especially': 0.30; 'message-id:@mail.gmail.com': 0.30; "i'm": 0.30; '>>>>': 0.31; 'run': 0.32; 'running': 0.33; 'fri,': 0.33; 'display': 0.35; 'but': 0.35; 'received:google.com': 0.35; 'there': 0.35; 'version': 0.36; '2.6': 0.36; 'library.': 0.36; 'next': 0.36; 'possible': 0.36; 'should': 0.36; 'so,': 0.37; 'starting': 0.37; 'step': 0.37; 'depends': 0.38; 'to:addr:python- list': 0.38; 'fact': 0.38; 'pm,': 0.38; 'to:addr:python.org': 0.39; 'how': 0.40; 'most': 0.60; "you're": 0.61; 'first': 0.61; 'back': 0.62; "you've": 0.63; 'different': 0.65; 'between': 0.67; 'off,': 0.84; 'shape.': 0.84; 'differences': 0.93
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:sender:in-reply-to:references:from:date:message-id :subject:to:content-type; bh=To3dpNbhvAp37nQAwGrly62D7YitOAllgU6C7wMrHs8=; b=IRcNC8oo3zBmK+Nr5PzURJrAoHWuObYV1oYm4qVPjBTTCqnRBb1O59APvhzQNBaR/w sqggG8LqFfjlJIWYXtxxvM+XATgbAlyY+B51hiAkJIT7DpbpTZ/hi0YPu5aGwSI4lGJx L5tCx8+1nHaFTuFcRgyXm2YuPM5rl44c2Kb+uO7F+uAKn7yL7zRhrim2vw+hTBecetmU ZexhBjDhM3Yhn9srUoqyA8VuuIt93R88NcNjBtVwosjHxzmDFN4VD7tJtZvnAdPstrPp ODuaOTNdOkzefJC8jZrrA7g87XvAPSJMTGwaxWcVS3zY/VtuzrOB3ILYDBy6MfA98tE6 RFwQ==
X-Received: by 10.202.128.17 with SMTP id b17mr928802oid.51.1412967744996; Fri, 10 Oct 2014 12:02:24 -0700 (PDT)
MIME-Version: 1.0
Sender: zachary.ware@gmail.com
In-Reply-To: <m197l3$2r9$1@ger.gmane.org>
References: <m197l3$2r9$1@ger.gmane.org>
From: Zachary Ware <zachary.ware+pylist@gmail.com>
Date: Fri, 10 Oct 2014 14:02:04 -0500
X-Google-Sender-Auth: iAuDLXUorXR4ha8jy5QpT6Tbq7o
Subject: Re: Python and sqlite versions
To: "python-list@python.org" <python-list@python.org>
Content-Type: text/plain; charset=UTF-8
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.14760.1412967748.18130.python-list@python.org>
Lines: 43
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1412967748 news.xs4all.nl 2874 [2001:888:2000:d::a6]:48212
X-Complaints-To: abuse@xs4all.nl
Path: csiph.com!usenet.pasdenom.info!bete-des-vosges.org!feed.ac-versailles.fr!nerim.net!novso.com!newsfeed.xs4all.nl!newsfeed2a.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Xref: csiph.com comp.lang.python:78964

Hi Steve,

On Fri, Oct 10, 2014 at 1:13 PM, Simmo <steve@bellissimmo.com> wrote:
> 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.

Looks fine to me :)

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

How Python links with SQLite depends on several things, most
importantly which platform you're on.

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

There aren't a huge number of differences between various versions of
SQLite3 and fewer that you're likely to run into anyway, especially
just starting out.  You should be fine just using what you've got,
just keep the fact that you're running different versions in the back
of your mind if you come across differences that don't make any sense.

It may be possible to change the version that Python uses, but again
it depends on your platform and possibly your version of Python
(sqlite3.version has been the same from Python 2.6 to 3.5).

-- 
Zach