H2 support

[oscargong]

Problem

It would be nice if Table Pro could support H2
https://www.h2database.com/html/main.html

connection is like jdbc:h2:/Users/Username/workingproject/local-h2-db;AUTO_SERVER=TRUE

Proposed solution

No response

Alternatives considered

No response

Related database type

None

[datlechin]

H2 is Java-only. No native client, no stable wire protocol, no documented file format. Bundling a JVM isn't something we want to do, so a first-class driver isn't on the table.

Workaround: H2 has a built-in PostgreSQL server. Run:

java -cp h2*.jar org.h2.tools.Server -pg -pgPort 5435 -baseDir /path/to/d

Then connect from TablePro with the PostgreSQL driver on localhost:5435, user sa.

Closing as not planned.