HNHacker News
TopNewBestAskShowJobs

upmostly

729 karma · joined June 13, 2018

Building DB Pro at dbpro.app hit me up at james@dbpro.app
submissionscomments
upmostly··on Do you even need a database?
Exactly. And most apps don't get there and therefore don't need it.
upmostly··on Do you even need a database?
The irony isn’t lost on us, trust me. We spent a while debating whether to even publish this one.

But yeah, the page cache point is real and massively underappreciated. Modern infrastructure discourse skips past it almost entirely. A warm NVMe-backed file with the OS doing the caching is genuinely fast enough for most early-stage products.

upmostly··on Allbirds, Inc. Announces Expansion into AI Compute Infrastructure
Literally had to check the date with this one.

What?!

upmostly··on Show HN: boringBar – a taskbar-style dock replacement for macOS
We went through the exact same dilemma with our product [1]. For desktop apps, one-off with a defined support window just feels right.

Users get certainty, and you still have a clear path to future revenue when that window expires.

Subscription makes a lot more sense once you’re in cloud/collaborative territory which we've just entered. Sounds like you landed in a good place with this split.

[1] https://dbpro.app/pricing

upmostly··on Show HN: CSS Studio. Design by hand, code by agent
This comment was surprising to me.

I never considered that people want to watch a video in this day and age when they can try the real thing.

Perhaps I've fallen into that trap with the product [1] I'm building. I have a "Live Demo" button on the landing page and thought that would be enough? I'm going to reconsider...

1. https://dbpro.app

upmostly··on Chess in SQL
Thank you! That means a lot.
upmostly··on Chess in SQL
Interesting. I'm a big fan of MMORPGs so hearing that this is how they were made is really cool.

I've always wondered what kind of stack games like EverQuest were built on.

upmostly··on Chess in SQL
I thought about it, but, not surprisingly, that already exists.

https://pypi.org/project/chessql/

upmostly··on Chess in SQL
Thank you, and thanks for highlighting that. I'll take a look now.
upmostly··on Copilot edited an ad into my PR
Isn't this the same as

"Sent from my iPhone"?

upmostly··on Chess in SQL
Author here.

I had the idea of building a working Chess game using purely SQL.

The chess framing is a bit of a trojan horse, honestly. The actual point is that SQL can represent any stateful 2D grid. Calendars, heatmaps, seating plans, game of life. The schema is always the same: two coordinate columns and a value. The pivot query doesn't change.

A few people have asked why not just use a 64-char string or an array type. You could! But you lose all the relational goodness: joins, aggregations, filtering by piece type. SELECT COUNT(*) FROM board WHERE piece = '♙' just works.

upmostly··on Marketing for Founders
Are we, though?

My experience has been almost all positive.

Devs love to give feedback. Devs have decent paying jobs, and therefore money to purchase devtools (ours is $79) Devs love trying out new things and being early adopters.

Why is it a terrible market?

upmostly··on Marketing for Founders
I'm building and marketing a database client for the last 5 months, and what worked for me was:

1. Keeping a consistent devlog on YouTube. It's the #1 source of traffic.

2. Getting a rank 1, page 1 HN post for a technical blog post related to our product.

3. Word of mouth. It's slow, but it works.

Just thought I'd chip in. The devlogs work the best though. Plus they keep momentum.

upmostly··on Ask HN: What Are You Working On? (March 2026)
I'm building DB Pro, a better database client.

I just released support for dashboards. I've kept a devlog for the past 6 months.

https://youtu.be/EEA73e6MH1c

And the biggest update is coming soon, DB Pro Cloud, which will let you connect to and manage any database through your browser as well as collaborate with your team.

Imagine Postman but for databases.

https://dbpro.app

upmostly··on I started programming when I was 7. I'm 50 now and the thing I loved has changed
First of all, Homeworld was an iconic game for me growing up, so as other people have said, thank you for being apart of its creation.

I could not agree more. It feels like the creativity is back. I grew up building fun little websites in the 90s, building clan websites for Quake 2.

That creativity died somewhere between Node.js, AWS, npm, and GitHub.

Some might say, well, that's growing up and building serious apps.

Maybe. But it doesn't change that I spent the last 15 years doing the same frontend / backend wiring over and over again to churn out a slightly different looking app.

The last 2 years have been amazing for what I do. I'm no longer spending my time wiring up front ends. That's done in minutes now, allowing me to spend my time thinking about solving the real problems.

upmostly··on Ask HN: What are you working on? (February 2026)
Developers are pretty willing to pay for tools that save them daily friction, even in crowded spaces. I find that the trick is finding the wedge that makes yours feel essential rather than nice-to-have.

At the end of the day, people pay to save time. Doesn't matter if it's been done to death.

upmostly··on Ask HN: What are you working on? (February 2026)
I find that when people can see what's coming, they're more invested in the product and more likely to share feedback that actually shapes the direction. The devlogs on YouTube serve the same purpose. It's a two-way street.
upmostly··on Ask HN: What are you working on? (February 2026)
Thanks Steve! The team angle came from mine and my co-founder's own frustration. We kept copy-pasting query snippets and results of queries into Slack/Teams to our engineering team but also Sales/Marketing etc. Figured there had to be a better way. If you ever want to give it a spin, I'd love to hear your thoughts.
upmostly··on Ask HN: What are you working on? (February 2026)
I'm building DB Pro, a cross-platform database management app that lets you browse, query, and manage SQLite, PostgreSQL, MySQL, Redis, MongoDB, and more from a single native interface. It's been growing steadily with a community of ~1,400 subscribers on YouTube and paying users.

