读取和写入图像到SQLite DB供iPhone使用

guard let image = UIImage(named: "your_image_name") else { return }
guard let imageData = image.jpegData(compressionQuality: 1.0) else { return }

CREATE TABLE IF NOT EXISTS images (id INTEGER PRIMARY KEY AUTOINCREMENT, image_data BLOB);

let db = try! Connection(dbPath)
let insertStatement = try! db.prepare("INSERT INTO images (image_data) VALUES (?)")
try! insertStatement.bind(1, imageData)
try! insertStatement.step()

let queryStatement = try! db.prepare("SELECT image_data FROM images WHERE id = ?")
try! queryStatement.bind(1, 1)
let imageDataFromDB = queryStatement.columnBlob(0)
let imageFromDB = UIImage(data: Data(imageDataFromDB))