Any support for surrealdb planned?

[Joey92]

As the title says. I've been eying SurrealDB lately. Currently coming from Postgres, I'd be totally missing sqitch.

[theory]

First I've heard of it, so I can't say how much work it'd be, but offhand it looks like they only client library currently available is in JavaScript (from the SDKs page). Maybe there is ODBC support? Other than that, if it has robust SQL functionality it ought not bee too difficult for an interested party to take on. I'd be happy to advise on the effort and test it!

[Joey92]

I took a look at the currently supported databases. I can see that JDBC or ODBC is preferred? SurrealDB seems to use HTTP as a first class citizen with either plain REST or WebSockets. What's yuor opinions on that?

[theory]

Each engine can use whatever interface it deems best, but if you can use SQL with the DBI there likely will be a lot less code to write. Snowflake's main API is also REST, but the company provides an ODBC driver and CLI that Sqitch uses.

I'm assuming that Surreal provides an CLI, yes? That's a key feature of Sqitch: It uses the native CLI SQL file format for each engine.