ChatGPT + DaDaBIK = use natural language to build SQL reports from any DB
ฝัง
- เผยแพร่เมื่อ 8 ก.ย. 2024
- This video shows a new "knowledge extractor" DaDaBIK module: using DaDaBIK in combination with the OpenAI API, it is possible to extract knowledge from a Web application and create SQL report using plain English.
DaDaBIK is a low-code/no-code platform for Web database application Development. It's written in PHP, available since 2001 (20+ years) and constantly updated.
Try the on-line demo: dadabik.com/demo
Start a subscription (one month free): dadabik.com/try
#chatgpt #nocode #lowcode
If you want to try DaDaBIK (first month free): dadabik.com/try
I'll use this pinned comment to list some limitations/pitfalls I have found / I will find doing more tests. Or I'll publish another video, let's see :)
These are some additional issues I have found during my first tests:
Q: Can you tell me the phone number of my most important customer?
It uses the "status" field to sort the customers, literally it makes sense but in this context the status was lead, prospect, customer ...
Q: Which country does my most important client come from?
It uses the ID, assuming the most important client has highest ID.
Q: Average age of my three most important customers
It consider the customers involved in the three most important sales, which is different.
In most of the cases, reformulating the question in a more descriptive way should probably give the right answer.
I have also seen a wrong use of "group by" (grouping by the wrong field) but I can't replicate the issue anymore. I will do more tests.
Thank you for the good work though are doing!
I heard about it recently and I haven't used your system very well for months
I will try to involve soon
Amazing! Demo coming up.
very nice, good stuff... yes, I'm amazed that the ChatGPT can write code from you writing sentences :)
it works for PHP, regex, and other languages.
Great stuff!!!
Hi loved your demo but I'm having trouble understanding how you're able to provide chatgpt with "context" of the data while still keeping it protected. For example, in order to return oldest customer, you need to provide all customer info (age or birthday). If that information is confidential, how is it possible to use this functionality via chatgpt while keeping that data protected?
Hi, I don't give any data about the customers to GPT-3: what DaDaBIK gets from GPT-3 is an SQL query (e.g. select * from customers order by age_customer DESC), that DaDaBIK uses to get the oldest customer. Let me know if this is clear now.
@@DaDaBIK ah, so dadabik is just using chatgpt for the query itself. Understood thanks!
@@briankk123 Exactly
Interesting. ChatGPT belongs to Google, right? How can be 100% assured that company internal privacy data (e.g. in local CRM database) will not be retrieved by Google Company (although not published further by Google)?
ChatGPT (OpenAI) doesn't belong to Google. In this experimental feature, the data INSIDE the DB is never sent to OpenAI.
@@DaDaBIK thx. right, it belongs to Microsoft en.wikipedia.org/wiki/OpenAI ...