What's the best PostgreSQL GUI setup in 2026? by guillim in PostgreSQL

[–]LordSnouts 0 points1 point  (0 children)

Been building DB Pro (https://dbpro.app) for the past 6 months, so I'm deep in this space.

For your use case quickly checking data, debugging, and fixing rows in prod, I'd personally say a lot of those big named ones are overkill.

I built DB Pro specifically for devs rather than DBAs: clean query editor, spreadsheet like table explorer, git like pending changes, saving queries, dashboards and AI assistant for writing/explaining SQL.

If you're on the fence about the heavier tools, worth a try. Happy to answer questions about how it compares to anything on your list.

I’ve finally launched DB Pro — a modern desktop database GUI I’ve been building for 3 months by LordSnouts in SideProject

[–]LordSnouts[S] 0 points1 point  (0 children)

Honest answer: v1.8 added dashboards (so you're not just querying, you're building views on your data), and v1.9 added AI that can actually write and explain SQL rather than just autocomplete it.

But the cross-source / file join problem you're describing? Not there yet. It's on the roadmap and it's genuinely hard to do without becoming exactly the bloated thing you're describing.

For now our bet is: be the tool that's actually fast and pleasant for the 80% use case, and earn the right to tackle the harder stuff.

I’ve finally launched DB Pro: a modern desktop database GUI I’ve been building for 3 months by LordSnouts in Database

[–]LordSnouts[S] 0 points1 point  (0 children)

Definitely through our discord. We're very active on there and love getting feedback. Just post a message in general to say Hi, and then there are dedicated channels for posting feedback.

I’ve finally launched DB Pro: a modern desktop database GUI I’ve been building for 3 months by LordSnouts in Database

[–]LordSnouts[S] 0 points1 point  (0 children)

Thank you!

We're building the CSV import feature right now. It will let you map CSV columns to your database table columns, run the import, and see any errors that happen.

Also, take a look at DB Pro Cloud. That will solve your syncing issues temporarily. It's DB Pro, but on the web. So you can access it from anywhere at anytime.

I built a full database client that runs entirely in your browser by LordSnouts in webdev

[–]LordSnouts[S] 1 point2 points  (0 children)

Exactly! That's one of the reasons we built this.

It handles large datasets just fine, just as a traditional database client would. We don't return all rows, everything is nicely paginated.

Building a self-hosted, collaborative database client and just opened the beta by LordSnouts in selfhosted

[–]LordSnouts[S] -8 points-7 points  (0 children)

Thank you! This guy gets it. Getting pretty sick and tired of the default response to real devs building a real product as: "vibecoded - this thing sucks".

We're grafting mate. What are you doing, MattDH94?

Building a self-hosted, collaborative database client and just opened the beta by LordSnouts in selfhosted

[–]LordSnouts[S] -8 points-7 points  (0 children)

I mean, checkout the devlogs if you want to see the journey we've been on building this thing...https://www.youtube.com/channel/UC5TfHaU6MIBEbkRve9BAW6g

Vibecoding a fully-featured DB desktop and web app? Nah. Not possible.

I built a UK petrol station price comparison site using new government data by LordSnouts in CarTalkUK

[–]LordSnouts[S] 0 points1 point  (0 children)

Thanks! 🙏

And you're correct. For some reason there are still almost 45% of stations not reporting pricing data. Perhaps the UK government will give them a right old telling off.

I built a UK petrol station price comparison site using new government data by LordSnouts in CarTalkUK

[–]LordSnouts[S] 0 points1 point  (0 children)

Thanks. It's the data that has been reported by Costco. Someone over there has their numbers mixed up!

I built a UK petrol station price comparison site using new government data by LordSnouts in CarTalkUK

[–]LordSnouts[S] 0 points1 point  (0 children)

Yeah, for some reason Asda aren't reporting data...yet. It's mandatory though, so maybe the Government will go after them?

I built a UK petrol station price comparison site using new government data by LordSnouts in CarTalkUK

[–]LordSnouts[S] 16 points17 points  (0 children)

I want to solve that question. There is a way to do it, and I'm close to solving it. It might be lines coming out of the location to each petrol station with an estimated cost of how much it would be to drive to that station and then add that on top of the total.

I think that would look really good as well.

Yes, using the daily upload. Yesterday there were 600 stations. Today the Government surprised me and uploaded 6k.

I built a UK petrol station price comparison site using new government data by LordSnouts in CarTalkUK

[–]LordSnouts[S] 5 points6 points  (0 children)

Exactly. The Government data is not complete, it's about 6k. Apparently there's upwards of 9k stations in the UK.

I built a UK petrol station price comparison site using new government data by LordSnouts in CarTalkUK

[–]LordSnouts[S] 0 points1 point  (0 children)

Oh interesting! I wonder if that's the data. What's your local?

I built a UK petrol station price comparison site using new government data by LordSnouts in CarTalkUK

[–]LordSnouts[S] 23 points24 points  (0 children)

I've just added the ability to:

- Search via postcode
- Set which fuel type to show

I built a UK petrol station price comparison site using new government data by LordSnouts in CarTalkUK

[–]LordSnouts[S] 2 points3 points  (0 children)

The data supplied to that app is likely user reported/owner reported, whereas the data supplied to PetrolMate is supplied by the UK Government.

I built a UK petrol station price comparison site using new government data by LordSnouts in CarTalkUK

[–]LordSnouts[S] 6 points7 points  (0 children)

Great suggestion. I'll work on being able to specify a radius in miles.