Path: csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!feeder.erje.net!eu.feeder.erje.net!xlned.com!feeder3.xlned.com!newsfeed.xs4all.nl!newsfeed4.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.028 X-Spam-Evidence: '*H*': 0.94; '*S*': 0.00; 'yet.': 0.04; 'subject:Python': 0.06; 'cc:addr:python-list': 0.11; 'python': 0.11; 'suggest': 0.14; 'sqlite': 0.16; 'stats': 0.16; 'subject: \n ': 0.16; 'subject:library': 0.16; 'subject:sqlite3': 0.16; 'url:sqlite': 0.16; 'sat,': 0.16; 'wrote:': 0.18; 'aug': 0.22; 'cc:addr:python.org': 0.22; 'cc:2**0': 0.24; 'script': 0.25; 'header:In-Reply-To:1': 0.27; 'tried': 0.27; 'message- id:@mail.gmail.com': 0.30; 'url:mailman': 0.30; 'getting': 0.31; 'subject:learning': 0.31; 'there.': 0.32; 'url:python': 0.33; 'subject:the': 0.34; 'but': 0.35; 'received:google.com': 0.35; 'library.': 0.36; 'url:listinfo': 0.36; 'url:org': 0.36; 'tired': 0.38; 'needed': 0.38; 'pm,': 0.38; 'url:mail': 0.40; 'commands': 0.60; 'subject:? ': 0.60; 'subject:Can': 0.60; 'tag': 0.61; 'complete': 0.62; 'to:addr:gmail.com': 0.65; 'home': 0.69; 'subject:know': 0.84; 'joel': 0.91; '2013': 0.98 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :cc:content-type; bh=P7q7QD/rJlPSlsS/4r6S7pKZKHvnI24ce7t3lXcReTI=; b=pWHv42S6jLlWp5kOKyUzozTL40y5GThCFeg3fV4f+do6Bn0VEOpt9RRl66OnKiNaDS 4o1413ZTZcso69jCqIXXD/e23BOK98gi4nA6WBhI+i0YkmLlC9ztJmFLwb2bS9OkODzq Bb3XltjhMkFNGulUaZYJWBY1fEgM7OM630IJH4Ts7krgjVSqGQ0+FRLaNvtOrTppEpO2 zXsiTiZ3lg0/43hO1wk4vnHGiwxoNM26p/X9yE8oej+qAyuh01xjm6BzZeD4Xpd8zWBn YrKbJtJ3/1eA9+ZwKQ5g7LTXo/2n6Pnjwix9mCNzOBU8qYw4r6n8D3N719MHOcrf+iZy XPsg== MIME-Version: 1.0 X-Received: by 10.52.117.79 with SMTP id kc15mr600592vdb.45.1375555991765; Sat, 03 Aug 2013 11:53:11 -0700 (PDT) In-Reply-To: <2183b50a-b3d7-459f-bc00-5868fba5c7c3@googlegroups.com> References: <2183b50a-b3d7-459f-bc00-5868fba5c7c3@googlegroups.com> Date: Sat, 3 Aug 2013 14:53:11 -0400 Subject: Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql. From: Joel Goldstick To: Aseem Bansal Content-Type: text/plain; charset=UTF-8 Cc: "python-list@python.org" 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: 16 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1375556000 news.xs4all.nl 15900 [2001:888:2000:d::a6]:52374 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:51878 On Sat, Aug 3, 2013 at 1:57 PM, 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? Have you tried the sqlite home page at http://www.sqlite.org/ > -- > http://mail.python.org/mailman/listinfo/python-list -- Joel Goldstick http://joelgoldstick.com