Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql.

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> (permalink)
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

Show key headers only | View raw

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/

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

Thread

csiph-web