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.
Character data, Unicode and Collations
While modeled on the ASCII character set, the Unicode Standard goes far beyond ASCIIís limited
Evaluate SQL Using Explain
How is a complex join evaluated? In which order are the tables accessed? Is that index really useful?
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:
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!
Mimer SQL 10.1 now released
2013-11-04 -- We are very pleased to announce that Mimer SQL 10.1 is now released for the Windows and Linux platforms. This milestone version includes a brand new SQL compiler as part of the new database server Mimer SQL Experience. It features a rich SQL language support and many new optimization techniques that makes it very fast and efficient. The new SQL compiler and the traditional one have been developed in parallel. They both use the same execution engine and database kernel, which means that databases created with one server type may be used with the other. In other words, it is possible to try applications with the new server simply by changing server type. Please see the article News in Mimer SQL version 10.1 for a news summary. Welcome to download Mimer SQL 10.1.1 from our download page. As always, it includes a free test and development license.
2013-11-01 -- There are now some documentation updates available. The main Mimer SQL Documentation Set is updated for 10.1, and there are also new versions of the guides for Windows and for Mimer JDBC. See our documentation page for the new docs.