1
2 Comments

Would You Give Me Access to Your Database..?

Hello,

I'm working on a database monitoring tool: pgtop.dev.

A crucial step for the tool to work is to get access to the database.

Databases are sensitive and companies would understandably not give access to it lightly. I've worked on a way to provide access to the DB without giving access to the data itself, thanks to permissions config. However, it does require a more complex setup (creating a custom database user) that might stop potential customers. (See setup instruction once users have installed the app and additional setup instruction)

on February 9, 2021
  1. 2

    This looks like I'd have to give this access through the public network, however since getting burned from that, all my DBs run on a private network. Would you be able to get around that? Metabase can't handle this unless I self-host (so they don't make money from me, even though I'd give it to them)

    1. 1

      Yes that's another issue. With some cloud providers (e.g. Heroku) the DB is accessible on the public network. With some other providers, one can add exceptions. But most of the time it's complicated.

      If someone was ready to pay I could build and provide a small app to self-host on-premise. The app would still have to communicate over the internet but that would be via HTTP. And it would still have to go through the main (SaaS) app to communicate with Slack that's an incentive to keep the subscription up :)