I'm new on Codesys. I need to manage a large and complex data set, which database and library you suggest to use?
Some application examples will be appriciated.
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
We have developed a similar application few years ago with .Net and MS Sql Server.
The database has about 30 tables, the more bigger tables have 2 or 3 thousands records.
We can have multiple threads accessing at the same time to the DB. To garantie the data integrity we
need to manage data locks and transactions.
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm new on Codesys. I need to manage a large and complex data set, which database and library you suggest to use?
Some application examples will be appriciated.
Thanks
How large and how complex? It's tough to make a recommendation without additional details. The simplest thing is to just use data arrays (or even arrays of arrays). Not knowing your requirements, it might be sufficient and the simplest option is often the best.
https://content.helpme-codesys.com/en/CODESYS%20Development%20System/_cds_datatype_array.html
You might also look into using Recipes?
https://forge.codesys.com/prj/codesys-example/recipe-manageme/home/Home/
Some more complex options below.
https://forge.codesys.com/prj/codesys-example/element-collect/home/Home/
https://store.codesys.com/en/mysql-library-sl.html
Last edit: trusty-squire 2025-03-04
We have developed a similar application few years ago with .Net and MS Sql Server.
The database has about 30 tables, the more bigger tables have 2 or 3 thousands records.
We can have multiple threads accessing at the same time to the DB. To garantie the data integrity we
need to manage data locks and transactions.
Thanks