Developer Hub
DOWNLOAD:
FOLLOW US ON:
GETTING STARTED WITH MARIADB
MariaDB sets the standard for open source relational databases, with Oracle Database compatibility (e.g., sequences and PL/SQL), temporal tables, transparent sharding, instant schema changes, point-in-time rollback and modern SQL (i.e., common table expressions (CTEs), window functions, JSON functions and more). MariaDB also includes storage solutions like ColumnStore, which can be used to work with massive amounts of data to provide real-time analytics at scale, and even a Distributed SQL solution, MariaDB Xpand.
RESOURCES BY LANGUAGE
JavaScript
JavaScript developers can connect to and communicate with MariaDB using the Node.js connector
Python
Python developers can connect to and communicate with MariaDB using the Python connector
MARIADB FEATURES AND FUNCTIONALITY
MariaDB SkySQL
MariaDB SkySQL is the first and only database-as-a-service (DBaaS) to bring the full power of MariaDB Enterprise to the cloud, including its support for transactional, analytical, hybrid (transactional + analytical) and distributed SQL workloads.
MariaDB MaxScale
MariaDB MaxScale is an advanced database proxy and a core component of MariaDB Enterprise – powering its enterprise high availability, scalability, security and integration services. Among other features, MariaDB MaxScale routes queries and load balances, and in SkySQL does so to distributed and replicated services.
Connectors
MariaDB Connectors are lightweight and advanced database connectors for high-performance data access by applications on macOS, Linux, Linux on ARM and Windows. MariaDB provides several native connectors that support languages like C, C++, Java, Python and more!
Modern SQL
MariaDB implements more of the standard SQL specification than any other open source database, adding support for PL/SQL, managing JSON data, common table expressions (CTEs), window functions, temporal tables and many other features over the last few years.
JSON
JavaScript Object Notation (JSON) is fast becoming the standard format for data interchange and for unstructured data. MariaDB includes a large variety of pre-defined functions that allow you to manage JSON data.
Temporal Tables
Temporal tables function as versioned tables that can be used to access and modify past data, and find what changes have been made and when. MariaDB supports temporal data tables in the form of system-versioning tables (allowing you to query and operate on historic data), application-time periods (allowing you to query and operate on a temporal range of data), and bitemporal tables (which combine both system-versioning and application-time periods).
Migration Data Upload
No migration should ever be undertaken lightly and there must be obvious benefits to justify the overhead. The benefits of migrating to MariaDB depend on the situation and/or environment you’re migrating from. When it comes to migration, MariaDB offers a variety of ways to quickly and easily get the job done.
MARIADB WORKLOADS
Transactional
MariaDB is the leading enterprise open source database, featuring Oracle Database compatibility (PL/SQL), sharding, temporal tables, dynamic data masking and point-in-time rollback. It leverages an innovative architecture based on pluggable, purpose-built storage engines, allowing different tables (or databases) with different workloads to use different storage engines for better query performance – each one optimized for a specific workload.
Analytical
MariaDB can be deployed as a columnar database for real-time analytics at scale, using distributed data and massively parallel processing (MPP) to perform interactive, ad hoc queries on hundreds of billions of rows with standard SQL. Further, MariaDB implements a cloud-native storage architecture, and can optionally use object storage services in public or private clouds to lower costs and store an unlimited amount of data.
HTAP
MariaDB supports Hybrid Transactional-Analytical Processing (HTAP) through its combination of MariaDB Enterprise Server, MariaDB can be deployed as a MariaDB ColumnStore and MariaDB MaxScale. MariaDB HTAP allows you to combine the power and reliability of row-based storage with scalability with the performance of column-based storage to create truly robust, innovative and truly modern applications.
Distributed SQL
MariaDB Xpand turns MariaDB Enterprise Server into a distributed SQL database with no limits, supporting applications and services with a billion users as easily as those with a thousand. There are no application changes necessary because it supports standard SQL and the MySQL protocol, and no need to give up transactions and strong consistency either.