I didn't know it is possible to insert multiple rows into a table using a command like this. Is this just an SQLite feature, or is this part of the SQL standard?
RobR On Mon, Sep 2, 2019 at 8:14 AM Dominique Devienne <ddevie...@gmail.com> wrote: > On Mon, Sep 2, 2019 at 12:52 PM Simon Slavin <slav...@bigfraud.org> wrote: > > > > One must know that I am obliged to use "BEGIN DEFERRED TRANSACTION" > > because others threads needs to access to tables. > > SQLite copes very well when you have one connection writing to the > > database and other connections reading. The problems come when you have > > two connections writing to the database at once. > > > > In WAL mode only! Otherwise readers are blocked when the writer is active, > and readers prevent the writer from proceeding. --DD > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users