[Date Prev][Date Next][Thread Prev][Thread Next]
[Date Index]
[Thread Index]
- Subject: [ANN] Sqltable 1.2
- From: "Aaron B." <aaron@...>
- Date: Wed, 30 Aug 2017 11:40:27 -0400
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>