SQLite 是輕量級嵌入式數據庫,無需獨立服務進程,適合本地存儲、移動端、嵌入式設備。Lua 通過 luasql.sqlite3 驅動操作。
local sqlite3 = require "luasql.sqlite3"
local env = sqlite3.sqlite3()
local conn = env:connect('mydb.sqlite') -- 文件路徑,不存在則自動創建
local status, err = conn:execute([[SQLite3 STATEMENT]])
-- 返回規則同 MySQL:成功非 nil,失敗 nil + 錯誤信息
local status, err = conn:execute([[
CREATE TABLE sample (
'id' INTEGER,
'name' TEXT
)
]])
-- SQLite 推薦使用單引號包裹列名,避免關鍵字衝突
conn:execute([[INSERT INTO sample VALUES ('1', 'Raj')]])
local cursor, err = conn:execute([[SELECT * FROM sample]])
local row = cursor:fetch({}, "a")
while row do
print(string.format("Id: %s, Name: %s", row.id, row.name))
row = cursor:fetch(row, "a")
end
cursor:close()
local sqlite3 = require "luasql.sqlite3"
local env = sqlite3.sqlite3()
local conn = env:connect('mydb.sqlite')
local status, err = conn:execute([[CREATE TABLE sample ('id' INTEGER, 'name' TEXT)]])
print(status, err) -- 0 nil
status, err = conn:execute([[INSERT INTO sample VALUES ('1', 'Raj')]])
print(status, err) -- 1 nil
local cursor, err = conn:execute([[SELECT * FROM sample]])
print(cursor, err) -- cursor nil
local row = cursor:fetch({}, "a")
while row do
print(string.format("Id: %s, Name: %s", row.id, row.name))
row = cursor:fetch(row, "a")
end
cursor:close()
conn:close()
env:close()
BEGIN/COMMIT/ROLLBACK)。conn:execute([[PRAGMA journal_mode=WAL;]])
Write-Ahead Logging 允許讀寫並行,顯著提升多讀少寫場景性能。
LuaSQL SQLite3 API 與 MySQL 高度一致,學習成本極低。選擇 SQLite 還是 MySQL 取決於部署架構、並發需求、數據量規模。嵌入式、桌面應用、本地緩存首選 SQLite;多用戶、高併發、大數據量選 MySQL。