4 ms·
Another way that I am experimenting with is to combine AI and Postgres to build SQL queries and then run them directly. In this way users can gain valuable data
by l5870uoo9y 4y ago
Another way that I am experimenting with is to combine AI and Postgres to build SQL queries and then run them directly. In this way users can gain valuable data insights (essentially building data dashboards themselves) without bugging the data analyst [1]. Still in beta.
And as the article notes "Postgres is equipped" to query, format and return the data needed.
[1]: https://aihelperbot.com/videos/preview-use-ai-to-become-your-own-data-analyst-and-build-sql-and-run-sql-directly-on-your-database https://aihelperbot.com/videos/preview-use-ai-to-become-your...
- boredemployee 4y agoI made an app like that for myself using OpenAI (codex). While it works pretty good for basic stuff (near 100%) it fails hard when you need some more advanced queries. ie.: I asked it to write a query to check how many times "user A" triggered "event X" before triggering "event Y" (with a column of their timestamps). Never returned the right answer.
- l5870uoo9y 4y agoSomething like this: https://aihelperbot.com/snippets/cleitmbiq0018mf20pr281yau https://aihelperbot.com/snippets/cleitmbiq0018mf20pr281yau Beyond the prompt as you see above, I added the events table with id, userName, eventType and date field. Adding your database tables gives (in my experience) high accuracy.