Ask IH: How do you access your database?

I use Firebase, which isn't SQL, but has a decent built-in tools for visualizing the database. It's also quite easy to run queries on the db. You can do it from the front end of the website that the db powers, in fact, right from the JS console.

For Postgres I use PGAdmin4. It works great for me. For other databases, I mostly endup using console.

If it is mostly for looking at metrics, why don’t you create a small dashboard for this for yourself? For the other one to remove old or irrelevant data that sequel ace client @primer mentioned looks nice or otherwise something like Navicat although that might be a bit overkill for your usecase.

Datagrip

I use a DigitalOcean managed database (PostgreSQL) and interact with it via Django, which I have running on a DO server/droplet (you could do all this locally or with any other cloud provider or a different databse like MySQL). I use Django to create views/APIs so I can make requests over http from a web app or local Python/curl request. Django includes an admin portal out-of-the-box for easily editing and viewing data in your database. Django also abstracts a lot of database management for you so you don't have to write sql queries yourself to create/request/update/delete data. I've used PHPMyAdmin with WordPress in the past and found it difficult to use and customize

You’re not the first one I’ve heard complaining about clever-cloud haha

Need to know more about your setup—are you on osx/win/lnx, postgresql vs mysql, paid vs free.

TablePlus is an alright cross-platform and paid solution. There are free alternatives like pgadmin too. I’d recommend googling with your constraints in mind.

cosmosdb is so good. if you just need a small db, sqlite

I use Heroku's free tier for a PostgreSQL database and integrate Prisma.io with it. Highly recommend! Honestly it makes working with a databases so easy...

Huge fan of supabase (https://supabase.com/). Not only does it have a generous free tier but the admin portal is really easy to use and super powerful (run any SQL)

I'm using Postico (https://eggerapps.at/postico/) to access my PostgreSQL databases on my MacBook. Works perfectly, even with the free version. Sometimes I'm also using phpMyAdmin (for WordPress projects) and Firestore (for quick prototypes).

For metrics, I use grafana which makes nice graphs out of sql queries, for everything else I use the cli client

nocoDB all the way. It has its gimmicks but you can put it in front of your SQL database and viola, you have your personal Airtable 😄 Including webhooks and rest API for automation.

To open one of the most recently opened databases, on the File tab, click Recent, and then click the file name for that database. Access opens the database by using the same option settings that it had the last time that you opened it. If the list of recently used files is not displayed, on the File tab, click Options. In the Access Options dialog box, click Client Settings. Under Display, enter the number of documents to display in the Recent Documents list, up to a maximum of 50.
You can also show recent databases in the navigation bar of the Backstage view, for two-click access: 1) the File tab, and 2) the recent database that you want to open. Near the bottom of the Recent tab, select the Quickly access this number of Recent Databases check box, and then adjust the number of databases to show.

If you are opening a database by clicking the Open command on the File tab, you can view a list of shortcuts to databases that you have previously opened by clicking My Recent Documents in the Open dialog box.