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

Chris Angelico rosuav at
Tue Jul 1 16:02:51 CEST 2014

On Tue, Jul 1, 2014 at 10:13 PM, MRAB <python at> 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.


More information about the Python-list mailing list