unable to open database file via dsn path

[thoongnv]

I want to open the SQLite database file in read-only mode (to allow read access, e.g. SELECT) so I tried these DSN URLs:

let path = "sqlite:///data/mydb.sqlite?mode=ro";
// let path = "sqlite:/data/mydb.sqlite?mode=ro";
// let path = "sqlite:/data/mydb.sqlite";

let pool = deadpool_sqlite::Config::new(path).create_pool(deadpool_sqlite::Runtime::Tokio1).unwrap();

But none of this works, is there any wrong in config, or deadpool-sqlite/ rusqlite not support this?

[bikeshedder]

I think this is related to #214.
There is PR #292 which is a bit stale.

It should be fairly simple to complete this. I just haven't come around implementing it, yet.

PRs are always welcome! 👍

[thoongnv]

oops, looks like it works now with file: prefix. I have used the wrong prefix: https://www.sqlite.org/c3ref/open.html

let path = "file:/data/mydb.sqlite?mode=ro";

[bikeshedder]

Thanks for the feedback! 👍