World of Databases on eSOMiMX6 – A Comparative Study

A plethora of embedded devices is taking part in IoT. They have become responsible to capture, store and analyze data. Some data relayed from sensors may need to be stored on the device to improve privacy and reduce bandwidth requirements. Database technology lends its hand in coping up with the data growth and data integrity.

Relational Database Management System(RDBMS) is a database management system (DBMS) that stores data in the form of related tables.

This article guides you to install and configure various databases including MySQL, PostgreSQL, and SQLite3 for eSOMiMX6.

PostgreSQL

PostgreSQL is an advanced SQL database server, which is available on a wide range of platforms. It has an enviable reputation for performance, stability, and a wide range of advanced features, which have been developed over the course of more than 20 years. With that, PostgreSQL is one of the oldest open source projects in existence, completely free to use, and developed by a very diverse, worldwide community. And best of all, it just works!

Features Of PostgreSQL:

• Open source

• Less maintenance

• Low cost of ownership

SQLite3

SQLite is not directly comparable to client/server SQL database engines such as MySQL, Oracle, PostgreSQL, or SQL Server since SQLite is trying to solve a different problem.

Because an SQLite database requires no administration, it works well on devices that must operate without expert human support. SQLite is a good fit for use in cellphones, set-top boxes, televisions, game consoles, cameras, watches, kitchen appliances, thermostats, automobiles, machine tools, airplanes, remote sensors, drones, medical devices, and robots: the “internet of things”.

Features Of SQLite:

• Zero-configuration

• Serverless

• Stable Cross-Platform Database File

• Compact

MySQL

MySQL is the backbone of some of the most popular free software web applications, including WordPress, Drupal, and StatusNet. Its phenomenal ability to scale is unmatched — being the optimal choice for anything ranging from a personal blog to an international eCommerce site.

Features Of MySQL:

• Low-cost

• Cross-Platform flexibility

• High performance, reliability, and scalability

• Ease-of-use

• Zero-administration

Please visit our developer website to get step by step instructions to build and configure the databases and also run the sample application for each of the above-mentioned databases on our eSOMiMX6 board.

For further assistance and queries get in touch with sales@e-consystems.com

To try eSOM++ databases on eSOMiMX6 device, please download: