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 solutions. Mimer SQL supports the
ADO.NET database APIs and runs on all major operating systems including
Windows, UNIX, Linux, Mac OS X, Android, Windows Mobile and OpenVMS.
In addition various embedded platforms are available.
Tuning Parameters in Mimer SQL
One of the Mimer SQL characteristics is automatic self-tuning. This means that the number of tuning parameters in Mimer SQL is, intentionally, very
Legacy Databases with non ISO 8859-1 in CHAR Columns
The traditional way of storing character data is using arrays of bytes. This is what you get when you use the CHARACTER or CHARACTER VARYING
ActiveX Data Objects (ADO) is a language-neutral object that is the basis of Microsoft’s Universal Data Access strategy, which means that it is
Here's what is new on the site:
Updated Windows Guide for Mimer SQL
2015-07-07 -- The guide called Mimer SQL Getting Started on Windows is now updated for Mimer SQL version 10.1. This guide is located on our documentation page, among all other documentation concerning Mimer SQL. Enjoy!
Mimer SQL 10.1 for Mac OS X
2015-02-25 -- Mimer SQL 10.1 is now available for Mac OS X Yosemite in a Beta test version. It includes the new SQL compiler with a rich SQL language support and many new optimization techniques that makes it extremely fast and efficient. This compiler is used when selecting the Mimer SQL Experience database server, which is the default when creating a new system. Welcome to download Mimer SQL 10.1.3 for Mac OS X from our download page, and feel free to send us your feedback. See the article Using Mimer SQL with the Mac OS X Core Data Framework to get an example on how to work with Mimer SQL in the Apple's Xcode IDE.
Mimer SQL version 10.1.3 is now released
2014-10-02 -- New production versions for Windows, Linux and OpenVMS are now available. Besides some maintenance updates, this 10.1.3 version contains various new and upgraded features. An example is that deferred foreign key constraints now are supported, meaning that constraints are checked when the transaction is committed, rather then when the statement was executed. Other news are that the SQL support has been extended with additional referential actions such as ON UPDATE SET NULL, ON UPDATE SET DEFAULT, ON UPDATE RESTRICT and ON DELETE RESTRICT. The Mimer SQL Experience database server has new functionality and some outstanding performance optimizations. Among the new features, the support of the WITH and VALUES clauses can be mentioned. In addition, a new version of DbVisualizer is bundled with this Mimer SQL package. You are very welcome to download Mimer SQL 10.1.3 from our Downloads page. As always, it includes a free test and development license.
New article about Mac OSX Core Data and Mimer SQL
2014-04-03 -- Using the Mac OS X Core Data framework for application development is very powerful. The article Using Mimer SQL with the Mac OS X Core Data Framework describes how to do this by using a prepared example application. Some technical background information is given and then the example application is fired up. Finally the article describes how to create the application from scratch. Enjoy!