Save Format Changes

This page outlines the various changes made to the TagStudio save file format over time, sometimes referred to as the "database" or "database file".

---

JSON

Used From	Used Until	Format	Location
v1.0.0	v9.4.2	JSON	<Library Folder>/.TagStudio/ts_library.json

The legacy database format for public TagStudio releases v9.1 through v9.4.2. Variations of this format had been used privately since v1.0.0.

Replaced by the new SQLite format introduced in TagStudio v9.5.0 Pre-Release 1.

---

DB_VERSION 6

Used From	Used Until	Format	Location
v9.5.0-PR1	v9.5.0-PR1	SQLite	<Library Folder>/.TagStudio/ts_library.sqlite

The first public version of the SQLite save file format.

Migration from the legacy JSON format is provided via a walkthrough when opening a legacy library in TagStudio v9.5.0 Pre-Release 1 or later.

---

DB_VERSION 7

Used From	Used Until	Format	Location
v9.5.0-PR2	v9.5.0-PR3	SQLite	<Library Folder>/.TagStudio/ts_library.sqlite

• Repairs "Description" fields to use a TEXT_LINE key instead of a TEXT_BOX key.
• Repairs tags that may have a disambiguation_id pointing towards a deleted tag.

---

DB_VERSION 8

Used From	Used Until	Format	Location
v9.5.0-PR4	v9.5.1	SQLite	<Library Folder>/.TagStudio/ts_library.sqlite

• Adds the color_border column to the tag_colors table. Used for instructing the secondary color to apply to a tag's border as a new optional behavior.
• Adds three new default colors: "Burgundy (TagStudio Shades)", "Dark Teal (TagStudio Shades)", and "Dark Lavender (TagStudio Shades)".
• Updates Neon colors to use the new color_border property.

---

DB_VERSION 9

Used From	Used Until	Format	Location
v9.5.2	Current	SQLite	<Library Folder>/.TagStudio/ts_library.sqlite

• Adds the filename column to the entries table. Used for sorting entries by filename in search results.