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 also possible to port SQLite to deep embedded systems, please enquire for further details. The SQLite database engine and the Lua bindings require an additional 650 kbyte ROM.
Real Time Logic provide a plugin for ITTIA DB SQL Embedded, a database which provides data management optimized to deliver industry-leading performance across a wide range of platforms.
There are many use cases for using an embeddable database. For example, Real Time Logic’s own website uses SQLite for storing the page content. The BarracudaDrive’s Content Management System plugin translates the URL’s to database queries and fetches the page content from a SQLite database. Fetching Lua Server Pages from a database is just one of many possible use case scenarios for the LSP plugin.
An alternative to using a database for storing persistent data is to use the JSON encoder and decoder that is integrated with the server.
MySQL and Redis Database Plugin
Real Time Logic provide drivers for MySQL and Redis. The drivers are based on BSD licensed open source drivers from the OpenResty platform. An OpenResty compatibility layer is provided that makes it possible to use the MySQL and Redis drivers with the Barracuda Application Server. The following diagram illustrates how the blocks 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 are running on a standard computer accessible from the device via the network.
About Real Time Logic
Real Time Logic is a world class IoT security and web-enablement specialist. Their solutions and Ecosystem Partners drive modern real-time embedded applications to ensure the smooth deployment and safe operation of next generation products. More details…
Find out more…
For more information on using a database with the Barracuda Application Server please complete the form below.