Add missing DBeaver drivers

[jemrobinson]

:white_check_mark: Checklist

• [x] I have searched open and closed issues for duplicates.
• [x] This is a request for a new feature in the Data Safe Haven or an upgrade to an existing feature.
• [x] The feature is still missing in the latest version.
• [x] I have read through the documentation.
• [x] This isn't an open-ended question (open a discussion if it is).

:strawberry: Suggested change

DBeaver needs drivers for PostgreSQL and MSSQL or it is essentially unusable.

:steam_locomotive: How could this be done?

Download and install drivers with ansible. Note this will probably require allowing access to maven.org but it might be possible to do with Nexus if #2135 is implemented.

[JimMadge]

Work on v4,

• https://github.com/alan-turing-institute/data-safe-haven/issues/1666
• https://github.com/alan-turing-institute/data-safe-haven/pull/1704

It looks fairly involved to 'trick' DBeaver to use drivers that you have installed yourself. I'm going to quickly try DbGate and BeeKeeper Studio to see if those package the drivers rather than trying to install them from the internet at run time.

[JimMadge]

• DBGate
  • Connects to psql
  • Can create tables
  • Seems to have trouble seeing tables/data
• Beekeeper Studio
  • Can connect to psql
  • Can create tables, enter data
  • Can see tables/data

[jemrobinson]

Is Beekeeper free? This implies not. Looks good if it works though.

[JimMadge]

Community and paid for versions a bit like DBeaver. The community edition supports a good range of databases though, including postgres and SQL server.

[jemrobinson]

Cool - do you have time to make a PR to switch over to this?

[JimMadge]

Will do soon. I was just checking SQL Server also works. (getting the details right took a while 😒).

I'll add connection details to the docs.