- Uses ghmattimysql now completely, shares almost the complete list of features.
- Enabled js-syntax, which allows nifty shortcuts:
MySQL.Async.fetchAll('SELECT * FROM ?? WHERE ?', {'users', {['id'] = id}})
-- Renders as: SELECT * FROM `users` WHERE `id` = @id; with parameter id being id- The js-syntax also allows for bulk inserts.
- Switched to typescript.
- Blob field issue has been fixed and now returns arrays.
- Store feature has been added, it is useful for replacing reptitive queries, as the entire query string does not need to be resend to mysql-async
local queryId = MySQL.Sync.store('SELECT * FROM ?? WHERE ?')
--...
MySQL.Async.fetchAll(queryId, {'users', {['id'] = id}}, function(result)
print(json.encode(result))
end)