Path: csiph.com!usenet.pasdenom.info!gegeweb.org!usenet-fr.net!nerim.net!novso.com!newsfeed.xs4all.nl!newsfeed3.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!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.010
X-Spam-Evidence: '*H*': 0.98; '*S*': 0.00; 'subject:Python': 0.06; 'combines': 0.09; 'hierarchical': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'runtime': 0.09; 'language.': 0.14; "wouldn't": 0.14; 'books': 0.15; 'edition.': 0.16; 'message- id:@4ax.com': 0.16; 'rdbms': 0.16; 'received:80.91.229.3': 0.16; 'received:plane.gmane.org': 0.16; 'subject:library': 0.16; 'subject:sqlite3': 0.16; 'yang': 0.16; ':-)': 0.16; 'wed,': 0.18; 'aug': 0.22; 'logical': 0.24; 'skip': 0.24; 'url:home': 0.24; 'sort': 0.25; 'define': 0.26; 'possibly': 0.26; 'header:X -Complaints-To:1': 0.27; "i'm": 0.30; '(which': 0.31; 'relational': 0.31; 'shelf': 0.31; 'subject:learning': 0.31; 'probably': 0.32; 'third': 0.33; '"the': 0.34; 'subject:the': 0.34; 'could': 0.34; 'there': 0.35; 'useful': 0.36; 'charset:us- ascii': 0.36; 'received:76': 0.38; 'server': 0.38; 'to:addr :python-list': 0.38; 'von': 0.38; 'to:addr:python.org': 0.39; 'received:org': 0.40; 'how': 0.40; 'even': 0.60; 'subject:? ': 0.60; 'subject:Can': 0.60; 'most': 0.60; 'first': 0.61; 'back': 0.62; 'more': 0.64; 'afraid': 0.65; 'life': 0.66; 'physical': 0.72; 'fourth': 0.84; 'subject:know': 0.84; 'edition': 0.86; 'calculus': 0.91; '2013': 0.98
X-Injected-Via-Gmane: http://gmane.org/
To: python-list@python.org
From: Dennis Lee Bieber <wlfraed@ix.netcom.com>
Subject: Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql.
Date: Wed, 07 Aug 2013 18:34:05 -0400
Organization: IISS Elusive Unicorn
References: <2183b50a-b3d7-459f-bc00-5868fba5c7c3@googlegroups.com> <CANc-5UxSYqHMGULJSrxGSN9rKyy2KMF7BmY-hZOq7tja3P6edw@mail.gmail.com> <CANc-5UwRYNncz3MFVt3pJTnU5YrGeWzzvzAnpZT22CM1B6bhCw@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Gmane-NNTP-Posting-Host: adsl-76-249-23-94.dsl.klmzmi.sbcglobal.net
X-Newsreader: Forte Agent 6.00/32.1186
X-No-Archive: YES
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: <http://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: <http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups: comp.lang.python
Message-ID: <mailman.329.1375914854.1251.python-list@python.org>
Lines: 30
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1375914854 news.xs4all.nl 15968 [2001:888:2000:d::a6]:35897
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:52153

On Wed, 7 Aug 2013 12:43:55 -0500, Skip Montanaro <skip@pobox.com>
declaimed the following:


>Mine's the third edition.  It even has a Sybase SQL Runtime CDROM
>inside the back cover.  How quaint. :-)  There is a fourth edition
>available.

	Well -- it might be useful for transitioning to M$ SQL Server/MSDE...
As I recall, SQL Server started life as a port of Sybase. <G>

	Thought Codd did NOT define SQL (which sort of combines relational
calculus with some relational algebra); early relational theory was more a
"view" and "analysis" of database data -- which could possibly be overlaid
on hierarchical and network implementations. SQL was about a decade later,
branched off of the Sequel language. Most modern RDBMs seem to have
reverted to using the logical view as the physical storage <G>

	I'm afraid the books on my shelf wouldn't help for SQL...

	Yang "Relational Databases", Date "Database Design and Relational
Theory", Maier "The Theory of Relational Databases", and von Halle
"Handbook of Relational Database Design" (and Gio Wiederhold is in storage)

	Most of them probably predate the first SQL standard <G>

-- 
	Wulfraed                 Dennis Lee Bieber         AF6VN
    wlfraed@ix.netcom.com    HTTP://wlfraed.home.netcom.com/