SQLite Forum

Get SQLITE_READONLY when using UPDATE command
Login
> The "proper" URL would be "file://Users/David/test.db" which would be the file \\Users\\David\\test.db on the current drive (ie, the current directory location when the program is loaded.

> The format specified is FUBAR.

SQLite does not require the double-slash between the URI's scheme part and the remainder. However, per my reading of <u>[RFC 3986](https://xml2rfc.tools.ietf.org/public/rfc/html/rfc3986.html#components)</u>, it should.<sup><b>1</b></sup> So, in that sense, the OP's URL is improper and other adjectives may apply.

I'm not sure how this deviation arose or should be handled now given the backwards compatibility issues.

----

1. This deviation creates an ambiguity between absolute and relative pathnames. SQLite interprets a leading/only slash after the scheme as the beginning of an absolute path. To get a relative path, no leading slash should be used.