We provide a plugin for ITTIA DB SQL Embedded -- data management optimized to deliver industry-leading performance across a wide range of platforms.
There are many use cases for using en embeddable database. For example, this web site is using SQLite for storing the page content. Our 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.
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.
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 makes it possible to use the MySQL and Redis drivers with the Barracuda App 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.
The MySQL and Redis Database Plugin is 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.