Allow specifying more options through sqlite URL

Open xtexx opened this issue 1 year ago • 2 comments

Is your feature request related to a problem? Please describe. Currently, a lot of options are available in SqliteConnectOptions, but only a few of them can be specified by URL string.

It is easy to configure them when connecting directly with SqliteConnectOptions.connect, but it will be hard to configure when using the any driver.

Jul 21 '24 01:07 xtexx

Please provide a list of the options you need. Many of them shouldn't be configured in the URL, like extensions; the application needs to specify the extensions it's expecting.

Jul 22 '24 22:07 abonander

journal_mode, locking_mode, synchronous

For different scale of database, I think changing these will be helpful to improve the performance (in the trade-off between data persistence and performance).

Jul 23 '24 06:07 xtexx