# Has anyone integrated CockroachDB to ignition? if yes, what is your feedback?

**URL:** <https://forum.inductiveautomation.com/t/has-anyone-integrated-cockroachdb-to-ignition-if-yes-what-is-your-feedback/86881>\
**Category:** Ignition\
**Created:** [March 6, 2024, 10:59am UTC](https://forum.inductiveautomation.com/t/has-anyone-integrated-cockroachdb-to-ignition-if-yes-what-is-your-feedback/86881 "2024-03-06T10:59:12Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![gopinath.ps](https://avatars.discourse-cdn.com/v4/letter/g/7ea924/32.png) [@gopinath.ps](https://forum.inductiveautomation.com/u/gopinath.ps)\
**Post date:** [March 6, 2024, 10:59am UTC](https://forum.inductiveautomation.com/t/has-anyone-integrated-cockroachdb-to-ignition-if-yes-what-is-your-feedback/86881/1 "2024-03-06T10:59:12Z")

</div>

Has anyone tried CockroachDB with the PostgresSQL via JDBC connection? Looking for a fastest open source db with HA native for our application.

Thanks in advance for your feedback.

---

<div class="post-metadata">

**Author:** ![jsorlie](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jsorlie/32/3645_2.png) [@jsorlie](https://forum.inductiveautomation.com/u/jsorlie)\
**Post date:** [April 4, 2024, 7:17pm UTC](https://forum.inductiveautomation.com/t/has-anyone-integrated-cockroachdb-to-ignition-if-yes-what-is-your-feedback/86881/2 "2024-04-04T19:17:07Z")

</div>

Here is the DDL I developed a few years ago when working with containerized deployment of both CockroachDB and Ignition. We were still using 7.9.x back then. The script may require some updates to reflect evolution of Inductive's three data models.

Be sure to disable Ignition's gateway-level partitioning of tag history. Cockroach supports TTL so such machinations for purging data are irrelevant.

[20200409 - CockroachDB - create ignition tables.sql](https://forum.inductiveautomation.com/uploads/short-url/6WL48kcwZEt6lp6Z7SBeYYU2GLR.sql) (6.6 KB)