Comment on Microsoft is making every Windows 11 PC an AI PC
FreedomAdvocate@lemmy.net.au 5 weeks agoA spreadsheet? No, sales go through the database. That was also just an example. You could ask it to see which state has the most sales of product X between dates Y and Z for customers between age 18 and 25, as another example. You can ask it anything you can think of to do with the data.
It’s basically a reporting engine that can create ad-hoc reports at will.
It’s a lot easier to write a prompt for a report than it is to query the database, especially when you don’t know SQL etc - or even have access to the database.
Soup@lemmy.world 5 weeks ago
Product X > filter by state > date range. Why is this difficult? Gimme another, it’s mildly entertaining even if it’s not exactly difficult.
FreedomAdvocate@lemmy.net.au 5 weeks ago
What product are you using to get that data from a live Azure database?
Soup@lemmy.world 5 weeks ago
You literally told you built something which would allow an LLM to access the data. In order to be reliable enough the data would have to be appropriately sorted already and there would need to be an interface which the LLMs could use. So you built all this stuff to let the LLM thing work and now you’re looking at me stupid like building an extreme simple filter is some sorta crazy thing and we need a product to do it.
What the hell were people doing before you built your little chatbot? Just neatly sorting information into a black box and throwing into the ocean?
FreedomAdvocate@lemmy.net.au 5 weeks ago
Ah ok, so you have no idea what you’re talking about then lol. In a nutshell you go “here is your database connection details, now be a good little AI and answer my questions about the database”.
“an extreme simple filter” lol. It could be pulling data from 30 different tables, views, stored procedure results, etc from the database and making insanely complex queries and reports, then cross referencing those with external logs from a third party logging service to provide even more data. You seem to think that you pretty much have to build all the queries and reports and services and then the LLM just calls them with some parameters lol.
You very clearly have zero experience in this area, and have not done even the most basic of research.