search

krpors / gimlet

A JDBC-based database drill down utility.
MIT License
32 stars 3 forks source link

There's no disconnect context menu item #6

Open aadrian opened 6 years ago

aadrian commented 6 years ago

There's no disconnect context menu item on the connections in the Aliases Tab.

Since DBs in embedded mode (like H2) can have only one connection at a time, it's important to know if the connection is open, or not, and maybe disconnect.

Usually in most tools after the users clicks connect, the menu item(or action) is transformed in "Disconnect".

By this operation I don't mean to close the Tab that was opened :), but just the connection, in order to allow other tools to do something on the embedded DB.

krpors commented 6 years ago

Maybe I can implement this with a button or the like on the Tab itself. There is no 1 - 1 association between an Alias and a Tab currently (and not planning to, frankly), so changing the context menu is not really an option.

By the way, what exactly is "embedded" mode? I only know of "in-memory" mode of certain databases, but that's only applicable per running JVM.

aadrian commented 6 years ago

By the way, what exactly is "embedded" mode? I only know of "in-memory" mode of certain databases, but that's only applicable per running JVM.

DB runs in the same JVM as the application. But it's not just "in-memory", it's also persistent and consistent - so it's suitable for production. It also means that only the running applications can create connections to the DB - so the performance is very high.

E.g. for H2 Database http://h2database.com/html/cheatSheet.html, you can see that the in-memory is different from the embedded mode.