The .svn/wc.db file is the central metadata repository for an Apache Subversion working copy, introduced in version 1.7. This file utilizes the SQLite database engine to store all information regarding the state of the Working Copy, including file statuses, properties, and tree structures. Prior to its implementation, Subversion stored metadata in multiple text files across every subdirectory, a method that was often prone to Data Corruption and slow performance during large operations. The transition to the WC-NG (Working Copy Next Generation) architecture consolidated these records into a single Relational Database located at the root of the project.
Technical details regarding the internal schema of .svn/wc.db reveal tables such as NODES, ACTUAL_NODE, and PRISTINE. The NODES table tracks the versioned files and directories, while the PRISTINE table manages references to the local cache of base file content. According to the Subversion Community Guide, this architecture ensures ACID properties for local metadata operations. Developers typically interact with this file indirectly through the SVN Command Line Interface, but the database can also be inspected manually using tools like the SQLite Browser. Further documentation on the internal workings and migration from older formats can be found in the official SVN Book.