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

Ignition
1

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.

1 Like
2

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 (6.6 KB)

1 Like