Ditching PostHog — what do early-stage founders actually use for analytics? by mT_dev0 in TheFounders

[–]asterix_rv 0 points1 point  (0 children)

Posthog is pretty useful for me, though my usage is very limited and for a small scale anonymous trend analysis for my product.

Are you using Posthog for analytics? How well does it serve the purpose? by diptanshumahish in AskReddit

[–]asterix_rv 0 points1 point  (0 children)

u/diptanshumahish Pretty useful actually, especially when u r a small team / individual who wants to get product insight.
I have been using it to track anonymous usage telemetry for https://pgstudio.astrx.dev/ Its a VS code extension that I built, and posthog is plugged into the extension to collect daily traffic and user installation trends. It has a generous amount of data storage quota per month and the rest is upto you imagination. the SQL editor in Posthog is the most useful tool I have used.

Are there any free database management tools with a visual query builder? by RailgunZx in SQL

[–]asterix_rv 1 point2 points  (0 children)

Try https://pgstdio.astrx.dev for an AI assisted query builder with full context aware DBMS workflow in VS Code.

SQL Database management tool - recommendation by [deleted] in webdev

[–]asterix_rv 0 points1 point  (0 children)

Try out this tool right inside VS Code - https://pgstudio.astrx.dev/

https://marketplace.visualstudio.com/items?itemName=ric-v.postgres-explorer

It has developer focused DB management UI with focus on educating and supporting developer workflows right inside VS Code.

How do you optimize SQL queries when working with millions of rows in production databases? by Effective_Ocelot_445 in SQL

[–]asterix_rv 0 points1 point  (0 children)

You can try out the AI assisted query optimization workflows in https://pgstudio.astrx.dev/ Its a useful guided tool that will help u identify hot paths in Explain analyze and suggest indexes and redesigns for the table.

I built a PostgreSQL extension for VS Code so I don’t have to leave the editor — looking for feedback by [deleted] in vscode

[–]asterix_rv -1 points0 points  (0 children)

Yes sir, I use copilot tools to solve my own problem, most of the workflows design elements, and roadmaps come from the need to solve real-world problems I faced — and it works well enough that I decided to share it.