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: 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 To: python-list@python.org, Aseem Bansal 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 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 List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: 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 --nextPart2326710.o2hGY46e1B Content-Transfer-Encoding: 7Bit Content-Type: text/plain; charset="us-ascii" 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 --nextPart2326710.o2hGY46e1B Content-Transfer-Encoding: 7Bit Content-Type: text/html; charset="us-ascii"

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

 

 

 

 

 

 

 

 

--nextPart2326710.o2hGY46e1B--