19.2.1 Setting up a Direct SQL Connection Shared Database

This section has instructions for setting up a new Shared Database. For instructions on how to connect to a Shared Database from Geneious Prime refer to section 19.1.3 .

Supported Database Systems

To use a database as a Shared Database, Geneious requires that it support transactions with an isolation level set to READ COMMITTED. Supported databases systems include Microsoft SQL Server, PostgreSQL, Oracle and MySQL. It is possible to use other database systems if you provide the database driver, see section 19.2.1 .

Shared Databases have been tested using:

Note: When using Microsoft SQL Server we strongly recommend using Snapshot Isolation to avoid deadlocks. These can occur when multiple users use the shared database at once and may lead to failure of some actions. This setting becomes necessary if there will be more than a handful of users using the database concurrently. Read more about Snapshot Isolation here: https://msdn.microsoft.com/en-us/library/tcbchxcb(v=vs.110).aspx.

Document Size Limitations

For Direct SQL Connection Shared Databases, document size is limited by the database’s maximum binary large object (BLOB) size. This varies between 1-4 GB. Refer to the documentation of your database system for the maximum BLOB size.

Setting up an SQL database to use with Geneious Prime

Follow these steps to set up a Direct SQL Connection shared database to use with Geneious Prime. The instructions in this section require knowledge of how to create and administer an SQL database and are intended for your IT department or system administrator. For instructions on connecting to your shared database once it has been set up, refer to section 19.1.3 .

  1. Create database
  2. Add users to your database using the database management system
  3. Set up database with Geneious Prime
  4. Set the first Database Admin
  5. Set up sharing permissions for your database

Your database should now be ready to use with Geneious Prime. Users can connect to the database by clicking on Shared Databases in the Sources panel and then clicking New database connection. This will bring up a dialog for the user to enter in the database details.

Supplying Your Own Database Driver

Shared Databases were designed with the supported databases in mind and packaged with database drivers for them. However, Geneious allows you to supply your own jdbc database driver if you want to, for example if you have an updated driver, or want to use a driver for an unsupported database. It is not guaranteed that Shared Databases will work with an unsupported database system but it is likely that it will if you provide the correct driver.

You can supply your own driver under More Options in the New database connection dialog, or the Edit Account Details dialog (available by right clicking on the root folder of your shared database) for an existing shared database.