Difference between revisions of "Data Directory/Database"

Revision as of 14:51, 3 February 2017

MatterControl keeps all internal settings in an SQLite database in the application data folder. On Windows this is at C:\Users\{user}\AppData\Local\MatterControl\MatterControl.db. On Linux and Mac it is at ~/.local/share/MatterControl/MatterControl.db.

You can edit the database file using a program like SQLite Browser or SQLite Manager for Firefox.

Database Structure

Here is a brief description of the tables in the database and what they are used for

ApplicationSession

This is a log of each time the MatterControl application is started and stopped.

CustomCommands

Unused in version 1.6 or later. This used to store the [Macros].

PrintItem

Contains items that can be found in the [Library] and the [History]. Does not contain items from the Queue, Cloud Library, or your Downloads folder.

PrintItemCollection

List of folders in the [Library].

PrintTask

This is the log of all prints that have been performed. The last 20 of these are shown in the History.

Printer

Unused in version 1.6 or later. This contained the list of printers, with their name, make/model, communication settings, and Software Print Leveling data. Printers are now stored as individual .printer files (JSON) in Profiles folder.

PrinterSettings

Unused

SliceSettings

Unused in version 1.6 or later. This contained the values of all slice settings for all printers and presets. All settings have now been moved to .printer files.

SliceSettingsCollection

Unused in version 1.6 or later. This was a list of presets and baseline profiles, and mappings to their associated SliceSettings.

SystemSetting

Internal state of the application.

UserSetting

Internal state of the application.

sqlite_sequence

Database status.