# Easy Database Question

**URL:** <https://forum.inductiveautomation.com/t/easy-database-question/38793>\
**Category:** Ignition\
**Created:** [September 17, 2020, 12:57pm UTC](https://forum.inductiveautomation.com/t/easy-database-question/38793 "2020-09-17T12:57:35Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![CJVR](https://avatars.discourse-cdn.com/v4/letter/c/0ea827/32.png) [@CJVR](https://forum.inductiveautomation.com/u/CJVR)\
**Post date:** [September 17, 2020, 12:57pm UTC](https://forum.inductiveautomation.com/t/easy-database-question/38793/1 "2020-09-17T12:57:35Z")

</div>

MariaDB or MSSQL? Discuss…

---

<div class="post-metadata">

**Author:** ![brandon1](https://avatars.discourse-cdn.com/v4/letter/b/ea666f/32.png) [@brandon1](https://forum.inductiveautomation.com/u/brandon1)\
**Post date:** [September 17, 2020, 1:09pm UTC](https://forum.inductiveautomation.com/t/easy-database-question/38793/2 "2020-09-17T13:09:55Z")

</div>

One is free and works really well.

The other is expensive and works really well.

I think that pretty much sums it up.

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [September 17, 2020, 2:00pm UTC](https://forum.inductiveautomation.com/t/easy-database-question/38793/3 "2020-09-17T14:00:46Z")

</div>

One can run in either Windows or Linux.

The other one… not so much, despite the owner’s claims to the contrary,

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [September 17, 2020, 2:05pm UTC](https://forum.inductiveautomation.com/t/easy-database-question/38793/4 "2020-09-17T14:05:51Z")

</div>

Some side-by-side comparisons. I usually look at them with a grain of salt, but it’s a starting point

[https://db-engines.com/en/system/MariaDB%3BMicrosoft+SQL+Server%3BPostgreSQL](https://db-engines.com/en/system/MariaDB%3BMicrosoft+SQL+Server%3BPostgreSQL)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 17, 2020, 2:46pm UTC](https://forum.inductiveautomation.com/t/easy-database-question/38793/5 "2020-09-17T14:46:39Z")

</div>

Actually, I do run the non-free one in Linux without trouble. Some GUI features are missing.

As to the OP: Avoid MSSQL in any context where time zones matter, unless you can ensure that both the DB and all gateways that talk to it will be using UTC. And I don’t recommend either. Use PostgreSQL.

---

<div class="post-metadata">

**Author:** ![kgamble](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kgamble/32/8019_2.png) [@kgamble](https://forum.inductiveautomation.com/u/kgamble)\
**Post date:** [September 17, 2020, 3:30pm UTC](https://forum.inductiveautomation.com/t/easy-database-question/38793/6 "2020-09-17T15:30:07Z")

</div>

> [@pturmel](#):
>
> Use PostgreSQL.

Not one of the original two, but I second this.

---

<div class="post-metadata">

**Author:** ![PerryAJ](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/perryaj/32/3281_2.png) [@PerryAJ](https://forum.inductiveautomation.com/u/PerryAJ)\
**Post date:** [September 17, 2020, 5:17pm UTC](https://forum.inductiveautomation.com/t/easy-database-question/38793/7 "2020-09-17T17:17:34Z")

</div>

> [@kgamble](#):
>
> Not one of the original two, but I second this.

I haven't done any real SQL db deployments since, well, since joining IA, but I'll third this. Postgres has a great blend of features, performance, and 'sanity'. Would prob do a quick-pass on the big-dogs if I were looking to deploy a new production DB, but postgres would almost certainly come out on top.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 17, 2020, 5:29pm UTC](https://forum.inductiveautomation.com/t/easy-database-question/38793/8 "2020-09-17T17:29:10Z")

</div>

And you can get commercial support and extra features (clustering) from EnterpriseDB.