<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en" xmlns="http://www.w3.org/2005/Atom"><title>Recent posts to Which database to use?</title><link href="https://forge.codesys.com/forge/talk/Engineering/thread/c6be83c3f3/" rel="alternate"/><link href="https://forge.codesys.com/forge/talk/Engineering/thread/c6be83c3f3/feed.atom" rel="self"/><id>https://forge.codesys.com/forge/talk/Engineering/thread/c6be83c3f3/</id><updated>2025-03-04T15:52:58.719000Z</updated><subtitle>Recent posts to Which database to use?</subtitle><entry><title>Which database to use?</title><link href="https://forge.codesys.com/forge/talk/Engineering/thread/c6be83c3f3/?limit=25#8692" rel="alternate"/><published>2025-03-04T15:52:58.719000Z</published><updated>2025-03-04T15:52:58.719000Z</updated><author><name>domebruce</name><uri>https://forge.codesys.com/u/domebruce/</uri></author><id>https://forge.codesys.coma4cfe4282dd8e801cbefefe1fdf9caf81fecf888</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;We have developed a similar application few years ago with .Net and MS Sql Server.&lt;br/&gt;
The database has about 30 tables, the more bigger tables have 2 or 3 thousands records.&lt;br/&gt;
We can have multiple threads accessing at the same time to the DB. To garantie the data integrity we&lt;br/&gt;
need to manage data locks and transactions.&lt;/p&gt;
&lt;p&gt;Thanks&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Which database to use?</title><link href="https://forge.codesys.com/forge/talk/Engineering/thread/c6be83c3f3/?limit=25#f486" rel="alternate"/><published>2025-03-04T14:03:37.193000Z</published><updated>2025-03-04T14:03:37.193000Z</updated><author><name>trusty-squire</name><uri>https://forge.codesys.com/u/trusty-squire/</uri></author><id>https://forge.codesys.com973fde9d906915030a3303105993930971aca484</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;How large and how complex? It's tough to make a recommendation without additional details. The simplest thing is to just use data arrays (ie. array of array). Not knowing your requirements, it might be sufficient and the simplest option is often the best.&lt;br/&gt;
&lt;a href="https://content.helpme-codesys.com/en/CODESYS%20Development%20System/_cds_datatype_array.html" rel="nofollow"&gt;https://content.helpme-codesys.com/en/CODESYS%20Development%20System/_cds_datatype_array.html&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;You might also look into using Recipes?&lt;br/&gt;
&lt;a href="https://forge.codesys.com/prj/codesys-example/recipe-manageme/home/Home/"&gt;https://forge.codesys.com/prj/codesys-example/recipe-manageme/home/Home/&lt;/a&gt;&lt;/p&gt;
&lt;p&gt;Some more complex options below.&lt;br/&gt;
&lt;a href="https://forge.codesys.com/prj/codesys-example/element-collect/home/Home/"&gt;https://forge.codesys.com/prj/codesys-example/element-collect/home/Home/&lt;/a&gt;&lt;br/&gt;
&lt;a href="https://store.codesys.com/en/mysql-library-sl.html" rel="nofollow"&gt;https://store.codesys.com/en/mysql-library-sl.html&lt;/a&gt;&lt;/p&gt;&lt;/div&gt;</summary></entry><entry><title>Which database to use?</title><link href="https://forge.codesys.com/forge/talk/Engineering/thread/c6be83c3f3/?limit=25#4e52" rel="alternate"/><published>2025-03-04T04:57:11.743000Z</published><updated>2025-03-04T04:57:11.743000Z</updated><author><name>domebruce</name><uri>https://forge.codesys.com/u/domebruce/</uri></author><id>https://forge.codesys.comf8d749f59dca9918688aeb05a8258faf1f78220f</id><summary type="html">&lt;div class="markdown_content"&gt;&lt;p&gt;I'm new on Codesys. I need to manage a large and complex data set, which database and library you suggest to use?&lt;br/&gt;
Some application examples will be appriciated.&lt;br/&gt;
Thanks&lt;/p&gt;&lt;/div&gt;</summary></entry></feed>