By one connection doing SELECT and UPDATE, do you mean multi-threaded mode and using the connection from 2 threads?
- Deon -----Original Message----- From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> On Behalf Of Simon Slavin Sent: Sunday, May 27, 2018 3:39 PM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] database locked on select On 27 May 2018, at 7:30pm, Torsten Curdt <tcu...@vafer.org> wrote: > I am doing a select, then iterate through the resultset and on each > row call update on that row. > I am using the golang driver and ran into the issue that on the update > the database is still locked from the select. Are you usihg one connection to do both the SELECT and the UPDATE ? Or are you using two different connections, one for the SELECT and one for the UPDATE ? The second method will not work. The SELECT connection has the database locked until you tell your interface you have finished with the SELECT. Simon. _______________________________________________ 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
