SQLite Programming With Lua

This video shows how to program against a SQLite database using the Lua programming language.

Check out http://www.squidoo.com/sqliteprogramming and http://www.squidoo.com/sqlitehammer for more details.

2:25 into the video is where the preamble ends and the coding starts.

Category:

Science & Technology

Tags:

• SQLite
• Programming
• Lua
• sqlite programming

[johnjjesus]

Good job. What do you think about replacing SQLite with Lua tables? Lua seems to be good by itself as lightweight database with configuration data.

[Jaynonymous1]

@johnjjesus If you already have it working, Lua tables are great. As long as you don't have to write/update/delete records to the Lua tables often or if you don't have a large data set, Lua tables will do. However, if you want to be able to analyze a larger data set with ad-hoc queries it doesn't get better than SQLite without going to a full-blown database server.

[al0maz78]

I enjoyed this tutorial on SQLite and Lua. Can you share with me an example to do an update operation. I have looked around but no luck. I tried using prepare and bind but couldn't get that to work.

[Jaynonymous1]

@al0maz78 I am not able to do this at this time. However I recommend you do two things. First make sure that you can get an insert and a delete working. Secondly, try executing the command on the SQLite command line and make sure it works there before driving it with Lua. Tell me what happens.

[dbeatk]

have u gotten or do u have renegade cNc? i need tutorials on how to make commands for renegade online... thx

[Jaynonymous1]

Since I don't know what "renegade cNc" is, I don't have any such tutorials.

[kupu294]

Hi Do you have any idea on how to bind a variable of type text or int in the select statement? Select * from table where title = ? Please let me know if you have any idea. Thanks

[daebarkee]

Great thanks!

[tobuslieven]

Nice tutorial, liked it a lot.

[dbeatk]

darn, well its one of the many games from the command and conquer series. i am 11, and wanted to know if u knew how to code for renegade, thx though