Re: MacPorts 2.7.0-beta1 sqlite error: attempt to write a readonly database

[Ryan Schmidt]

On Apr 29, 2021, at 10:32, Joshua Root wrote:

> It appears that SQLite version 3.35.5 as installed by the sqlite3 port 
> deletes a database's -wal and -shm files at least some of the time when 
> closing. SQLite version 3.28.0 as shipped as /usr/bin/sqlite3 on Catalina 
> does not. The existence of these files is necessary to read a WAL mode 
> database in a directory that you don't have write permission on.

https://sqlite.org/wal.html#avoiding_excessively_large_wal_files

"When the last connection to a database closes, that connection does one last 
checkpoint and then deletes the WAL and its associated shared-memory file, to 
clean up the disk."