Discover SignalSQL, a robust signal database designed with the familiarity of a standard relational database. SignalSQL extends its functionality to effortlessly connect with diverse input and output signals, offering a reliable foundation for data management. Additionally, it incorporates various control algorithms to enhance its capabilities. Developers will appreciate the straightforward presentation of these functions as tables with comprehensive columns. Dive into SignalSQL documentation to gain insights into its structure and functionalities for seamless integration into your projects.
Standard MySQL protocol
SignalSQL adopts the protocol utilized by the MySQL/MariaDB series of databases. This compatibility extends SignalSQL’s versatility, allowing seamless integration with various application development environments and programming languages. If your software supports connections to a MySQL database, SignalSQL should seamlessly operate within the same framework, providing a convenient and familiar experience for users across different platforms.
Connection to signals
To establish a connection between SignalSQL and the physical world, an electrical interface is essential. This interface can take the form of GPIO pins, one-wire sensors, or similar mechanisms. SignalSQL simplifies this integration by supporting various interfaces through built-in modules. Additionally, users have the flexibility to expand functionality by incorporating custom modules through the module development kit. This modular approach ensures compatibility with diverse physical interfaces, offering adaptability to specific project requirements.
Closed Control Loop
For effective process control, the establishment of a closed control loop is typically essential. In this setup, input signals gauge the current state of the process. These signals are then fed into a control algorithm, such as the PID algorithm, and the resultant output is employed to manage and regulate the process. SignalSQL simplifies application implementation by offloading the closed control loop to the signal database. This streamlines the development process, making it more straightforward for applications to integrate and benefit from advanced control functionalities.
References
SignalSQL introduces a distinctive feature called references to efficiently route signals from physical input modules to application-defined algorithms. With references, a column in a table-row can be configured to reference the value from another table, employing syntax in the form of =Table/Row/Column. This powerful capability facilitates seamless integration and effective signal routing, allowing for a flexible and dynamic structure in managing data within the signal database.