lua-users home
lua-l archive

[Date Prev][Date Next][Thread Prev][Thread Next] [Date Index] [Thread Index]


----- Original Message -----
From: Florian Weimer
Date: 2/3/2010 7:27 AM
Thanks a lot for your help. I am using sqlite3.
Here's a complete example.  It turns out that LuaSQL doesn't support
parametrized queries (or prepared statements), so you have to do your
escaping manually.
I've always found it bothersome that LuaSQL doesn't support prepared statements. That has forced me to find alternatives.

Lua-Sqlite3 (http://luaforge.net/projects/lua-sqlite3/) supports prepared statements. I've used it a bunch. It works fantastically.

LuaDBI (http://code.google.com/p/luadbi/) also supports prepared statements and works with SQLite, MySQL, PostgreSQL and others. I've used this a bit, and it seems to work pretty well.

Josh