wago | small controller for WAGOs Linux

I have a table with a column 'TIMESTAMP' of data type VARCHAR:

I'm using WAGO PLC PFC200 in my home automation project. I've plenty of POUs, each for one room. Each room implements IRoom interface and uses base POU for common logic like turning off all lights. For lights management, I'm using

• FbEvaluateShortLongPress from WagoAppBuilding to handle short and long press of buttons on the wall (it could also be a function block from OSCAT library)
• FbLatchingRelay from WagoAppBuilding as a toggle for PLC digital output

I want to save the state of FbLatchingRelay in case of e.g.: power drop. I want all lights which were turned off before power drop to be turned on when the power comes back.

I've solved it by declaring a FbLatchingRelay in the VAR RETAIN PERSISTENT area in my POU. But then after reading here that:

If you declare a local variable in a function block as RETAIN, CODESYS stores the complete instance of this function block in the Retain range (all data of the function block); however, only the declared RETAIN variable is treated as such.

I decided to change that in order not to waste RETAIN memory for a bunch of variables which are in POU but are not needed to be stored as RETAIN.

So right now I have something like that:

• the VAR RETAIN PERSISTENT area is only declared in my main program
• it stores structures for each room (each POU) only with needed data - FbLatchingRelay POU and few other variables
• while initializing the room (POU) I'm passing those structures to my rooms using VAR_IN_OUT
• each room (POU) uses then this data

PLC_PRG:

Whats the best way to send data from a (WAGO) PLC to an (DynamoDB) cloud database?

Our situation:

We have WAGO PLC's(750-880, 750-882, 750-890) installed on site and we would like to send multiple data to an cloud database, preferabel an AWS DynamoDB. Whats the best approach how to achieve this? Is there an universal solution or a specific WAGO solution for this?

I am trying to exchange data between an PLC(WAGO 750-8101) and an Arduino(UNO) with PLC as master, and the Arduino as Slave, but cant seem to get a connection.

For the Arduino I have a MINI ENC28J60 as the networkmodule, and is connected to the arduino like this:

SCK - Pin 13, SO - Pin 12, SI - Pin 11, CS - Pin 10

VCC: 3.3V

For the arduino I am using these libraries:

EtherCard

Modbus-Arduino

Master Setup

I have a input structure like below,

Hey fellow programmers,

I'm working on my bachelor's project and got into a bit of a problem.

The goal is to create a web app, that can operate and modify I/O of a WAGO PLC 750-8202 (you can imagine it as some kind of industrial Raspberry PI) running an embedded linux with a lighttpd web server. I've made some C scripts that utilize DAL(HAL) functions the PLC provides.

Now I want to link it with my web application/site. I have a simple PHP page (ignore the button, it does nothing):