I am a little unclear on some of the ways transactions affect multiple connections. I am assuming that multiple sqlite3 objects in one program is the same as multiple programs.
1) How does a transaction affect SELECTs? If I start a transaction and do an UPDATE/DELETE/INSERT, what data will a SELECT in the same transaction see? What about a SELECT in a different connection? 2) Can 2 connections run 'BEGIN;' ? If so, who gets the final say on the data? The first to do the 'COMMIT;'? What will happen when the other does a COMMIT? Thanks -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
