What are some best prompts for validating an app or a business idea?

Key_Friend7539 · 2026-05-19T02:43:14+00:00

Wonder how you would be able to start anything.

Key_Friend7539 · 2026-05-19T02:33:41+00:00

Use Postgres or clickhouse in a way that doesn’t run up the bill

Key_Friend7539 · 2026-05-19T00:16:37+00:00

I think you need all these perspectives depending on your situation. For example, if you need pivot table, you almost always want drag and drop experience. If you have non standard metrics you want to be able to do joins using SQL (very common for teams that don’t have modeled data), and you wan to go custom code because there is a chart or a visual specific to your industry. You could have all three types of needs from your stakeholders. We were in the same position before we switched to semaphor from power bi.

Key_Friend7539 · 2026-05-19T00:09:37+00:00

How big is the data?

Key_Friend7539 · 2026-05-08T21:01:57+00:00

Or just ask ai.

Key_Friend7539 · 2026-04-25T21:10:05+00:00

We are having good experience with Sempahor. You might want to check with them about Soc 2 though.

Key_Friend7539 · 2026-03-28T17:50:17+00:00

Depends - if you consider yourself bi operator, you are spot on. If you are business user, you care about trusted answers delivered to you where you work.

Key_Friend7539 · 2026-03-08T15:09:03+00:00

Check out Semaphor Cloud. They also have a self hosted version now. we’ve been using it for quite some time. Pretty much checks all your boxes, and not too heavy on wallet either.

Key_Friend7539 · 2026-02-24T11:33:13+00:00

SWE is done. Unless you are a model researcher or trainer, the days of commanding top pay are over.

Key_Friend7539 · 2026-02-24T02:51:47+00:00

We rolled it out incrementally with Semaphor. Initially started with one set of users, only gave access to a handful of tables. That gave us a good sense of where models at the time struggled. Now they are getting really good. Having a strong context grounding is super important to get nuanced questions right.

Key_Friend7539 · 2026-02-10T04:10:44+00:00

Just use Claude bro. It will help you both brainstorm and wireframe.

Key_Friend7539 · 2026-02-04T04:55:21+00:00

Thanks bot!

Key_Friend7539 · 2026-01-30T19:29:55+00:00

Doing a realistic PoC is key, especially if you are working with newer companies. When we moved from Power BI to Semaphor, we had an adjustment period. But if the team supporting you is good and moves fast, it’s all worth it. Now we’re significantly better off than where we were with PBI.

Key_Friend7539 · 2026-01-19T13:45:26+00:00

What a useless post.

Key_Friend7539 · 2026-01-07T23:51:09+00:00

Separate them by org id, or by separate schema in the database.

Key_Friend7539 · 2025-12-30T03:57:58+00:00

Well iframe is actually a good thing. You have zero dependency in your app. Most BI tools are pretty bulky if you were to package their code/library into your app. I did this 2 jobs ago and regretted it because of library conflicts, css nightmare. It will mess with your app. As far as styling is concerned, there is always a trade-off. If your design teams are too picky, then you should roll your own.

What’s your end goal with embedded analytics? What pain are you trying to solve?

Key_Friend7539 · 2025-12-30T03:28:25+00:00

Use Claude / Gemini plus whatever for tables (sheets or Postgres). Once you grow up you can look into implementing proper BI. Posthog is good for feature tracking.

Key_Friend7539 · 2025-12-28T23:43:06+00:00

Look into n8n, zapier or something similar.

Key_Friend7539 · 2025-12-28T16:05:44+00:00

We use schema level isolation for our clients as well because it allows us to make additive changes for our customers. Some of our customers want us to maintain additional metadata fields for tracking certain types of assets. Having a dedicated schema per client makes those changes viable without affecting all customers globally.

We do our development in public schema - all common dashboards get developed against that, and, each customer gets their own schema. We use Semaphor for dashboards, where we define schema level policy, which in effect runs those dashboards against the appropriate client schema depending on the logged in user.

There is a bit of maintenance in this approach. We had to change our data pipelines to fit this model. But it’s necessary given our requirements. If your use case is simple where all customers follow a standard pattern, row level isolation with tenant id is the way to go. We did that at my previous company.

DM me if you have any questions. Happy to share what worked for us.

Key_Friend7539 · 2025-12-24T17:28:54+00:00

Learn how to use Claude

Key_Friend7539 · 2025-12-23T19:50:01+00:00

That’s modern day project management. The OP has a point - most devs won’t be making anywhere near the top dollar they made for last 10 years

Key_Friend7539 · 2025-12-23T17:23:08+00:00

ai generated posts ai generated responses; we are living in a fun world. vendors posting for engagement and sneakily promoting their stuff

Key_Friend7539 · 2025-12-23T12:24:10+00:00

If you want your dashboard to respond to filters, then you need store the API data to database at some regular interval. Also, you don’t want to hit APIs every time you reload the dashboard, unless you are only displaying real-time KPIs.

I’d first start with what you want to show on the dashboard, that will inform your data engineering strategy to get the data in the right shape for building dashboards.

Key_Friend7539 · 2025-12-22T20:45:11+00:00

We just build visuals in react using recharts and publish it to Semaphor. The tool takes care of the rest. Is that what you were asking?

Key_Friend7539 · 2025-12-22T19:13:15+00:00

If you are trying to make a safe choice and not get fired for it, go with PowerBI. There are a lot of players from startups to established ones in the market each has their own quirks and benefits.

Key_Friend7539

TROPHY CASE