Oh, users are more than welcome to roll their own way of doing tables. What you describe is perfect for a row-schemed table that contains everything in it. I meant that the initial data transfer would involve both the application and the DB.badsequel wrote: That sounds like a strange approach to me. So you are in essence querying the H2.INFORMATION_SCHEMA to look for tables that might hold KV pairs belonging to a Token?
SELECT table_name FROM INFORMATION_SCHEMA.TABLES
where table_name like 'someTokenIDfromTheJavaCode'
I assumed a KV table schema like this:
+-----------------+
|TokenId|Key|Value|
|100 |STR|18 |
+-----------------+
You do avoid some DB setup before use. No need to create/make sure tables exists that conform to a predefined/expected schema.
In detail, when a campaign loads, we'll spin through all tokens with properties, create a table in the DB using their UID, and insert all its key-values into the table. We'll then leave an accessible method of referencing these tables, either through a lib:token, or another table. After that a user can decide what he/she will do with the data. This way, a user can deal with one table at a time without sifting or iterating through a result set. Off the top of my head, each row can easily be set into a JSON right away, instead of retrieving a row and iterating through its columns, and setting column to key, and cell value to JSON value.
Also, it is likely on the initial run that there will be disparities, especially with lib:tokens made by different authors, or those that store different data. All in all, it's just a temporary store that the user can I either keep or not.
Yeah, it's growing on me too. Talend's too powerful for my simple use cases I was content to use SQL Workbench for my evaluations as it had all the drivers for the DBs I was assessing. Of course, if it'll benefit the designer base to learn how to use it, please feel free to share your findingsbadsequel wrote:edit: btw I kinda like H2. Haven't figured out how to interact via Talen Open Studio for data integration yet, but the DB itself works fine. I loved the way they packaged that simple web browser studio app in it. \O/