What SQL Database choices do I have?

Monetra's database support strives to be as simple to configure as possible by automating tasks such as initial schema creation. If using our native database, SQLite, there should be no configuration needed at all as Monetra contains all the proper defaults, and will auto-initialize a new database. If opting to upgrade to an external SQL database, which would provide options for load balancing, fault tolerance, and enhanced performance, or if you have an already existing database server you wish to utilize, the procedure is typically as simple as loading the appropriate module in Monetra and pointing it to a newly created database or namespace with the proper authentication credentials, and Monetra will do the rest.

Monetra provides native database modules (linked directly to the client libraries provided by the database) for the major databases on the market. The modules are distributed in source form, with binaries available on most Unix OS's, linked to the latest available database release at the time, where applicable. These are the supported native databases we provide modules for:

  • PostgreSQL 7.4+
  • MySQL 5+
  • Oracle 8+
  • IBM DB2
  • SQLite 3.5+

Monetra also provides ODBC driver support which extends the number of databases Monetra can operate. On Unix systems, you may utilize the iODBC or UnixODBC implementations, for Windows systems, you would utilize Microsoft's native ODBC (Data Sources). The ODBC implementation attempts to perform auto-detection of the underlying database in order to determine the featureset that particular database supports. If detection is not successful, there are a series of tunable flags that can be utilized to achieve compatibility and the best performance. Tested and auto-recognized databases include:

  • Microsoft SQL Server 2000+
  • PostgreSQL 7.4+
  • MySQL 5+
  • Oracle 8+
  • IBM DB2
  • Firebird/Interbase

Note: On Windows, the only supported database modules are SQLite and MSODBC.