2,552
edits
Changes
no edit summary
{{DISPLAYTITLE:Database}}MatterControl keeps all internal settings in an SQLite database in the [[Frequently_Asked_Questions#How_do_I_clear_the_application_data.3F|application data folder]]. On Windows this is at {{ic|C:\Users\{user}\AppData\Local\MatterControl\MatterControl.db}}. On Linux and Mac it is at {{ic|~/.local/share/MatterControl/MatterControl.db}}.
You can edit the database file using a program like [http://sqlitebrowser.org/ SQLite Browser] or [https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/ 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 [[http://wiki.mattercontrol.com/CONTROLS/Macros|G-Code Macros]].
=== PrintItem ===
Contains items that can be found in the [[http://wiki.mattercontrol.com/LIBRARY|Local Library]] and the [[http://wiki.mattercontrol.com/History|Print History]]. Does not contain items from the [[Queue]], Cloud Library, or your Downloads folder.
=== PrintItemCollection ===
List of folders in the [[http://wiki.mattercontrol.com/LIBRARY|Local 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 [[OPTIONS/Software_Print_Leveling|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 [[SETTINGS|slice settings]] for all printers and [[SETTINGS#Preset_Menus|presets]]. All settings have now been moved to .printer files.
=== SliceSettingsCollection ===
'''Unused in version 1.6 or later'''. This was a list of [[SETTINGS#Preset_Menus|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.