Groups > comp.lang.python > #51925

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!v102.xanadu-bbs.net!xanadu-bbs.net!news.mixmin.net!feeds.phibee-telecom.net!newsfeed.xs4all.nl!newsfeed3.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path	<SRS0=YgcJuv=RR=inqvista.com=inq1ltd@eigbox.net>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.070
X-Spam-Evidence	'H': 0.86; 'S': 0.00; 'yet.': 0.04; 'subject:Python': 0.06; 'python': 0.11; 'suggest': 0.14; 'basic.': 0.16; 'planet,': 0.16; 'received:66.96.186': 0.16; 'relates': 0.16; 'sqlite': 0.16; 'stats': 0.16; 'subject:library': 0.16; 'subject:sqlite3': 0.16; 'wrote:': 0.18; 'do.': 0.18; 'programming': 0.22; 'manual': 0.22; 'print': 0.22; 'creating': 0.23; 'header:User-Agent:1': 0.23; 'script': 0.25; '>': 0.26; 'compare': 0.26; 'header:In-Reply-To:1': 0.27; 'to:2**1': 0.27; 'tried': 0.27; 'getting': 0.31; 'received:10.20.15': 0.31; 'received:10.20.18': 0.31; 'received:10.20.55': 0.31; 'received:eigbox.net': 0.31; 'relational': 0.31; 'subject:learning': 0.31; 'table,': 0.31; 'there.': 0.32; 'another': 0.32; 'received:10.20': 0.33; 'subject:the': 0.34; 'received:66': 0.35; 'but': 0.35; 'url:rec-html40': 0.35; 'library.': 0.36; 'method': 0.36; 'charset:us-ascii': 0.36; 'url:org': 0.36; 'should': 0.36; 'received:10': 0.37; 'question,': 0.38; 'tired': 0.38; 'needed': 0.38; 'to:addr:python-list': 0.38; 'received:71': 0.39; 'to:addr:python.org': 0.39; 'users': 0.40; 'how': 0.40; 'commands': 0.60; 'subject:? ': 0.60; 'subject:Can': 0.60; 'august': 0.61; 'tag': 0.61; 'mentioned': 0.61; 'complete': 0.62; 'to:addr:gmail.com': 0.65; 'world': 0.66; 'answer.': 0.68; 'url:dtd': 0.80; 'received:bosmailout19.eigbox.net': 0.84; 'subject:know': 0.84; 'join.': 0.91; 'subject:\t': 0.91; 'url:strict': 0.95; '2013': 0.98
X-Authority-Analysis	v=2.0 cv=bNyU0YCZ c=1 sm=1 a=OM4p89hzk7gNUnVd/IJuIA==:17 a=spKFjZujUncA:10 a=2Cs5qbXtQ68A:10 a=CcwCF3CobcUA:10 a=OmMKortqy18A:10 a=tTExfe6FAAAA:8 a=z5UT3xBQDdIA:10 a=mLKua8RHAAAA:8 a=9cMADn83AAAA:8 a=KxUPLzSjYIoeLTEN7BoA:9 a=CjuIK1q_8ugA:10 a=P3uMDV8RXKwA:10 a=wQXOe_l8XVwA:10 a=SSmOFEACAAAA:8 a=PkNvJJx4rAbEfOxImvQA:9 a=_W_S_7VecoQA:10 a=frz4AuCg-hUA:10 a=qMDZ_Ezp4_0A:10 a=nJRjv4AizP7n6A2M:21 a=9MP9vxlQrmnoeofDS6o88g==:117
X-EN-OrigOutIP	10.20.18.2
X-EN-IMPSID	8eqM1m00202gpmq01eqMs5
From	inq1ltd <inq1ltd@inqvista.com>
To	python-list@python.org, Aseem Bansal <asmbansal2@gmail.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	Sun, 04 Aug 2013 11:01:10 -0400
Organization	inqvista
User-Agent	KMail/4.7.2 (Linux/2.6.37.6-24-desktop; KDE/4.7.2; i686; ; )
In-Reply-To	<2183b50a-b3d7-459f-bc00-5868fba5c7c3@googlegroups.com>
References	<2183b50a-b3d7-459f-bc00-5868fba5c7c3@googlegroups.com>
MIME-Version	1.0
Content-Type	multipart/alternative; boundary="nextPart2326710.o2hGY46e1B"
Content-Transfer-Encoding	7Bit
X-EN-UserInfo	ea107384e720a598200e9790e8ca8002:9d89a6cbd5a73a41b134431a25286195
X-EN-AuthUser	inq1ltd@inqvista.com
Sender	inq1ltd <inq1ltd@inqvista.com>
X-EN-OrigIP	71.246.152.230
X-EN-OrigHost	pool-71-246-152-230.rich.east.verizon.net
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.182.1375630514.1251.python-list@python.org> (permalink)
Lines	102
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1375630514 news.xs4all.nl 15967 [2001:888:2000:d::a6]:35346
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:51925

Show key headers only | View raw

[Multipart message — attachments visible in raw view] - view raw

On Saturday, August 03, 2013 10:57:32 AM Aseem Bansal wrote:
> I was writing a Python script for getting the user stats of a
> website(Specifically codereview.stackexchange). I wanted to store the 
stats
> in a database. I found Python3's sqlite3 library. I found that I needed sql
> commands for using it.
> 
> I have tried sql.learncodethehardway but it isn't complete yet. I tired
> looking on stackoverflow's  sql tag also but nothing much there. Can
> someone suggest me better resources for learning sql/sqlite3?

Go to:
sqlite-users@sqlite.org
and join.

Ask any question, you will get an answer.

Print out the manual.  For someone that is not 
familiar with Relational DB programming it
may look like a newspaper from 
another planet, but you should have it.

You mentioned creating a database for stats. Learn 
how to create a table, and populate it. that is basic.
Ask how to on the users help site, then compare the 
method sent to you to the manual.  You need to know 
how the answer relates to the manual.

The sqlite manual is in the standard format that is the 
accepted world wide.  Once you can understand 
the manual format you can work your way through a 
lot of what you want to do. 

jimonlinux
inqvista.com

Thread

csiph-web