SAMPLE APPLICATIONS

TODO

A web application that introduces you to the power, performance and simplicity of MariaDB through simple CREATE-READ-UPDATE-DELETE (CRUD) operations.

Orders

A web application that introduces you to the power, performance and simplicity of MariaDB by simulating online e-commerce (ordering) traffic.

Flights

A web application, backed by the power of MariaDB connectors and MariaDB ColumnStore database, that allows you to analyze over 180 million flight records from the United States Department of Transportation in real time without needing to add any indexes!

Bookings

A web application, backed by the power of MariaDB, that unleashes the power of smart transactions on hundreds of millions of records with sub-second query performance without having to add any indexes!

Places

A web application backed by the power of the power, performance and simplicity of MariaDB, allows you to record all of your favorite locations!

MariaDB + PL/SQL

A respository containing code samples for getting started using PL/SQL with MariaDB.

Includes samples for the following:

  • Conditional statements
  • Loops / Cursors
  • Stored Procedures
  • Functions
  • Packages
  • Triggers
  • Exception Handling
  • And more!

MariaDB + JSON

A respository containing code samples for getting started using JSON with MariaDB.

Includes samples for the following:

  • Storing JSON documents in MariaDB
  • Reading and writing data into JSON documents
  • Creating performance enhancing indexes for JSON data
  • Enforcing data integrity on JSON data
  • And more!

Modern SQL Samples and Apache Zeppelin

MariaDB implements more of the standard SQL specification than any other open source database, adding support for common table expressions (CTEs), window functions, temporal data tables and many other features over the last few years.

MariaDB ColumnStore Quick Start

MariaDB ColumnStore is a columnar storage engine that utilizes a massively parallel distributed data architecture. ColumnStore is designed for big data scaling to process petabytes of data, linear scalability and exceptional performance with real-time response to analytical queries.

Introduction to MariaDB and Object-Relational Mapping

Introductory samples and walk-throughs for using Object-Relational Mapping (ORM) libraries with MariaDB connectors.

ORM Library Samples:

Getting Started with SkySQL and HTAP

MariaDB SkySQL is the best database-as-a-service (DBaaS) available today. It’s the first DBaaS to support OLTP, OLAP and hybrid workloads, storing data both in row format on persistent block storage and columnar format on object storage. This sample will get you up and running with a MariaDB SkySQL Hybrid Transactional/Analytical Processing (HTAP) database instance in less than 15 minutes.

Getting Started with Community Server 10.5 and HTAP

MariaDB Community Server 10.5 has many enhancements that will provide an improved user experience with faster performance and improved manageability. This example walks through the process of downloading, installing and configuring MariaDB Community Server (HTAP) using a Docker image.

MariaDB Connector/Python Samples

A respository containing sample applications and usages that will help you gain an understanding of how to take advantage of MariaDB Connector/Python.

  • Simple API application: A Python application that uses Flask to expose endpoints that can be used to perform simple CRUD operations with MariaDB Connector/Python.
  • Data Visualization: Using MariaDB Connector/Python, the libraries Plotly and Pandas are used to demonstrate data analysis and visualization.