How to pool SQLite connections
I am building a monolithic JSON api and wish to have sparate connection pools for readers and writers. System.Data.SQLite has connection option "Pooling" but there is no documentation what it does, and there is for example no MaxPoolSize or similiar. I am trying to achive 1 writer connection, and a pool of reader connections (1 connection per core max).
3 Replies
is there a reason youre not using an ORM?
you can use dapper if you want raw sql, itll handle connection pooling
Connection strings - Microsoft.Data.Sqlite
The supported keywords and values of connection strings.