"Just use postgres" strikes again
254 karma · joined December 16, 2016
https://allume.com/memos/2026-07-allume-v4/
Seems like they changed names internally from "Hatch" (some UI still uses hatch instead of muse)
However, I really miss the content posted by the KuzuDB team on their YouTube channel.
Customers need it to build custom reports, archive data into a warehouse, drive downstream systems (notifications, audits, compliance), and answer edge-case questions you didn’t anticipate.
Because of that, I generally prefer these patterns over a half-baked built-in analytics UI or an opinionated REST API:
Provide a read replica or CDC stream. Let sophisticated customers handle authz, modelling, and queries themselves. This gets harder with multi-tenant DBs.
Optionally offer a hosted Data API, using something like -- PostgREST / Hasura / Microsoft DAB. You handle permissions and safety, but stay largely un-opinionated about access patterns.
Any built-in metrics or analytics layer will always miss edge cases.
With AI agents becoming first-class consumers of enterprise data, direct read access is going to be non-negotiable.
Also, I predict the days of charging customers to access their own goddamn data, behind rate-limited + metered REST APIs are behind us.
Does WhatsApp charge money for this? If not, why would a business use their API? They could simply create an app to directly talk to their customers, or am I missing something?
This makes it feasible to build multi-tenant applications with 1-db-per-tenant. I know the same can be achieved with RLS policies or application-layer permissions, but nothing beats the peace mind (for developer and customers alike) of having tenant data in entirely separate databases. This also makes it easier to have custom schema for different subsets of users. Side note: SQLite (the OG serverless DB) also has the same benefit but is decidedly less feature-full than postgres/mysql.
Another pattern that I have seen emerging is that certain products allow end-users to create DBs on the fly as a part of their own product offering. For example, Retool (which uses Neon) allows users to create a new database in seconds, even on their free plan. I don't think this would have been possible (both cost and DX wise) if they provisioned a new Postgres cluster for each customer.
On that note, and in light of what happened with the Planetscale free plan, this would make the Supabase free offering and branching to be significantly less expensive to operate. btw: thank you for the free plan and all the amazing OSS contributions from the supabase team!!
You are totally right in that i don't have any real web/application development. In fact i just started university but i have been programming for a few years (mostly problems on sites like code chef in C, C++ no products) but recently got this idea when i visited a plant that my father owns. There are about 600 such plants in the same area and they use fairly old software or not at all. So i talked to him about my idea and he thinks it will be very useful and also commercially successful since there is virtually no competition. That's why i decided to learn web development. But now i am realising it's tougher than it looks. I asked this question in order to get an idea what all the things i need to learn in order to even attempt to build something like this. Now that i look at my question i think i should have asked "How to be a full stack web developer?". So if anyone is still reading i think this would be the question that you should answer or maybe i should have just googled it and started working
Then i want to process and display all this data (related to Manufacturing, Sales, Marketing etc) on web, iOS and Android.
So essentially there will be apps for employee's working in the plant (for data entry) as well as for the managers and owners (to monitor everything and make decisions)
I want the web dashboard to look somewhat similar to - https://demo.baremetrics.com
And since i have no experience in building mobile apps i want to know what languages/frameworks would be best suitable to develop good/native looking apps for iOS and Android using web technologies.
Thanks.
So what i am planning to build is SAAS service that provides all the feature's listed above and more, customised for an (unspecified for competitive purpose) industry. The web client is used for entry of data related to sales, stock, payroll. I am also making apps for various operator's inside the plant to upload data using their android phone's and tablets.
Then i want to process and display all this data (related to Manufacturing, Sales, Marketing etc) on web, iOS and Android.
So essentially there will be apps for employee's working in the plant(for data entry) as well as for the managers and owners(to monitor everything and make decisions)
I want the web dashboard to look somewhat similar to - https://demo.baremetrics.com
And since i have no experience in building mobile apps i want to know what languages/frameworks would be best suitable to develop good/native looking apps for iOS and Android using web technologies.
Thanks.