tempStoreDirectory

Queries or sets the directory where temporary files are stored.

This pragma specifies the directory that SQLite will use to store temporary files, such as those created for temporary tables when tempStore is set to FILE.

• When querying, it returns the current directory path as a string. An empty string indicates that a system-dependent default location is being used.

• When setting, you must provide a path to an existing and writable directory.

Changing this directory affects all database connections within the current process. It is only effective when temp_store is configured to use file-based storage.

See also