How can I pick sentences from SQL tables?

My idea was picking a random number with math.random, let’s say math.random( 4 ). Having this number, I would like to write a function to take from a SQL table some sentences. The table has 2 colums: id and sentences. When the number randomly picked is equal to the id, the relative sentence (on the same line) is picked by my function. I’m a beginner and I only know I should use sqlite3 and I need some help, thank you very much.

A simple query will work

SELECT sentence FROM table WHERE id = <my random number>

For the lua code read the solar documentation

1 Like

if you want to use a local database then go for the documented SQLLite database

if you want a cloud based database, then this is a completely different story, you need a cloud based server, and a webservice that can talk to that server, finally using network.request you can communicate with the database via calling the webservice

Thank you very much. This seems to work

Thank you very much, there was a similar problem! :face_with_hand_over_mouth: