[jira] [Created] (MINIFICPP-434) Create ExecuteSQL (lite) implementation

["Andrew Christianson (JIRA)" <ji...@apache.org>]

Andrew Christianson created MINIFICPP-434:
---------------------------------------------

             Summary: Create ExecuteSQL (lite) implementation
                 Key: MINIFICPP-434
                 URL: https://issues.apache.org/jira/browse/MINIFICPP-434
             Project: NiFi MiNiFi C++
          Issue Type: Improvement
            Reporter: Andrew Christianson
            Assignee: Andrew Christianson


SQLite is a lightweight, embedded DB. Including SQLite in MiNiFi - C++ will enable many flow configurations not possible before because it will allow keeping lightweight, structured, query-able state on endpoint devices.

Embedded IoT use is recommended by the SQLite project:

"Embedded devices and the internet of things
Because an SQLite database requires no administration, it works well in 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".

Client/server database engines are designed to live inside a lovingly-attended datacenter at the core of the network. SQLite works there too, but SQLite also thrives at the edge of the network, fending for itself while providing fast and reliable data services to applications that would otherwise have dodgy connectivity."

https://www.sqlite.org/whentouse.html



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)