No definitely not. Kafka is for LinkedIn scale. Postgres is for everyone else.
Quick anecdote. I remember a friend who joined Shopify relatively early. He took ALL their data from many different services (analytics, Kafka etc) and loaded into Postgres on his laptop so he could query it efficiently.
It's amazing how over-engineered some startups are.
Not sure if I got it right, but if you want to build a simple backend I'd go with Supabase/Firebase for auth and Airtable for data/API. As for admin functionality — Retool seems to be the most powerful app (but can require some coding).
Also check out Memberstack — it allows to hide pages under paywall/authorization.
Here's a broader list of tools that we use.
No-code tools:
• Notion — documents (both internal project docs and public docs)
• Super.so, Tilda, Webflow, yep.so — landing pages and websites (also want to try popsy.so)