lua-users home
lua-l archive

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


I've just released SqlTable 1.2. SqlTable builds on LuaDBI to make database tables look like ordinary Lua tables. For example:

-- Select
local row = t_employees[ employee_name ]

-- Update
row.value = "modified"
t_employees[ row.id ] = row

-- Delete
t_employees[ row.id ] = nil

-- Insert
t_employees[ sql.next ] = row


It's available on Luarocks; documentation and raw tarball on it's homepage: 
https://zadzmo.org/code/sqltable/


Major changes are:

 - Supports MySQL and SQLite in addition to PostgreSQL
 - Updated to support Lua 5.2 and 5.3 as well as retaining support for Lua 5.1
 - Prepared statement caching - significant performance boost for repeated queries

-- 
Aaron B. <aaron@zadzmo.org>