With our latest real time information release, we're now able to connect ChatGPT to any SQL database you have, and transmit the result of your SQL to ChatGPT, for then to have it analyse your data, answer your question, and return an answer accordingly.
However, before I start explaining the process, let's first enjoy a screenshot 😁
What you're looking at
The above ChatGPT answer was created by executing the following SQL
select f.title as Film, count(fa.actor_id) as Actors from film as f join film_actor as fa on f.film_id = fa.film_id group by f.title order by Actors desc limit 10
The above SQL of course is a part of a Hyperlambda snippet, that looks as follows;
data.connect:[generic|sakila] data.select:@"select f.title as Film, count(fa.actor_id) as Actors from film as f join film_actor as fa on f.film_id = fa.film_id group by f.title order by Actors desc limit 10;" .result: for-each:x:@data.select/* set-value:x:@.result strings.concat get-value:x:@.result .:"Film " get-value:x:@.dp/#/*/Film .:" " .:"Actor count " get-value:x:@.dp/#/*/Actors .:"\r\n" return:x:@.result
The above Hyperlambda snippet again is using the Hyperlambda [strings.mixin] slot, which combines natural language text with the result of executing Hyperlambda code. Below is a screenshot of the complete training snippet if you're interested.
Once the context is semantically matched towards the query, being e.g.
How many actors played in the movie MUMMY CREATURES?
The SQL extracts the following data;
Film MUMMY CREATURES Actor count 11 Film BOONDOCK BALLROOM Actor count 11 Film LAMBS CINCINATTI Actor count 10 Film HELLFIGHTERS SIERRA Actor count 10 Film ARABIA DOGMA Actor count 10 Film WIZARD COLDBLOODED Actor count 9 Film SUBMARINE BED Actor count 9 Film RANDOM GO Actor count 9 Film LESSON CLEOPATRA Actor count 9 Film IMAGE PRINCESS Actor count 9
Then our OpenAI machine learning functions submits the above data to OpenAI's APIs, which then uses the above as its "real time data foundation for answering the question", the end result being something such as follows;
There was 11 actors playing in the movie MUMMY CREATURES
In the video below I am walking you through the entire process
Pretty kick ass if you ask me 😁