How to use SQLite (sqlite3) more efficiently

Date	2014-06-05 16:12 -0400
From	R Johnson <ps16thypresenceisfullnessofjoy@gmail.com>
Subject	How to use SQLite (sqlite3) more efficiently
Newsgroups	comp.lang.python
Message-ID	<mailman.10764.1401999691.18130.python-list@python.org> (permalink)

Show all headers | View raw

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.

-- Timothy

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

Thread

How to use SQLite (sqlite3) more efficiently R Johnson <ps16thypresenceisfullnessofjoy@gmail.com> - 2014-06-05 16:12 -0400

csiph-web