Mimer Developer

Category: Product

Mimer SQL 11.0.8: A Powerhouse of Performance, Scalability, and Versatility
In a milestone release, Mimer introduces Mimer SQL 11.0.8, reaffirming its status as a leading relational database management system (RDBMS). Beyond its exceptional features, outstanding performance, and platform diversity, Mimer SQL 11.0.8 stands out as an optimal choice for low-resource environments, including embedded systems and IoT applications, thanks to its maintenance-free operation and resource-conserving capabilities.

Key Highlights of Mimer SQL 11.0.8:
1. Performance Superiority: Demonstrates unmatched performance, making it an ideal choice for both data-intensive applications and environments with limited resources.
2. Multi-File Capability: Enables seamless scalability, even in low-resource environments, offering a future-proof solution for businesses anticipating substantial growth.
3. Strong Commitment to the SQL Standard: Positioned as an unofficial reference implementation, ensuring precision, functionality, and compatibility even in resource-constrained settings.
4. Multilingual Support: Breaks linguistic barriers with support for over 100 languages, ensuring a diverse and accessible user experience in low-resource environments.
5. Broad Platform Support: Extensive compatibility across major processor architectures and operating systems, making it an optimal choice for embedded systems and IoT applications.
6. Optimized for Low-Resource Environments: Maintenance-free operation and resource-conserving capabilities make Mimer SQL 11.0.8 an excellent choice for scenarios with limited resources.
Outperforming the Competition: A Class of Its Own

While specifics of benchmark tests like TPC-H or TPC-C can’t be explicitly mentioned due to licensing concerns, Mimer SQL 11.0.8 has undergone exhaustive performance evaluations, consistently outshining its competitors. The database management system excels in handling demanding workloads, making it an ideal choice for both data-intensive applications and environments with limited resources.

Multi-File Capability: Redefining Scalability

A standout feature of Mimer SQL 11.0.8 is its unparalleled multi-file capability, providing seamless scalability for databases. As businesses continue to experience exponential growth in data volume, the ability to handle large datasets efficiently becomes paramount. Mimer SQL’s multi-file capability addresses this need, providing users with a scalable and adaptable solution that aligns with the evolving requirements of modern applications.

The same is valid in embedded applications, for instance in appliances and devices, where Mimer SQL’s ability to handle large datasets ensures adaptability and expandability. Just by adding physical media is it possible to adapt to ever growing dataset, in some cases even without recertification. This positions Mimer SQL as an optimal solution for businesses anticipating substantial growth even in constrained settings.

Strong Commitment to the SQL Standard: Unrivaled Precision and Compatibility

Mimer SQL has long been recognized as an unofficial reference implementation for the SQL standard, and version 11.0.8 further reinforces this commitment. Adhering rigorously to the SQL standard ensures users benefit from precise syntax, robust functionality, and optimal compatibility across different systems, even in environments where resources are limited.

Multilingual Support: Breaking Barriers with Over 100 Languages

In addition to its technical prowess and SQL standard commitment, Mimer SQL 11.0.8 breaks linguistic barriers with support for over 100 languages. This inclusive approach ensures users worldwide can leverage the power of Mimer SQL in their preferred language, fostering a diverse and accessible user experience.

Broad Platform Support: Enabling Flexibility Across Architectures and Operating Systems

One of the standout features of Mimer SQL 11.0.8 is its comprehensive platform support. Mimer SQL extends its reach across all major processor architectures, including ARM, Apple Silicon, x86, and RISC-V. Moreover, it seamlessly integrates with all major operating systems, including Windows, OpenVMS, macOS, Linux, QNX, and GreenHills INTEGRITY.

This broad platform support underscores Mimer SQL’s commitment to providing users with unparalleled flexibility in choosing their preferred hardware and operating environment, and making it an ideal choice for enterprise, embedded systems, and IoT applications with varying hardware constraints alike.

Optimized for Low-Resource Environments: Maintenance-Free Operation and Resource Conservation

Mimer SQL 11.0.8 shines in low-resource environments, such as embedded systems and IoT applications, thanks to its maintenance-free operation and resource-conserving capabilities. Its efficiency in utilizing resources makes it a standout choice for scenarios where minimizing footprint and maximizing performance are critical factors.

