We are interested install ignition in our company, we were thinking install MSSQL2016 Standart, but there are others free alternatives. Can you recomend me which is the best free option of SQL Database to use? (MSSQL Express have to low performance).
This article might help, when you have to face the MySQL (or MariaDB) vs. PostgreSQL question. I think the licensing point is particularly important in the system integration world.
We use MariaDB and it has been pretty awesome for us so far. Especially if you are able to utilize TokuDB compression. Historian data is compressed substantially.
PostgreSQL is an absolute mastodon, I would recommend beginning with it.
SQLite is also a very good option, it’s extremely lightweight and easy-to-use.
Read this article to learn the pros and cons of other database solutions.