Use sqlite3_open_v2 to support only read mode

[siscia]

It could be useful to use sqlite3_open_v2, instead of sqlite_open.

In this way it will be possible to have more control in which way the database is used.

https://www.sqlite.org/c3ref/open.html

[siscia]

@mmzeeman thoughts ?

I am definitely not very suited to do this job...

I don't have much experience with erlang and definitely with writing bif module...

[mmzeeman]

This is not very difficult to do. The thing is that I currently I'm busy with: https://github.com/zotonic/zotonic/wiki/Improving-zotonic's-throughput

PR's are welcome though.

[siscia]

Ok, I will try my best then :)

Really unsure about the result though...

[mmzeeman]

👍 Erlang probably isn't as scary as you think it is. . :-)

[mmzeeman]

esqlite is compiled with the SQLITE_USE_URI flag. This makes it possible to open a database in readonly mode. See https://sqlite.org/uri.html for details.