Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #73788

Re: Searching for lots of similar strings (filenames) in sqlite3 database

References <tgia8bx2sf.ln2@news.ducksburg.com> <53B2A604.3040208@mrabarnett.plus.com>
Date 2014-07-02 00:02 +1000
Subject Re: Searching for lots of similar strings (filenames) in sqlite3 database
From Chris Angelico <rosuav@gmail.com>
Newsgroups comp.lang.python
Message-ID <mailman.11367.1404223375.18130.python-list@python.org> (permalink)

Show all headers | View raw

On Tue, Jul 1, 2014 at 10:13 PM, MRAB <python@mrabarnett.plus.com> wrote:
> Anyway, I'm sure there's something in SQL for "insert or update" or "on
> duplicate", but that's an SQL question, not a Python question.

Not in standard SQL, no; there might be in SQLite, as a non-standard
extension, but it's a fundamentally hard problem and it has issues.
Frankly, though, I doubt the time cost of set operations is anything
significant compared to the various queries against the database.

ChrisA

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Searching for lots of similar strings (filenames) in sqlite3 database Adam Funk <a24061@ducksburg.com> - 2014-07-01 12:26 +0100
  Re: Searching for lots of similar strings (filenames) in sqlite3 database Chris Angelico <rosuav@gmail.com> - 2014-07-01 22:06 +1000
    Re: Searching for lots of similar strings (filenames) in sqlite3 database Adam Funk <a24061@ducksburg.com> - 2014-07-01 16:15 +0100
      Re: Searching for lots of similar strings (filenames) in sqlite3 database Chris Angelico <rosuav@gmail.com> - 2014-07-02 01:57 +1000
        Re: Searching for lots of similar strings (filenames) in sqlite3 database Adam Funk <a24061@ducksburg.com> - 2014-07-02 10:30 +0100
        Re: Searching for lots of similar strings (filenames) in sqlite3 database Adam Funk <a24061@ducksburg.com> - 2014-07-02 10:32 +0100
          Re: Searching for lots of similar strings (filenames) in sqlite3 database Chris Angelico <rosuav@gmail.com> - 2014-07-02 20:03 +1000
            Re: Searching for lots of similar strings (filenames) in sqlite3 database Adam Funk <a24061@ducksburg.com> - 2014-07-02 13:30 +0100
  Re: Searching for lots of similar strings (filenames) in sqlite3 database MRAB <python@mrabarnett.plus.com> - 2014-07-01 13:13 +0100
  Re: Searching for lots of similar strings (filenames) in sqlite3 database Chris Angelico <rosuav@gmail.com> - 2014-07-02 00:02 +1000

csiph-web