Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
en:sw:01-mervis:08-sscp-bridge [2021/08/06 12:50]
avsetula
en:sw:01-mervis:08-sscp-bridge [2024/04/18 10:41] (current)
avsetula
Line 1: Line 1:
-====== SSCP to SQL Bridge ====== +====== SSCP to MySQL Bridge ====== 
-This daemon-based service allows bi-directional data transfer between an Unipi unit running Mervis and a SQL database through an SSCP protocol (the proprietary protocol used by Mervis). ​ The daemon can run on any Linux machine (database server or another remote machine) or directly on the unit.+This daemon-based service allows bi-directional data transfer between an Unipi unit running Mervis and a MySQL database through an SSCP protocol (the proprietary protocol used by Mervis). ​ The daemon can run on any Linux machine (database server or another remote machine) or directly on the unit.
  
 {{ :​en:​sw:​01-mervis:​sscp-sql-bridge.png?​direct |}} {{ :​en:​sw:​01-mervis:​sscp-sql-bridge.png?​direct |}}
Line 23: Line 23:
   - **UPDATE** -  This action will update a row in the specified table with the variable values in the unit. The row can be specified using the "​where"​ parameter, which will be directly used as a "​WHERE"​ clause in the SQL query. (Set DB row according to the Mervis variable)   - **UPDATE** -  This action will update a row in the specified table with the variable values in the unit. The row can be specified using the "​where"​ parameter, which will be directly used as a "​WHERE"​ clause in the SQL query. (Set DB row according to the Mervis variable)
   - **INSERT** -  This action will insert a row with current unit values into the specified table each time the variable state is read from the unit. (Log Mervis variable to the DB)   - **INSERT** -  This action will insert a row with current unit values into the specified table each time the variable state is read from the unit. (Log Mervis variable to the DB)
 +
 +<WRAP center round tip 90%>
 +Currently it is not supported to send long data types (LREAL, LINT, ULINT, etc.), or STRING and DT.
 +</​WRAP>​
 +
  
 ===== Supported platforms ===== ===== Supported platforms =====