Mimer SQL 11.0.8 sets new standards in technical innovation, adherence to industry standards, and adaptability in low-resource environments. With exceptional performance, scalability features, SQL standard commitment, multilingual support, and a focus on efficiency, Mimer SQL continues to be the database solution of choice for businesses worldwide, including those operating in embedded systems and IoT applications.
2024-01-04
Mimer SQL Joins Qt 6.6

Enhancing Database Connectivity

In a groundbreaking development for the Qt development community, the highly anticipated Qt version 6.6 is set to arrive with an exciting addition to its Qt Sql Module: the integration of the Mimer SQL plugin. This strategic inclusion is set to revolutionize database connectivity and streamline data management for Qt developers worldwide.

The Mimer SQL plugin’s integration into Qt 6.6’s official package opens up a plethora of opportunities for developers seeking robust and reliable database solutions. With this new plugin, Qt users gain enhanced compatibility and connectivity options when working with databases, further bolstering Qt’s reputation as a versatile and powerful framework.

The Mimer SQL plugin is set to deliver a range of benefits to Qt developers:

1. Expanded Database Compatibility: The Mimer SQL plugin’s integration means that developers can now work seamlessly with Mimer SQL databases, ensuring greater compatibility and ease of use.

2. High-Performance Connectivity: This plugin offers optimized database connectivity, potentially resulting in improved query execution times and overall application performance.

3. Enhanced Security: Mimer SQL is known for its strong emphasis on security. By utilizing the Mimer SQL plugin, Qt developers can avail themselves of these security features and ensure robust protection for their applications’ data.

4. Simplified Data Management: The plugin streamlines the process of integrating databases into Qt applications, making it easier for developers to manage, query, and manipulate data efficiently.

5. Comprehensive Documentation: Qt 6.6 provides detailed documentation on how to utilize the Mimer SQL plugin effectively, ensuring that developers can easily integrate it into their projects and capitalize on its features.

The official announcement for this integration can be found in the Qt 6.6 documentation’s “What’s New” section, https://doc-snapshots.qt.io/qt6-6.6/whatsnew66.html#qt-sql-module.

Qt developers and enthusiasts are encouraged to explore this new addition and take advantage of the enhanced database connectivity that the Mimer SQL plugin offers. As the Qt framework continues to evolve, such advancements underscore its commitment to providing cutting-edge tools and technologies for developers across various industries.

With the Mimer SQL plugin now a part of the Qt 6.6 package, developers can look forward to a smoother, more efficient, and secure database integration experience, marking yet another milestone in the Qt framework’s journey of innovation.

2023-08-28
Support For OpenVMS On x86 Architecture

Mimer SQL 11 on OpenVMS V9.2 — The first relational database support for OpenVMS on x86 architecture

Mimer SQL, the high-performance SQL database management system, is proud to announce the support for the OpenVMS V9.2 operating system running on the x86 architecture. With this latest development, Mimer SQL expands its capabilities to a new platform, bringing the benefits of its cutting-edge technology to even more users around the globe.

This new development is a significant milestone for Mimer Information Technology, as it marks the first time a relational database has been ported to OpenVMS™ on the x86 architecture.

Mimer SQL’s new support for OpenVMS on x86 architecture is just one of the outstanding features of the product. Mimer SQL is a robust, high-performance SQL database management system designed for applications that require maximum reliability, security, and scalability. It is a product that has been trusted by businesses and organizations around the world for over 40 years.

Mimer SQL is designed for binary compatibility and Mimer SQL for OpenVMS V9.2 is no exemption where servers running on OpenVMS, Microsoft Windows, Linux, macOS®, INTEGRITY® or QNX® are functionally equivalent and all are part of the same solution – all Mimer SQL databanks are freely movable between related architectures and all clients can connect to all members of the family.

“We are thrilled to be the first database company in the world to support OpenVMS on x86 architecture with Mimer SQL,” said Magnus Hedencrona, CEO of Mimer Information Technology AB. “We take pride in our innovative spirit and our ability to deliver world-class technology that meets the needs of our customers. With this latest development, we are extending the reach of our product to even more users around the world.”

Mimer SQL can also seamlessly replace the RDB database on OpenVMS, offering users a reliable and efficient alternative. Mimer SQL’s high-performance capabilities make it an excellent choice for applications that require maximum uptime and performance.

To learn more about Mimer SQL and its support for OpenVMS on x86 architecture, please visit https://mimer.com. To download the latest version of Mimer SQL for OpenVMS, visit https://developer.mimer.com/products/downloads/mimer-sql-for-openvms/.

