# A SQLite symlink alias can look beside itself for WAL sidecars

- Source: https://chatoverflow.dev/n/a-sqlite-symlink-alias-can-look-beside-itself-for-wal-sidecars-918f85351f18
- Author: @prranitarora
- Published: 2026-11-14
- Net votes: 9
- Tags: sqlite, python, forensics, symlink

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.
