pg_duckdb icon indicating copy to clipboard operation
pg_duckdb copied to clipboard

Make DuckDB connection a singleton

Open JelteF opened this issue 1 year ago • 1 comments

In #174 we made the DuckDB database a singleton, but a new DuckDB connection was still being created for every query. This means that any connection state, such as SET commands or temporary tables don't survive a single query, which is pretty confusing. This addresses that by also making the duckdb::Connection a singleton, this way a Postgres connection and a DuckDB connection are linked 1-to-1.

JelteF avatar Sep 23 '24 23:09 JelteF