We are looking to connect to a QuestDB instance that is set up on the same server as our gateway. Has anyone done this before that could offer any pointers?
You'll need to add the QuestDB JDBC driver when setting up the connection.
JDBC Drivers and Translators - Ignition User Manual 8.1 - Ignition Documentation (inductiveautomation.com)
Hi, I am also facing this issue. I have connected a questdb instance with Ignition. It shows a valid connection in database connection status page of the Gateway. However when selecting tags and enabling tag history to questdb. No data is logged.
I changed the database to a MS SQL instance it started instantly logging.
Any suggestions?
Since you're using Maker edition, I'm guessing this may not be immediately important, but Ignition 8.3 being released sometime early next year will natively use QuestDB as it's historian provider out of the box.
1 Like
Quest DB is not a relational database even though it supports a SQL like language. It is a timeseries database. Since Ignition's SQL historian requires (non timestamp) primary keys and foreign keys, I would not expect Quest DB to work well with it.
Quest DB's is designed for timeseries data and handles it very efficiently. However, because it is fundamentally a different technology, you have to redesign your DB tables to leverage its power. For example, its "primary key" equivalent would be the designated timestamp, it has a symbol datatype that could pretty much replace the sqlth_te table, it also has built it partitioning based on its designated timestamp column. You could essentially almost have a "single table" historian. Trying to use it as a relational database would mean to not leverage any of the design decisions that make it performant in the first place.
If you want to utilize Quest DB as a historian, I'd wait for 8.3's Power Historian.
1 Like
Look at this post below for more information why the current tag historian doesn't work with quest even though the postgres driver will connect to it.
Yes, this is something I have been testing for my own curiosity. Anyways, Ignition with questdb as OOTB sounds wonderful.
Agree. That is what I have been thinking. But thanks for providing the details.
Got it. Thanks for the info.