Introduction

Mimer SQL has products both for 32-bit Linux systems and for 64-bit Linux systems.

From Mimer SQL version 10, Linux systems based the kernel version 3 or later are supported – as far as operating system revisions are backwards compatible. Please, see the section Supported Architecturesbelow for details on supported and unsupported platforms.

For features in Mimer SQL, see the article Mimer SQL overview as a starting point.

Description

Mimer SQL provides small footprint, scalable and robust relational database solutions that conform to international ISO SQL standards. It is very well suited for high performance mission critical systems as well as for mobile and embedded appliances. In addition, Mimer SQL is equipped with an extensive multilingual support using collations.

A Mimer SQL Engine distribution contains several components, as described below.

Default License

A default license for testing and development is included, it allows up to ten concurrent users. For license upgrades, please contact Mimer SQL sales.

Database Server

The Mimer SQL database server is a single, multi-threaded process with SMP scalability.

Clients using TCP/IP can access the server. For clients running on the same platform, a shared-memory based communication method is used.

Embedded SQL

An embedded SQL preprocessor is included. It enables SQL commands to be embedded in programs written in C, C++ and FORTRAN. The embedded syntax complies with the ISO standard for embedded SQL.

Module SQL

A Module SQL preprocessor is included. It enables separation of SQL code and a host application written in C, FORTRAN, COBOL or Pascal into different source files, simplifying modularity and reuse of SQL code.

JDBC Driver

A JDBC driver is included in the distribution. The driver is a type 4 driver, which means that it is written entirely in Java. This provides the driver with full portability so that it can be copied or downloaded to any Java enabled platform. The driver uses TCP/IP to access a Mimer SQL server (version 8.2 or later) on any platform. For details on the JDBC drivers, please refer to the Mimer JDBC Driver Guide found at our documentation page.

ODBC Driver

The Mimer ODBC driver is a client library that enables applications to access Mimer SQL database servers running on any platform. The driver complies with the ODBC 3.52 specification. In the Linux ODBC environment it may vary how SQLWCHAR is defined and used, i.e. if it refers to a two or four byte type. Mimer SQL on Linux supports a four byte SQLWCHAR in the libmimodbc shared library.

On Linux you can choose to use a third party ODBC Driver Manager that enables applications to dynamically load drivers for different database products. But, you can also choose to link your applications directly to the Mimer ODBC driver, without using any Driver Manager. In the latter case we suggest usage of the provided ODBC header files, introduced by including the mimcli.h file.

For a proper Unicode behavior, please note that internationalized programs must include the locale.h header file and call the setlocale() operating system function to initiate a specific language operation. This can be done by calling setlocale() as follows:

setlocale(LC_ALL, "");

Generally when executing an ODBC application, a platform specific Mimer ODBC driver has to be installed on the client side. This driver can then access Mimer database servers on any platform. There is no need to install any special software on the server side in order to use ODBC.

Mimer SQL C API

Mimer SQL C API is a native C library suitable for tool integration and application development in environments where API standardization is not a requirement. The following characteristics describe the API:

  • Simplicity
  • Platform independence
  • Small footprint
  • Tight fit with the Mimer SQL application/database communication model.

The so called “MimerAPI” is provided in the libmimerapi.so shared library and the mimerapi.h header file provides prototypes and other handy defines. See Database API article for MimerAPI and the Mimer SQL Programming Manual (found in the Mimer SQL Documentation Set at the Documentation page.

Documentation

If not using the headless distribution packages, the Mimer SQL product for Linux includes the Mimer SQL manuals in Adobe PDF format.

Online documentation can be found at the Mimer SQL documentation page.

Release Notes are always provided within the distribution packages in PDF format.

Utilities

The main utility used when administering and managing a Mimer SQL database is the DbVisualizer Java based tool, which is provided within the delivered product package (not with the headless product packages).

Mimer SQL also includes command-line utilities for creating databases, load and unload of data, backups, interactive SQL statement execution, etc.

In addition, the Mimer SQL distribution contains an example database, examples of database programs and SQL statements.

Products

Developer and evaluation versions of Mimer SQL for all platforms, including Linux and Linux ARM, are available for free download from the Mimer SQL download page.

Supported Architectures

The Linux ARM products are, as the name implies, aimed for processors providing the ARM architecture. Currently the Aarch64, or ARM64, 64-bit extension to the ARM architecture is supported as an official release.

The standard Linux product runs on processors built on the Instruction Set Architecture (ISA) called AMD64, or x86-64. Intel has also developed processors supporting the AMD64 architecture, they have named their variant Intel 64. This architecture is compatible with AMD64, and consequently, it is supported by Mimer SQL for Linux. AMD64 (x86-64) and Intel 64 shall not be mixed up with the IA-64 architecture (Itanium), developed by Intel. Itanium is incompatible, and thus, this version of Mimer SQL for Linux does not work on Itanium.

For further questions on architecture support and other platform configurations than mentioned, please be in contact.

Links

Download Mimer SQL for Linux from our download page.

Locate the Mimer SQL documentation at the documentation page.

For further details, please see our Howto and Feature articles. Or, contact Mimer SQL Support.

Graphic Element - Cube