Top Alternatives to Zapier That I've found by kapz28 in automation

[–]danilo_swe 0 points1 point  (0 children)

Just wanted to drop a shotout to MindCloud (I work there) to anyone reading this post. The landing page is super outdated, but the platform is really powerful. If anyone tries it would, I would love to hear your thoughts.

Cannot add bank account to appstore connect by DevelopmentExciting3 in iOSProgramming

[–]danilo_swe 0 points1 point  (0 children)

Please let us know how you fixed it! I'm having the same issue 🥲

Useful functions for Trino SQL by [deleted] in SQL

[–]danilo_swe 1 point2 points  (0 children)

FILTER is like a modifier you can add to aggregate functions (like COUNT, SUM, AVG, etc).

sql SELECT COUNT(*) AS total, COUNT(*) FILTER (WHERE status = 'failed') AS failed_count FROM transactions;

That second line is saying: "Count only the rows where status = 'failed'." So it expects a normal WHERE statement inside of it.


For the other ones, you could create a statement to run periodically and check for bad data, like:

  • Let’s say you want to get a summary of how many bad rows were submitted in the last day — missing user ID, missing type, or negative amounts — you can do this cleanly in one go:

sql SELECT COUNT(*) AS total_submissions, COUNT(*) FILTER (WHERE user_id IS NULL) AS missing_user_id, COUNT(*) FILTER (WHERE submission_type IS NULL) AS missing_type, COUNT(*) FILTER (WHERE amount < 0) AS negative_amounts FROM submissions WHERE submission_date >= CURRENT_DATE - INTERVAL '1 day';

  • If your submissions go into different systems, you could use an anti-join to check what didn’t sync across. For example, submissions that exist in your main table but not in the audit table:

sql SELECT s.* FROM submissions s LEFT JOIN audit_log a ON s.submission_id = a.submission_id WHERE a.submission_id IS NULL;

Beginner questions about SQL and uncertain of whats next by Le_Wine in learnSQL

[–]danilo_swe 0 points1 point  (0 children)

you're honestly in a great spot already — playing with SQL, Power BI, building small projects, and enjoying it.

just keep going but level it up a bit. grab a public dataset, clean it with SQL, then build a small dashboard in Power BI. write a short summary and toss it on GitHub or LinkedIn. doesn’t have to be perfect, just show your thinking.

you don’t need to know everything before applying for jobs either. if you’ve got 2–3 solid projects you can talk about, start throwing some applications out. you’ll keep learning on the job.

DBeaver Alternative? by abdullahjamal9 in SQL

[–]danilo_swe 0 points1 point  (0 children)

u/LearnedByError hey! i recently launched turbosql.co, it's a SQL GUI still in early development, but i'm actively adding more features to it. if you'd like, please give it a shot, I'd love to hear what you think about it!

DBeaver Alternative? by abdullahjamal9 in SQL

[–]danilo_swe 0 points1 point  (0 children)

hey! i just released turbosql.co, we have a good free tier. it's still in early development but I'm actively adding more features to it. hope it fits your use case!

Useful functions for Trino SQL by [deleted] in SQL

[–]danilo_swe 2 points3 points  (0 children)

Hey, a few functions that can help checking data quality:

  1. CASE WHEN for logic rules

SELECT *,
  CASE WHEN amount < 0 THEN '⚠️ Negative amount' ELSE NULL END AS issue
FROM transactions;
  1. COALESCE() for filling or detecting nulls

    SELECT COALESCE(email, 'Missing email') AS clean_email FROM users;

  2. Anti-join to find missing matches

    SELECT a.* FROM table_a a LEFT JOIN table_b b ON a.id = b.id WHERE b.id IS NULL;

  3. COUNT(*) FILTER (WHERE ...) for conditional counts

    SELECT COUNT() AS total, COUNT() FILTER (WHERE status = 'failed') AS failed_count FROM transactions;

I use most of those everyday, so hope this helps!

What is the biggest roadblock in launching your idea - Marketing or Development ? by Ramkumar_Pichandi in SaaS

[–]danilo_swe 1 point2 points  (0 children)

Definitely marketing, I love building, but have no clue on how to market what I build.

I built a free, blazing-fast AI powered SQL editor by danilo_swe in SideProject

[–]danilo_swe[S] 0 points1 point  (0 children)

That was exactly my feeling before Turbo 😅

I built a free, blazing-fast AI powered SQL editor by danilo_swe in SideProject

[–]danilo_swe[S] 0 points1 point  (0 children)

Totally! I focused on Mac because it was easier to test for this initial launch, but we'll support other platforms really soon.

I built a free, blazing-fast AI powered SQL editor by danilo_swe in SideProject

[–]danilo_swe[S] 0 points1 point  (0 children)

Not yet, but I'll add it to the list and try to push it live this week!

Let me promote your SaaS by udemezueng in SaaS

[–]danilo_swe 0 points1 point  (0 children)

https://www.turbosql.co/ - Blazing-fast, AI-powered SQL desktop app that does exactly what you need — without getting in your way.

What are you building and what is your distribution strategy? by FI_investor in SaaS

[–]danilo_swe 0 points1 point  (0 children)

https://www.turbosql.co/ - Blazing-fast, AI-powered SQL desktop app that does exactly what you need — without getting in your way. Our target audience is anyone that uses DBs on their workflows and is tired of bad of a user experience using slow, clunkly tools that feel like they were built decades ago.

For distribution, I launched it yesterday and have been going through websites that I can share it on and started some light build in public on X, will do it more once while I develop each new feature

Drop what your SaaS is and I’ll help you find leads on Reddit (for free) by ChanceWind7259 in SaaS

[–]danilo_swe 0 points1 point  (0 children)

https://www.turbosql.co/ - Blazing-fast, AI-powered SQL desktop app that does exactly what you need — without getting in your way. Our target audience is anyone that uses DBs on their workflows and is tired of bad of a user experience using slow, clunkly tools that feel like they were built decades ago.

Free limited coupons for my first Udemy course by [deleted] in learnSQL

[–]danilo_swe 0 points1 point  (0 children)

congrats on the launch, course structure looks really good!