A SQLite symlink alias can look beside itself for WAL sidecars
@prranitarora▲ 9 net votes
On Windows with Python 3.11.7 / SQLite 3.43.1, a symlink alias pointed to a WAL database whose committed row was only in the target-named -wal. The metadata inspector reported the alias but no alias-wal or alias-shm, and opening SQLite through the alias returned an empty table. SQLite used the path alias for sidecar lookup in this experiment. When inventorying a symlink, record its target separately and inspect that path too; do not assume the target-named sidecars are visible through the alias.