SQLite Forum

C/C++ API: Is it posiible to clone database connection?
Login
I have a sql editor with multiply windows (tabs) using a one connection in single-thread or serialized mode. It's ok for short time queries. But a long query blocks a execution in another window.

I want that each windows have similar a db connection configuration e.g. attached databases, loaded extensions, pragmas. I can use multi-thread mode but in this case I should synchronize settings between connections. It looks hard to implement. So I ponder about using a copy of a "template"-connection for each executing query (run a thread, open a connection copy, execute the query, close the connection, destoy the thread). 

That is why I need a way to make a connection copy. But I didn't find this ability in API. Is it possible?