feat: sqlite pool options

[rpander93]

I use SQLite as storage for my Tauri application. By default, SQLx (the underlying driver) uses max. 10 parallel pool connections for SQLite.

When inserting a bunch of rows, I frequently get foreign key failure issues because the INSERT statements are spread across all connections and thus not in the right order. This plugin does not have proper transaction support (executing all statements on the same connection) and thus doesnt work either.

This PR implements the ability to limit the maximum number of connections in the pool. For me, by setting this to 1 connection maximum, I can ensure that all INSERTs are applied in the same order as I send them. Also, I can now start a transaction manually, because there's only ever 1 connection active.

Rust implementation based on https://github.com/tauri-apps/plugins-workspace/pull/2553

[github-actions[bot]]

Package Changes Through ce5cebbdf935095afd014fa8abdc8848fb199db1

There are 2 changes which include updater with minor, updater-js with minor

Planned Package Versions

The following package releases are the planned based on the context of changes in this pull request.

package	current	next
api-example	2.0.36	2.0.37
api-example-js	2.0.32	2.0.33
updater	2.9.0	2.10.0
updater-js	2.9.0	2.10.0

Add another change file through the GitHub UI by following this link.

---

Read about change files or the docs at github.com/jbolda/covector

[rpander93]

@FabianLars is there any interest of merging this?

[FabianLars]

interest yes but i have 0 time for the sql plugin at the moment. also, some ci checks failed :)

[rpander93]

okay. i've updated the PR to address the failing checks.