Thanks Rex. I had a misunderstanding then, thinking there was a Redis or Mongo db with Launcher.
Both MySQL and PostGreSQL would require their own db server install on the local server running Launcher, which is something I don't think would be allowed in our managed environment. I was hoping having it embedded in the runtime engine would give us an "in" to getting a fast local db.
I'll have to look into other options on how to do this.
------------------------------
Jim Davee
------------------------------
Original Message:
Sent: Tue April 04, 2023 02:47 PM
From: Rex Chan
Subject: Launcher local db engine?
ITX doesn't ship any database including Redis in the Runtime component. In addition, the Redis is only used in the Rest Container for running Fenced mode. Any information stored in Redis is not saved. Many open source relational databases come with their own driver. I have used MySQL and PostgreSQl lately with their JDBC driver. You don't need to run ITX Launcher in container mode to take advantage of it.
------------------------------
Rex Chan
Original Message:
Sent: Tue April 04, 2023 01:53 PM
From: Jim Davee
Subject: Launcher local db engine?
Our environment uses lots of text-based lookup files and many, many maps that read them concurrently. We would like to make a design change and instead use a db. The tables are updated every week or two so our thought is to use a local db specific to the Launcher instance. When Launcher starts up it will load the db from the text files, and if the text files are updated a watch event will reload the db.
We have an enterprise Oracle environment but we don't own or manage it, it is not local to Launcher, and it is overkill for these lookup files. I'd like a small, fast, local db, maybe even a memory-only based db that multiple maps in the Launcher engine can access concurrently.
What I'm also really after is a native adapter local db, not a generic ODBC or JDBC.
Is there anything in the 10.1.2 release that is a true local db server? I remember reading something about a Redis server and cache variables that implied the cache variables are maintained in a Redis instance while Launcher is running. If that concept is correct then Redis must be part of the 10.1.2 release.
Given all those ideas and preferences, I'm open to any suggestions on speeding up the use of these lookup text files.
Thanks!
Jim
------------------------------
Jim Davee
------------------------------