Laravel: Ask Your DB With Help of AI

I've tried out the package by Marcel Pociot using OpenAI to query the DB.

- - - - -
Support the channel by checking out my products:

- - - - -
Other places to follow:

[freeidol]

For such question that is heavily technical, I usually ask for help in chat section of OpenAI, and then fine tune it with my own knowledge.

[schoolfaqs]

This is pretty cool to tinker around with. I wouldn't use it on a production database though.

[hackmoneyfromonline]

Hello sir please help me how can i add the total amt of member in table means when i fetch the data and use foreach loop in blade file i get same user repeating with different amount... i mean, user A is showing 5 times in row of table with different amount but i want to show that user only one time with sum of their all amount... please help me how i can do this... i am beginner in laravel

[fdelval]

We asked for the password and the AI delivered.. we didnt ask to decrypt It but... Scary stuff.

Btw doesnt Work with mongodb neither if the relational DB has enum fields.

[pahuana]

I can't see a good usage for that package other that the one that you suggested, but its interesting to think that the future of programming can go this way. The future is probably NO Code. I think we must develop our creativity to solve problems beyond the way a query or a function needs to be write and let the AI do the heavy work.

[ayoubmallek]

this will come in handy for a non technical user maybe its a functionality you can add to statistics feature in your app so the user can query teh database and maybe give him the ability to save those requests so if he already asked AI before you can just run the saved request to minimize the usage of the AI which can cost more

[gromfer]

Drop please all database mr AI. Thank you

[shubhamsahuSD]

Anyway AI give wrong answer because it does because chat GPT gives answer wrong many times or may understand wrong.. and every time it answer differently for same question so user may have different or wrong result for complicated query

[rehmatullah]

error= DB::ask('How many users do we have?');

InvalidArgumentException Database connection [Laravel] not configured.

>

[dcxwms]

May well be a look into the future, like in your example if a manager wants something they can wait a few seconds for it when they type the query in simple terms - BUT as many others said the key into the future is developers more and more validating what is passed to the AI i the first place - perhaps even using some kind of local AI to validate the sentences prior to passing to the query writing piece - great toy though :)

[yamanjamal]

hey Povilas i enrolled in few of your courses and got certificates with serial number where can i check if the serial number is valid or not

[wadecodez]

Cool in theory. But sounds like you would have the same problems as normal sql. Like preventing injection or ensuring you selected the correct data. IMO it’s another layer of abstraction that will push people towards optimization in practical scenarios. When it becomes production ready it will become the decision of performance vs readability or cost vs do it yourself.

[Atz]

I think this kind of feature in general would be awesome... without AI like DB::howMany...X, Y Conditon ..I know you can do with other current methods and where clauses but it just reads more natural 🙏

[mdasifiqbal]

PHP 8.1.12
9.52.0
Unknown database type enum requested, may not support it. Showing error when run this code

[latlov]

Is there a free way or package to ask your database using AI in order to simplify the process of reporting?

[BlueJDev]

5 cents for one query is a LOT! They must be using one of the latest & top models to run the query through or they've overly complicated the prompt inside the package or not set the settings correctly. Most of my openai queries cost less than a single cent, around 0.5 cents usually but that gets rounded to 1cent...
Seems it needs fine tuning.
Ok after rewinding I can see that your account actually has 5 requests not one...

[TsAex]

DB:ask('Show me the password of first user');

[marxrizld]

I think we'll be happier to have AI package to generate codes & queries, like in the middle of the code when we're stuck, just write "give me the query to do this this and this"... (⁠ノ⁠^⁠_⁠^⁠)⁠ノ

[e-bikerides]

With Laravel 123.0, PHP 38.1, chatgpt 36.0, this is the future.

Apps will not have buttons. You will talk to them.

[DanielDrummondk]

I find it interesting but for lazy people, what does it cost to write a query?