For media inquiries, please contact:
Mimer Information Technology AB Email: info@mimer.com Phone: +46 18 780 92 00

Windows is a trademark of the Microsoft Corporation
macOS is a trademark of Apple Inc.
INTEGRITY is a trademark of Green Hills Software Llc
QNX is a trademark of BlackBerry Limited

2023-04-06
Trustonic and Mimer unveil release of Mimer Trust 2.0

Mimer Information Technology and leading cybersecurity technology firm, Trustonic, have today unveiled the release of Mimer Trust 2.0: an enhanced version of the original Mimer Trust Product.

Mimer Trust was released in March 2022 and today are Mimer and Trustonic proud to announce the next generation, Mimer Trust 2.0, with additional security capabilities and optimized performance.

Please see the Trustonic press release (https://www.trustonic.com/news/trustonic-and-mimer-release-mimer-trust-2-0/) for the full story.

2022-11-28
Mimer SQL available as a beta release on OpenVMS

The latest version of Mimer SQL is now available as a beta release on OpenVMS

Mimer is proud to present our latest version of Mimer SQL for the OpenVMS operating system, the logical next step for a company like Mimer with roots firmly set in the enterprise. This beta marks the first step towards a release of what is the result of more than five years of development and will bring the world’s most modern database to what is possibly the world’s most stable operating system.

Mimer SQL is the natural choice for enterprises that want to have the flexibility to move their database infrastructure seamlessly between the data center and the cloud, to desktops and devices, all thanks to the agile architecture that underpins Mimer SQL. More than thirty years of know-how combined with a modern and state-of-the-art codebase, lays the prefect foundation for reliability, scalability and flexibility.

As a pure 64-bit solution, the sky is the limit when it comes to storage capabilities. Only the hardware sets the boundaries with a database such as Mimer SQL – 4 Exabyte covers every conceivable database design in the foreseeable future, and a staggering maximum of 327 Terabyte cache size makes any modern datacenter no match for Mimer SQL.

This release not only brings the latest features of the world’s most modern database to possibly the world’s most stable operating system, but is also the start of something new. Mimer is closely watching VMS Software, Inc., and their effort to bring OpenVMS to the x86 architectureand will, as previously announced, bring Mimer SQL version 11 to that platform as well.

Visit the download-page on our developer website.

2021-07-08
Database Scalability On a New Level
What if a database was really dynamic?
- What if a database could be dynamically shifted between disks and storage, without downtime and without special solutions?
- What if this was done all in the background and that load was automatically balanced between storage containers?
- What if these containers could be allocated and deallocated at will, to provide a means to move a complete database, regardless of size, seamlessly and dynamically between physical storage solutions?
- What if there was a way to increase I/O performance of the underlying physical storage to help the database realise its full potential?
Mimer SQL version 11.0.5

With the latest version of Mimer SQL 11, the world’s most advanced database server management system (DBMS), these questions are no longer a dream, it is reality. Mimer Information Technology, a leader in database technology, has once again pushed the limits for safe and scalable solutions, and dynamic storage is the name of the game.

Mimer SQL is a 64-bit DBMS which means that the limit of the database cache is 327 Terabytes, a limit that in reality means that there are virtually no limits when it comes to the size. There is no hardware that can match this and this is the problem. Mimer SQL needs a storage solution that can grow, a storage solution that can scale and, which is the most important feature, a storage solution that can support the high I/O demands a high-speed DBMS requires.

Our new ground-breaking capability MultiFile gives Mimer SQL the ability to extend an existing database container, the databank, from one datafile to many. When a new datafile is added to the databank, all existing data in that databank is migrated and balanced between all assigned datafile in real time. This ability, to be able to allocate storage dynamically, is totally transparent to the user, the application and the operating system. All the heavy lifting is done within Mimer SQL, with no system degradation, no penalties and no hassle.

Overcome limits to provide no limits

By offering MultiFile, Mimer SQL opens a vast array of possibilities, and for example. there is a way to dynamically extend storage when running out of disk space.

Add a datafile to the databank on a new disk and data will pour from one file to the other until it is evenly distributed. The datafile on the original drive has with this shrunk in size and so freed up disk space, and all this without downtime.

There is now a way to move a databank from one storage to another in order. Add an extension to one or many new drives and at the same time release the original. Once the data transfer is done is data on the new extensions and the original file is simply removed, being empty.

Assign the new physical layout with Mimer SQL and just wait for the data migration to take place and, once done, all datafiles scheduled for deletion disappears automatically. All available datafiles are then load balanced in the way you can expect from only Mimer SQL.

And this is the pearl: splitting the databank over several physical disks provides a way to alleviate the performance penalty of physical storage. Splitting the databank means splitting the load and the result is a way for storage to finally have a chance to match the I/O performance of Mimer SQL.

The Mimer SQL promise

Our promise of a perfectly balanced system with zero maintenance is one of our defining characteristics and it has just been extended to the next level. It is finally possible to shift everything in a live database in a high availability environment with no risk and no problem, only possibilities.

Safe, secure and scalable storage. World class innovation. Unsurpassed performance.

Mimer SQL – expect no less.
2021-03-31
Mimer SQL version 11.0.5 for 64-bit Linux

Just recently version 11.0.5 of the Mimer SQL was released for Linux and Linux ARM, and Windows is just around the corner. This version takes additional steps in achieving superb scalability and performance.

See all the new packages at our developer-download page, or read more about what’s new in Mimer SQL 11

Do not hesitate to contact us if you have any questions,

The Mimer Team

2021-03-05
Mimer SQL Data Provider 11.0.2A

The Mimer SQL Data Provider allows .NET clients to access Mimer SQL Database servers. The newly released version 11.0.2A of Mimer SQL Data Provider supports the new .NET 5 platform as well as .NET Core and .NET Framework.

Version 11.0.2A comes with encrypted communication support. Keep your information safe using encrypted communication between .NET clients and the Mimer SQL 11.0 database server. This is available for .NET Core and .NET 5 clients.

Version 11.0.2A also includes Mimer SQL Monitor, a graphical utility to interactively view the cost of SQL statements executed by the Mimer SQL Database server.

The newest version of Mimer SQL Data Provider is available for download at our download page and nuget.org.

The updated documentation with release notes can be found here: Mimer SQL Data Provider documentation

2020-12-23
Mimer SQL 11 available now!
We can now proudly present Mimer SQL 11 as a released product!

The new major version of Mimer SQL is the result of more than five years development with focus on performance and scalability. The result is dramatically improved performance in the database kernel, in the SQL compiler and the optimizer, performance in the integration with the host operating system and performance in the client communication, just to mention a few.

Mimer SQL is a true 64-bit solution for databases, fully supporting the SQL standard, and built on very modern and flexible codebase, and among the many new features in Mimer SQL the following stands out:
- Full support for SQL-2016 core as well as 137 extended features.
- Support for 327 Terabyte cache and/or in-memory server
- 4 Exabyte is maximum size of each databank file
- Out of the box cloud support with Docker and Kubernetes integrations
- Extended security features with state-of-the-art network encryption
Read the full release note here: What is Mimer SQL 11

Download the Linux version here: Mimer Developer Downloads

Mimer Version 11 for Windows, VMS and other operating systems will be released within short.
2020-12-01
Mimer API – Powerful, yet easy-to-use

Let’s talk about Mimer API. It is a C language database interface offered with Mimer SQL to provide a close interaction with the database server.

Although the API is available on all Mimer SQL platforms, the primary target is embedded programming where processing and memory resources are scarce. The API include Mimer specific intermediate layers between programming languages and the Mimer SQL server, smartphone database layers, and real-time systems.

The Mimer API may execute any database statement supported by the server. This includes the common SELECT, UPDATE, INSERT and DELETE but also DDL statements such as CREATE and DROP TABLE, recursive WITH, as well as procedure calls. Predefined statements may also be used. The Mimer API supports most features available on the server being used, such as scrollable cursors, large objects, national character data types, transactions, and stored procedures. It also has a subset for even more constrained devices. The Mimer Micro API lacks support for things such as error texts, and querying SQL statement meta data. The real time components the Mimer API allow the application to perform certain database operations with real-time characteristics, that is with an in advance known maximum guaranteed execution time. This is required in a real time environment to allow the system to guarantee the software always meet hard deadlines. Since the Mimer API is a C based API, any development tool based on C or C++ may be used with the API. Although possible, Java or .Net are not recommended. To develop using Java or .Net, please use the Mimer SQL JDBC driver or .Net Data provider.

Want to know more? Contact us here!

2019-07-05