Path: csiph.com!usenet.pasdenom.info!aioe.org!news.stack.nl!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.052 X-Spam-Evidence: '*H*': 0.90; '*S*': 0.00; 'subject:Python': 0.06; 'plenty': 0.07; 'cc:addr:python-list': 0.11; 'suggest': 0.14; 'books': 0.15; 'from:addr:pobox.com': 0.16; 'from:addr:skip': 0.16; 'subject: \n ': 0.16; 'subject:library': 0.16; 'subject:sqlite3': 0.16; 'work.)': 0.16; 'language': 0.16; 'sender:addr:gmail.com': 0.17; 'cc:addr:python.org': 0.22; 'skip': 0.24; "haven't": 0.24; 'cc:2**0': 0.24; 'query': 0.26; 'header:In- Reply-To:1': 0.27; 'especially': 0.30; 'message- id:@mail.gmail.com': 0.30; 'work.': 0.31; 'helpful.': 0.31; 'subject:learning': 0.31; 'award': 0.32; 'subject:the': 0.34; "can't": 0.35; 'received:google.com': 0.35; 'building': 0.35; 'there': 0.35; "i'll": 0.36; 'behind': 0.37; 'changed': 0.39; 'easy': 0.60; 'subject:? ': 0.60; 'subject:Can': 0.60; 'desk': 0.61; 'new': 0.61; 'first': 0.61; 'name': 0.63; 'developed': 0.63; 'refer': 0.63; 'to:addr:gmail.com': 0.65; 'subject.': 0.74; 'badly,': 0.84; 'subject:know': 0.84; 'textbook': 0.84 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:sender:in-reply-to:references:date:message-id:subject :from:to:cc:content-type; bh=WOJy6+CNwmv+w/UOvIPK6Wz2R1/p4BajHsWepcbrg3U=; b=kT2FpqRugMYurfd/EUV+3724ZWLZj3DrXlhtqCogvXcLXC63wuUZHl+Lj8LfG77VUQ f4d+MA5lPZft2rdk0IOg05IihUkUSRolEMmhRypdKtzz4AvtsOwZ2x+M4Lt01A5R9rs7 NDNXEN5zUnx9R1c2vxV9iCK/XhE5v5OXM+RPxgKDitMDlBcpTwppgnfLHZkD7QEPiQbJ dxTJMSQYvmkqBpQttfbZ4X9MfeysHNpY5sGV23WcU4EEoIkHlFRVMokTupKrJFUtLlIV Ae17f8d0c2GyyQakMvMEv0+ITZJpdjSG7gNa0ZKpQnW2plPUfAA9qgDqgg1B3USO6nKo gZHQ== MIME-Version: 1.0 X-Received: by 10.43.14.74 with SMTP id pp10mr185702icb.87.1375873185365; Wed, 07 Aug 2013 03:59:45 -0700 (PDT) Sender: skip.montanaro@gmail.com In-Reply-To: <2183b50a-b3d7-459f-bc00-5868fba5c7c3@googlegroups.com> References: <2183b50a-b3d7-459f-bc00-5868fba5c7c3@googlegroups.com> Date: Wed, 7 Aug 2013 05:59:45 -0500 X-Google-Sender-Auth: sNgg6nfHRwZvqYL1idFFPOcJ_wo Subject: Re: Can someone suggest better resources for learning sqlite3? I wanted to use the Python library but I don't know sql. From: Skip Montanaro To: Aseem Bansal Content-Type: text/plain; charset=UTF-8 Cc: Python 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: 15 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1375873194 news.xs4all.nl 15910 [2001:888:2000:d::a6]:40593 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:52130 > Can someone suggest me better resources for learning sql/sqlite3? The concepts behind the Structured Query Language haven't changed much since Edgar Codd first developed them in the 1970s. (He received the Turing Award in 1981 for this work.) Building and querying databases is very easy to do very badly, especially if you are new to its concepts. This is a case where a textbook might be helpful. Since these ideas have been around for a long while, there are plenty of good books on the subject. I have one on my desk at work whose name I can't remember off the top of my head. I still refer to it from time-to-time. If you'd like a reference, let me know and I'll check on it at work. Skip