The option described in this section is experimental. Most users will not find it of interest.
As the media that consumers can maintain on their computers continues to increase, it will eventually be useful to use full scale data bases to keep track of and access this data. This panel allows you to enter all information in the library into a PostgreSQL database if you have that software installed. (It is can be downloaded for free.)
To enter your library into an SQL database select Edit-->preferences from the main window. Then select the SQL experimental tab.
Use the browse button on this window to select a temporary directory that mdb can write to and PostgreSQL can read from.
Use the first text entry line to change the database name. This database must exist before mdb can add a table to it or update an existing table.
Use the second text entry line to change the database table name that mdb will create or change.
The restore defaults button restores the factory defaults for directory, database name and table name.
The write database button writes the information in the library to the database you specified. If the write completes successfully a popup window will indicate this. Otherwise an error message will be displayed.
Once you successfully write a database you can use PostgreSQL commands to access the library information.