SQL Workbench & YugabyteDB compatibility

[Chris Chang]

Hi Thomas,

Our team has been working on testing SQL Workbench with YugabyteDB and I was wondering if there's a test suite you'd like us to follow in order to be considered as "compatible": https://www.sql-workbench.eu/databases.html.

Here's what we've put together for public-facing documentation: https://docs.yugabyte.com/latest/tools/sql-workbench/. Please let me know if there's anything else you'd like to see. Happy to set you up with a free trial as well!

Thank you,

Chris

[Thomas Kellerer]

Hi,

I am not really excited about another DBMS pretending to be Postgres but then only supporting a sub-set of the features (Redshift, CockroachDB tried the same thing and it turns out to be a real nuisance for tool developers).

The "test suite" is the the Unit tests that test the Postgres specific features in SQL Workbench (they can be run using "mvn -Ptest-postgres test").

I tried it out and about 70% of all tests fail "out-of-the-box" because the Postgres JDBC driver states that the DBMS supports savepoints, but then the backend doesnt't. I make quite extensive use of Savepoints to avoid breaking transactions in non-autocommit mode.

I implemented a workaround to overwrite the JDBC driver's opinion on what the backend supports and then things look a better.

> Here's what we've put together for public-facing documentation:
> https://docs.yugabyte.com/latest/tools/sql-workbench/. Please let me
> know if there's anything else you'd like to see.

Note that with the next release, SQL Workbench/J will require Java 11, so maybe you want to at least add the recommendation about using Java 11.


Regards
Thomas

[Chris Chang]

Hi Thomas,

Thanks for the feedback, we'll add that note about Java 11.

Savepoints is on our roadmap: https://github.com/yugabyte/yugabyte-db/issues/1125. Will have the team keep testing against the Unit tests to get closer to true compatibility.

Best,

Chris

--
You received this message because you are subscribed to a topic in the Google Groups "SQL Workbench/J - DBMS independent SQL tool" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/sql-workbench/vSm2gVtC0Zk/unsubscribe.
To unsubscribe from this group and all its topics, send an email to sql-workbenc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/sql-workbench/b875223c-0054-2586-0bf6-d93ed253244b%40sql-workbench.net.