SQL and NoSQL Databases

Overview

Complete Suite of Embedded Web Development Tools

Barracuda Application Server
Server Components

Standalone Tools for Embedded Development

IoT Protocols

Quick Look

The Barracuda Embedded Web Server's database plugin consists of the free SQLite database engine and Lua bindings that make it very easy to create database driven applications in Lua. The database plugin is designed for high-level (POSIX) compliant operating systems such as QNX, VxWorks, (embedded) Linux, and Windows. It is possible to port SQLite to deep embedded systems. The SQLite database engine and the Lua bindings require an additional 650 Kbyte ROM.

Commercial Databases

We provide a plugin for ITTIA DB SQL Embedded -- data management optimized to deliver industry-leading performance across a wide range of platforms.

MySQL Microcontroller Example

The MySQL driver can be used by Xedge-powered microcontrollers. Learn how to integrate a microcontroller with MySQL in the cloud to create a real-time weather data visualization platform. This guide walks you through setting up a robust IoT solution, capturing sensor data, and connecting it to a MySQL database for analysis and display. Perfect for developers looking to combine embedded systems with cloud-based data management for insightful and interactive applications.

Note: An alternative to using a database for storing persistent data is to use our JSON encoder and decoder that is integrated with the server.

MySQL and Redis Database Plugin

We provide drivers for MySQL and Redis. The drivers are based on BSD-licensed open-source drivers from the OpenResty platform. We provide an OpenResty compatibility layer that allows the MySQL and Redis drivers to be used with the Barracuda App Server. The following diagram illustrates how the components work together.

The connections between the drivers and the databases use standard socket connections. This means that MySQL and Redis drivers can also be used in deep-embedded devices as long as the MySQL and/or Redis Databases run on a standard computer accessible from the device via the network.

The MySQL and Redis Database Plugin are available for the Barracuda App Server and the Mako Server (a Barracuda App Server derivative product). The Mako Server and the database plugin can be downloaded and run on your own computer, thus enabling immediate testing of the database plugin. See the Mako Server MySQL and Redis Database Plugin Tutorial for details.

Next: Embedded Embedded Web Server