Cerious Software Order Now!
Client/Server Database Support

Note: These instructions are for ThumbsPlus Pro, Home Network, and Network (concurrent) slicenses. ThumbsPlus Standard edition uses only the default Access (Jet) database format.

ThumbsPlus versions 8 and 9

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 prior format.

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.

Database Recommended versions 1
Web site
SQL Script 2
MS SQL Server 2008, 2012
MySQL 5.6
MariaDB 10.0 MariaDB Download
PostgreSQL 9.2

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 attribute.

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.

 
ThumbsPlus version 7.0SP2

As installed, ThumbsPlus creates a database called Thumbs.td4 using the Microsoft Access JET format. However, ThumbsPlus uses ODBC to communicate with its database, so other database formats can be used instead. (Note: Pro, Home Network and Network licenses only; a Standard license can only use the default JET database.)

Client/server databases offer improved performance, especially in a network environment, and the capability to have databases larger than the JET 2 gigabyte limit.

The following databases have been tested by Cerious Software with ThumbsPlus version 7 SP2 (build 2251), and we have database creation scripts that you can customize and use to create an empty ThumbsPlus database for each of them:

Database Recommended versions 1
Web site
SQL Script 2
MS SQL Server 2005 - 2012
Sybase SQL Anywhere 9
MySQL 4.1.18, 5.x
PostgreSQL 8.0
Firebird 1.5
IBM DB2 9

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.

 

 
The contents of this web site (text and graphics) are copyright ©1997-2014, Cerious Software Inc.
Cerious and ThumbsPlus are registered trademarks of Cerious Software, Inc.
Please send comments or suggestions about our web site to: hostmaster@cerious.com.
For ordering support, please email orderdesk@cerious.com.
For technical support, please email support@cerious.com.