Graph Database (PG wire protocol connection)

1

Hello, I decided to conduct an experiment with the connection ArcadeDB is an open-source, Apache 2.0 licensed multi-model database, the documentation states that the database supports Postgres Wire protocol (old PG protocol).
I was interested in this, and I would like to work with a graph database using standard wappler tools.
I connected the required plugin, it was successfully launched and...
Naturally, I got an error in Knex.js Recipe it is indicated that

Specify PostgreSQL version that database you are using is compatible with protocol-wise using version option

But in the database connection options, there is no option to select a version.

Maybe someone went through this path and achieved success?

2

ArcadeDB’s PG wire protocol isn’t a full PostgreSQL implementation, it’s only enough for simple SQL clients. Knex (and therefore Wappler) requires real PostgreSQL metadata, version negotiation, and system tables, which ArcadeDB doesn’t provide. That’s why the connection fails. To use ArcadeDB with Wappler, you’d need to connect through its native REST/HTTP API, not the PG wire protocol.

1 Like
3

Thank you @ben I understand, but I really don't want to make a background for implementing CRUD, creating tables, and other things.. I was hoping to use the standard DB Manager tools.
I tried.