[Feature Request] use server side Postgres Protocol

[terefang]

Is your feature request related to a problem? Please describe.

maintaining special driver libs in project are a pain

it would be convenient to leverage on an existing network protocol and driver like postgresql or mysql have

the effort to maintain different language driver implementation could be bundled server-side

Describe the solution you'd like

create a postgresql protocol server in rqlited siimilar to cockroachdb/h2db/cratedb

https://github.com/jeroenrinzema/psql-wire

existing drivers can then be used to access the database that are either already shipped with the distro or are widely available.

[otoolep]

Thanks for your report, yeah, this could be quite useful.

However I would be concerned about all the features that rqlite doesn't support. For example rqlite doesn't support traditional transactions, as most folks might expect. Do you think this is an issue?

[otoolep]

This is the other prior art that might be relevant: https://github.com/benbjohnson/postlite

[terefang]

the most basic mode would be to just take sql commands from the client connection, forward it to the database and return any status codes and possible result sets.

i have also seen a lib that implemented mysql/mariadb protocol, but i am unable to find the link

[terefang]

i have been using crate.io over postgresql protocol almost a decade and they sport some unique sql syntax.

that said, ithink you dont even need to rewrite psql to sqlite syntax as the user should be readily aware what chimera he is using.

:-)