Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!feeds.phibee-telecom.net!newsfeed.xs4all.nl!newsfeed2.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.005 X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; 'scripts': 0.03; 'insert': 0.05; 'preference': 0.07; 'alias': 0.09; 'back.': 0.09; 'subject:How': 0.10; 'cc:addr:python-list': 0.11; 'thread': 0.14; 'from:addr:rosuav': 0.16; 'from:name:chris angelico': 0.16; 'sqlite': 0.16; 'subject:sqlite3': 0.16; 'wrote:': 0.18; 'pointed': 0.19; 'seems': 0.21; 'cc:addr:python.org': 0.22; 'logical': 0.24; 'replace': 0.24; 'cc:2**0': 0.24; 'mention': 0.26; 'post': 0.26; 'header:In-Reply-To:1': 0.27; 'am,': 0.29; 'subject:) ': 0.29; 'forgot': 0.30; 'message-id:@mail.gmail.com': 0.30; 'code': 0.31; 'fine,': 0.31; 'update.': 0.31; '(including': 0.33; 'says': 0.33; 'fri,': 0.33; 'subject: (': 0.35; 'johnson': 0.35; 'but': 0.35; 'received:google.com': 0.35; 'there': 0.35; 'whatever': 0.38; 'changed': 0.39; 'new': 0.61; 'you.': 0.62; 'subject:more': 0.64; 'more': 0.64; 'reply': 0.66; 'engines.': 0.91; 'to:none': 0.92; 'engines,': 0.93 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:cc :content-type; bh=XaLE6oOGNw2Ks2wsCaDlajeXNb0gaFvjiqwMETJri3c=; b=APFRAy8Y+Q3V7G2AMoykCra3hjkrkzB+Ed6GUvkrZMJJJdQlNpdyZGXct+VCc/Z6fv wqxawlhMIVCJNCfP0VHfUxit0vD4jGUaqwt87wR8PVy2Hx+XPOPu/54eDjviln2UY8gf pFrq9AjRdcVtGoutFPGv45ntPJonKxF+jFNr+wUVzaJ39gi1g1lduhaOd+UjZKvgX0SQ 3XwCmgWBy3VnlCVnPybMVdgpDPKsN67zCM7WVP1ByRCu7uXCXpMc/GajD4e+qIlJ0Lms onm7BFjRT3mst/iUu7SwXi0s/hHMsVlvXMrpAC74gi14G0fDK/T+hgwIewBB2mZCxGJN gm0Q== MIME-Version: 1.0 X-Received: by 10.53.12.229 with SMTP id et5mr109219vdd.32.1402000157163; Thu, 05 Jun 2014 13:29:17 -0700 (PDT) In-Reply-To: <5390CF15.2050208@gmail.com> References: <5390CF15.2050208@gmail.com> Date: Fri, 6 Jun 2014 06:29:17 +1000 Subject: Re: How to use SQLite (sqlite3) more efficiently From: Chris Angelico Cc: "python-list@python.org" Content-Type: text/plain; charset=UTF-8 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: 20 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1402000159 news.xs4all.nl 2928 [2001:888:2000:d::a6]:36030 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:72761 On Fri, Jun 6, 2014 at 6:12 AM, R Johnson wrote: > I forgot to mention that the scripts Peter pointed to used REPLACE instead > of INSERT OR REPLACE. The SQLite documentation says that REPLACE is an alias > for INSERT OR REPLACE provided for compatibility with other SQL database > engines. Is there a preference for one or the other? > > I had changed my code from using INSERT OR REPLACE to using REPLACE > (including my new sample), but since then changed it back. I don't care > about compatibility with other database engines, and INSERT OR REPLACE seems > more logical to me, since REPLACE sounds like a synonym for UPDATE. (Suggestion: Always reply to an existing post if it's part of the same thread. Replying to your own post is fine, and it links the thread together nicely.) You can use either, and they're equally non-standard - in my opinion, equally wrong. Whatever feels right to you. ChrisA