What I'm most excited about right now is DB Pro Studio: a collaborative web-based version I'm building on top of it.

The idea is simple: databases are a team activity, but every DB tool treats them as a single-player experience. Studio adds either a self-hosted or managed hosted data browser, real-time collaboration, dashboards, visual workflow automation, and enterprise features like audit logging and role-based access. Think "database command center" where your whole team can inspect, query, and build on your data together.

The desktop app acts as the execution engine (your data never leaves your infrastructure), while Studio provides the shared dashboard layer.

I've also consistently posted devlogs on YT throughout the journey, which has helped build a community of ~1,400 subscribers who've shaped the product along the way.

Site: https://dbpro.app YouTube: https://youtube.com/@dbproapp

Would love feedback from anyone who's felt the pain of sharing database context across a team.

upmostly··on UK government launches fuel forecourt price API
I spent the last few hours hacking together PetrolMate using this dataset: https://petrolmate.co.uk

A couple of interesting observations while building it:

Yesterday the dataset had ~600 stations. Today it’s reporting 6,666 stations from the UK government feed, which is… a slightly ominous number, but according to the data and me asking an LLM, that’s close to full UK coverage already.

I deliberately went for a “pure speed” tech stack. Astro, no UI framework, just vanilla JS. Deployed on Cloudflare, with prices stored in D1.

I'm not using the API to load the data, I'm cleansing and then importing the CSV (which you can download for free) into the D1 database.

There’s also an /insights page with some aggregated stats that genuinely surprised me: https://petrolmate.co.uk/insights

Really nice to finally have an official, open dataset to build on. It already feels far more reliable than the old user-reported approaches, and it’ll be interesting to see how coverage and update frequency settles over the next few weeks.

Would love to hear feedback by the way. What is this missing to make it a genuinely useful tool?

upmostly··on Using PostgreSQL as a Dead Letter Queue for Event-Driven Systems
Thanks, glad you like it.

DuckDB is on our radar. In practice each database still needs some engine-specific work to feel good, so a fully generic plugin system is harder than it sounds. We are thinking about how to do this in a scalable way.

upmostly··on Using PostgreSQL as a Dead Letter Queue for Event-Driven Systems
We just published a detailed walkthrough of this exact pattern with concrete examples and failure modes:

PostgreSQL FOR UPDATE SKIP LOCKED: The One-Liner Job Queue https://www.dbpro.app/blog/postgresql-skip-locked

It covers the race condition, the atomic claim behaviour, worker crashes, and how priorities and retries are usually layered on top. Very much the same approach described in the old 2ndQuadrant post, but with a modern end-to-end example.

upmostly··on Ask HN: Those making $500/month on side projects in 2025 – Show and tell
Windows and Linux are both launching next week (just in time for Xmas!)
upmostly··on Ask HN: Those making $500/month on side projects in 2025 – Show and tell
So DB Pro is a local desktop database client for managing your databases and data. Prisma ORM it won't replace, but Prisma's browser-based data browser, yes it will absolutely replace that. It's not a replacement for Supabase, it works alongside it, if that answers your question?

I'm planning to extend DB Pro into much more than a database manager though, letting you build dashboards, workflows and workbooks.

upmostly··on Ask HN: Those making $500/month on side projects in 2025 – Show and tell
It has some behaviour differences (connection handling, pooling, serverless constraints) that I want to support properly rather than “mostly works”. Right now I'm focused on making the core experience rock solid across the most common setups first. My focus has been UX and DevEx and it's working.

Neon support is on the roadmap though, and once I add it, it’ll be first-class rather than a checkbox integration.

upmostly··on Ask HN: Those making $500/month on side projects in 2025 – Show and tell
Thanks!

Yep, it’s built with Electron. Performance has been a big focus from day one, and it’s been really performant in all of my testing so far. The goal was a proper desktop-first experience with local performance and direct database access, rather than trying to force it into a web app. Although I do have plans to offer a self-hosted version as well.

upmostly··on Ask HN: Those making $500/month on side projects in 2025 – Show and tell
https://dbpro.app

I’m building DB Pro, a modern desktop database client for developers who want a fast, local-first workflow.

I started in October 2025, launched v1 at the end of November, and just crossed $1k MRR.

I also post devlogs of life building and marketing DB Pro and am about to post devlog #4. The latest one is here if anyone’s curious: https://youtu.be/-T4GcJuV1rM

Still very early, but it’s been fun seeing something fairly “boring” resonate once the UX is treated seriously.

upmostly··on Ask HN: What Are You Working On? (December 2025)
https://dbpro.app

We are working on DB Pro, a modern desktop data workbench for developers and data engineers.

The focus is on going beyond a query editor and building a complete environment for working with data. Visual exploration, inline editing, dashboards, and Jupyter notebook style workbooks for queries, notes, and experiments all in one place.

We launched v1 a few weeks ago and the reaction has been genuinely jaw dropping. Downloads, feedback, feature requests, and some great long form discussions around real world data workflows.

We are documenting the entire journey through a public devlog series. The latest video covers the v1 launch.

https://youtu.be/-T4GcJuV1rM

Honestly, building a desktop app is so refreshing after spending a decade or so building web apps.

upmostly··on SQLite JSON at full index speed using generated columns
Literally exactly as I meant it. I watch a lot of cooking shows, too, so this analogy holds up.
upmostly··on SQLite JSON at full index speed using generated columns
Great catch, I'll add that now!
← PreviousPage 2 of 5Next →