ArcadeDB via Postgres Protocol

[gramian]

What do you use this database for?

I use ArcadeDB as core component of a data-lake and metadata-catalog. ArcadeDB can be queried in a dialect of SQL.

Are there any existing node clients for this data source?

See: https://docs.arcadedb.com/#Drivers and https://docs.arcadedb.com/#Compatible-Tools

Particularly the postgres wire protocol is supported if the option preferQueryMode=simple is passed. Currently, I need to edit the connection.yaml to pass a sub-object of options, ie:

options:
  preferQueryMode: simple

However, it seems Evidence crashes using it this way; on the ArcadeDB side also an error is logged.
In the web interface this not configurable, and the option above is rendered as [Object object] in the "Options" form element.

Are you interested in contributing this connector?

I'd like to contribute, but I need some help

[gramian]

Here is an error reported by evidence:

node:buffer:774
    throw new ERR_INVALID_ARG_TYPE(
    ^

TypeError [ERR_INVALID_ARG_TYPE]: The "string" argument must be of type string or an instance of Buffer or ArrayBuffer. Received an instance of Object
    at Function.byteLength (node:buffer:774:11)
    at Writer.addCString (/evidence/node_modules/pg-protocol/dist/buffer-writer.js:42:30)
    at Object.startup (/evidence/node_modules/pg-protocol/dist/serializer.js:10:32)
    at Connection.startup (/evidence/node_modules/pg/lib/connection.js:125:33)
    at Connection.<anonymous> (/evidence/node_modules/pg/lib/client.js:120:13)
    at Connection.emit (node:events:519:28)
    at Socket.<anonymous> (/evidence/node_modules/pg/lib/connection.js:49:12)
    at Object.onceWrapper (node:events:633:28)
    at Socket.emit (node:events:531:35)
    at afterConnect (node:net:1592:10) {
  code: 'ERR_INVALID_ARG_TYPE'
}