Hacker News new | ask | show | jobs
by xwdv 979 days ago
I did something similar, but instead of building out a whole app I just insert data into a Postgres database directly. It turns out if you know SQL, you don’t need any kind of frontend really to manage your business. Coming up with new features is as simple as building out new views or writing functions on the fly.
5 comments

It's 1977 all over again. Before the next 40 years of canned application software happened, filePro and other self-serve app development systems of the time were just a database with thin skin of ui in the form of input screen designer and output print designer.

As a dentist or whatever, you just define some fields that matter to you. And that actually was enough to do most of the job anyone really needed doing.

Next unicorn will just be a UI wrapper ontop of a postgres instance.
Something like this https://retool.com/
Yeah that is basically what I was describing. I guess it wasn't as unique of idea as I thought.
MS Access might be the thing for this. Not used it in decades but loved it back then. Best of both worlds as long as it's for a single user.
To be fair this is 90% of most apps that any business needs.

A view into a database.

I would like to agree with the other commentor asking for a blog post write-up on this.

I would love to see which software stack you like building up for this.

The software stack is:

SSH. Postgres on Amazon RDS.

This sounds like it would be an interesting blog post.
As long as you never forget the WHERE clause for the DELETE statements, that sounds fine.
Even if you forget, you can just rollback to a snapshot.