{"id":2404,"date":"2018-02-13T21:10:34","date_gmt":"2018-02-13T15:40:34","guid":{"rendered":"http:\/\/localhost:8081\/system-on-module-som\/?p=2404"},"modified":"2023-08-15T12:33:13","modified_gmt":"2023-08-15T07:03:13","slug":"build-and-use-a-lightweight-database-on-esomimx6","status":"publish","type":"post","link":"https:\/\/www.e-consystems.com\/blog\/system-on-module-som\/build-and-use-a-lightweight-database-on-esomimx6\/","title":{"rendered":"Build and use a Lightweight Database on eSOMiMX6"},"content":{"rendered":"<p class=\"western\"><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\">Embedded systems often need to use a database to store contact information, EPG data and more. Many Linux systems use MySQL, however, such a large database management system may not always be appropriate for embedded systems. Since they are often taking part in M2M communication(IoT), they constantly capture, analyze and store data. Hence a compact database like SQLite is much needed.<\/span><\/span><\/p>\n<p class=\"western\"><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\">Hence, there is lightweight database management systems implementation that is especially suited to embedded systems by their binary footprint, memory footprint, and CPU requirements.<\/span><\/span><\/p>\n<p class=\"western\"><span style=\"color: #00000a\"><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\">This article guides you to build and use SQLite on <a href=\"https:\/\/www.e-consystems.com\/iMX6-micro-som-system-on-module.asp\">eSOMiMX6<\/a> devices.<\/span><\/span><\/span><\/p>\n<p class=\"western\"><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\">SQLite support SQL natively has a low memory footprint (190KB minimal \/ 325 KB full features) and is open source (GPL License). <\/span><\/span><\/p>\n<p class=\"western\"><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\"><u>Features:<\/u><\/span><\/span><\/p>\n<ul>\n<li>\n<p class=\"western\"><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\">A complete database can be stored in a single cross-platform disk file. <\/span><\/span><\/p>\n<\/li>\n<li>\n<p class=\"western\"><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\">Zero-configuration \u2013 no setup or administration needed.<\/span><\/span><\/p>\n<\/li>\n<li>\n<p class=\"western\"><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\">Simple, easy to use API.<\/span><\/span><\/p>\n<\/li>\n<li>\n<p class=\"western\"><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\">Self-contained: no external dependencies.<\/span><\/span><\/p>\n<\/li>\n<li>\n<p class=\"western\"><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\">Faster than popular client\/server database engines for most common operations.<\/span><\/span><\/p>\n<\/li>\n<li>\n<p class=\"western\"><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\">Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.<\/span><\/span><\/p>\n<\/li>\n<\/ul>\n<p class=\"western\" align=\"left\"><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\"><span lang=\"en-US\">Please visit our <\/span><\/span><\/span><span style=\"color: #000080\"><span lang=\"zxx\"><u><a href=\"https:\/\/www.e-consystems.com\/auth\/Account\/login\"><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\">developer website<\/span><\/span><\/a><\/u><\/span><\/span> <span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\"><span lang=\"en-US\">to get step by step instructions to build the SQLite database for <\/span><\/span><\/span><span style=\"color: #000080\"><span lang=\"zxx\"><u><a href=\"https:\/\/www.e-consystems.com\/iMX6-micro-som-system-on-module.asp\"><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\">eSOMiMX6<\/span><\/span><\/a><\/u><\/span><\/span><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\"><span lang=\"en-US\"> and work with the command line tool(sqlite) to create a database and the sample application for SQLite on our <\/span><\/span><\/span><span style=\"color: #000080\"><span lang=\"zxx\"><u><a href=\"https:\/\/www.e-consystems.com\/iMX6-micro-som-system-on-module.asp\"><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\">eSOMiMX6<\/span><\/span><\/a><\/u><\/span><\/span><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\"><span lang=\"en-US\"> board.<\/span><\/span><\/span><\/p>\n<p class=\"western\"><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\"><span lang=\"en-US\">For further assistance and queries get in touch with <\/span><\/span><\/span><span style=\"color: #000080\"><span lang=\"zxx\"><u><a href=\"mailto:sales@e-consystems.com\"><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\">sales@e-consystems.com<\/span><\/span><\/a><\/u><\/span><\/span><\/p>\n<p>To try eSOM++ SQLite on eSOMiMX6 device, please download:<\/p>\n<table width=\"552\" cellspacing=\"0\" cellpadding=\"2\">\n<colgroup>\n<col width=\"548\" \/> <\/colgroup>\n<tbody>\n<tr>\n<td bgcolor=\"#ffffff\" width=\"548\">\n<p class=\"western\" align=\"left\"><span style=\"color: #000080\"><span lang=\"zxx\"><u><a href=\"https:\/\/developer.e-consystems.com\/Downloads?key=69YkFkubX5ERK9%2BGNDi2Wlndb0XuB2N9ydmZsiKuPf0Un33KxfV4ZvSx%2BdOkb3e38NrMEYOQs8ewv3N8ZE8u7QEkqzjXLa%2FQpl7K%2F%2F0kK1DdI3cUuBvCNgW0PPjtDImk9rQael9o%2FsDK7J53Lq230AEi0SnkXytJaz8VMQcpGJtdZCqkzEpFE9bKiCqGa%2FfMlGmDEPaPGNGJa5XwuITK7djTGthZDS39YMqnnTrh%2BKbVqZOPpStQJPs54qS82iN3cTXAcZnhz%2FVjuC1Y8inkecwTNrFIC824UN%2FOUH938Dn87DEHFWbtXRT29C35f73Q\"><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\">Developer Tools Application Guide<\/span><\/span><\/a><\/u><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<tr>\n<td bgcolor=\"#ffffff\" width=\"548\">\n<p class=\"western\" align=\"left\"><span style=\"color: #000080\"><span lang=\"zxx\"><u><a href=\"https:\/\/developer.e-consystems.com\/Downloads?key=69YkFkubX5ERK9%2BGNDi2WhpR5KRKjXQ664awQpBgasqbU4EnbQjE6wrDOLPr%2FokoJ1hBhLDFGeCi341vOdu5iYdp5o6eDUc8Wxl6KX6XfDZoV8xF3XH2ZICNjITnrN1Qq%2FX03hwGGjAngpqDlMwORrfCJ9OPdU8x6ci8E9ee2XWiR4huhXw4R3Zpsp3OYpgPyGW96x6ygB8SAOTFsP6GkIO61yJTC1oC5AVWwzPRFhEMY87AgIZ2RGWzVYXs9Rb%2BEq3UGk2k7xbPlH89hu70ok91L9FVJr4Xa3boTu4rKEc%3D\"><span style=\"font-family: Ubuntu, serif\"><span style=\"font-size: large\">Developer Tools Installation Packages Containing SQLite Recipe File For Installation<\/span><\/span><\/a><\/u><\/span><\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>Embedded systems often need to use a database to store contact information, EPG data and&#8230;<\/p>\n","protected":false},"author":17,"featured_media":2456,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[213,342,343,340,341],"tags":[135,251,255,196,396,259,421,339,416,419],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.e-consystems.com\/blog\/system-on-module-som\/wp-json\/wp\/v2\/posts\/2404"}],"collection":[{"href":"https:\/\/www.e-consystems.com\/blog\/system-on-module-som\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.e-consystems.com\/blog\/system-on-module-som\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.e-consystems.com\/blog\/system-on-module-som\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.e-consystems.com\/blog\/system-on-module-som\/wp-json\/wp\/v2\/comments?post=2404"}],"version-history":[{"count":2,"href":"https:\/\/www.e-consystems.com\/blog\/system-on-module-som\/wp-json\/wp\/v2\/posts\/2404\/revisions"}],"predecessor-version":[{"id":2419,"href":"https:\/\/www.e-consystems.com\/blog\/system-on-module-som\/wp-json\/wp\/v2\/posts\/2404\/revisions\/2419"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.e-consystems.com\/blog\/system-on-module-som\/wp-json\/wp\/v2\/media\/2456"}],"wp:attachment":[{"href":"https:\/\/www.e-consystems.com\/blog\/system-on-module-som\/wp-json\/wp\/v2\/media?parent=2404"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.e-consystems.com\/blog\/system-on-module-som\/wp-json\/wp\/v2\/categories?post=2404"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.e-consystems.com\/blog\/system-on-module-som\/wp-json\/wp\/v2\/tags?post=2404"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}