As installed, ThumbsPlus creates a database called
Thumbs.tpdb8 using the Microsoft Access JET format. However, ThumbsPlus uses
ODBC to communicate with its database, so other database formats
can be used instead.
Client/server databases offer greatly improved performance when sharing a database in a network environment, and the capability to have
databases larger than the JET 2 gigabyte limit.
Upgrading from version 7: Use the menu selection Database - Advanced - Convert client/server to convert the database from the earlier format. Be sure to back up your database first, in case of any problems during the conversion.
Creating a new database: Here are SQL scripts that you can download to create a new database of the desired format. MariaDB is a drop-in replacement for MySQL and currently uses the same installation script.
Note that you should open the script in a text editor to modify it for your specific database and to select the desired thumbnail size and other constants. You may want to use the tools provided with the database to create it and control the locations and names of the database data and log files. Also you may want to change the INSERTs to the ThumbsPlusDatabase table to match the desired thumbnail size, compression, and other attributes.
Other databases may be supported in the future. If you have a specific request, please submit a problem report.
1 Other versions may work; these are the versions with which we
have most recently tested ThumbsPlus and the scripts.
2 Right-click and select Save Link As or Save Target As to save the script
to your computer. Use notebad to make changes, then command-line or query tool for your
database to execute it.
Some databases may require that you download
a separate package for ODBC support, and you will need to configure
an ODBC data source for connecting to the database. The ThumbsPlus
version 7 Manual has information on creating an ODBC
data source, in the SQL Server Administration section.