multithreading - Thread-safe last_insert_row_id for ruby SQLite library -

i wondering thread-safe way last_insert_row_id be. code looks like:

require 'sinatra' require 'sqlite3'  db = sqlite3::database.connect("dbname.db")  '/'    db.execute("insert logs (ip,time) values (?,now())",[request.ip])   return "your row id #{db.last_insert_row_id}" end 

it's little silly of example, point if 2 people visit @ same time, race condition such 2 people given same row id. how avoid this?

baisicly i'm looking ruby-equivelent answer question: how retrieve inserted id after inserting row in sqlite using python? looked , couldn't find in sqlite gem docs cursor, , googling brought me resultset class not have method of retrieving last insert id.

the "last insert rowid" property of connection, if need track row ids in multithreaded application, think need separate sqlite connection each thread.

an alternative next id manually selecting value sqlite_sequence table (note works if table has explicit primary key autoincrement column):

begin; select seq sqlite_sequence name = 'your_table'; -- remember value in ruby update sqlite_sequence set seq = seq+1 table = 'your_table'; commit; 

and then:

db.execute("insert logs (pk_column,ip,time) values (?,?,now())",[preselected_row_id,request.ip]) 

the downside of second approach it's bit slow when compared simple insert.