# MySQL or PostgreSQL?

**URL:** <https://forum.inductiveautomation.com/t/mysql-or-postgresql/64286>\
**Category:** Ignition\
**Created:** [September 20, 2022, 3:11pm UTC](https://forum.inductiveautomation.com/t/mysql-or-postgresql/64286 "2022-09-20T15:11:44Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [September 20, 2022, 3:11pm UTC](https://forum.inductiveautomation.com/t/mysql-or-postgresql/64286/1 "2022-09-20T15:11:44Z")

</div>

We’re upgrading our Ignition server hardware and moving the database onto a separate server. The subject of database engine has come up. Our supplier is suggesting that we migrate from MySQL (which I’m familiar with) to PostgreSQL (which I’ve never used).

What’s the word on the street? Good move or bad? Why?

---

<div class="post-metadata">

**Author:** ![dkhayes117](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/dkhayes117/32/68344_2.png) [@dkhayes117](https://forum.inductiveautomation.com/u/dkhayes117)\
**Post date:** [September 20, 2022, 3:36pm UTC](https://forum.inductiveautomation.com/t/mysql-or-postgresql/64286/2 "2022-09-20T15:36:29Z")

</div>

I haven’t used Postgres, but it is one of the more popular ones recommended on the forums. I use MariaDB, which is a guaranteed drop-in replacement for MySQL. I highly recommend MariaDB over MySQL since they were acquired by Oracle, that is if you do not choose Postgres.

@pturmel is a big supporter of Postgres I think, and will probably have some technical reasoning.

Old post, but a little more insight  
[Postgresql Vs MySQL - Ignition - Inductive Automation Forum](https://forum.inductiveautomation.com/t/postgresql-vs-mysql/15661/4)
