Re: [sqlite] UPSERT available in pre-release

Perfect, That’s a big step of SQLite. I think one of our projects will benefit of the new upsert. Thanks a lot. wordcount --all :memory: sqlite3.c 2.422 wordcount --insert 2.341 wordcount --insert --without-rowid 3.610 wordcount --replace 1.766 wordcount --replace --without-rowid

Re: [sqlite] "Tagging" SQLite tables with attributes for introspection.

This works for me: DROP TABLE IF EXISTS processing; CREATE TABLE processing(   tableName TEXT NOT NULL PRIMARY KEY,   touch_me_please INT DEFAULT 0,   Ive_been_touched INT DEFAULT 0 ) WITHOUT ROWID; INSERT INTO processing(tableName) SELECT name FROM sqlite_master WHERE type = 'table';