You can use in-:memory: Database by using the string
":memory:"Database.constructor(file) constructor
The Database constructor returns a Database value representing a SQLite database.
Parameters
file
A string or a File representing an SQLite database.
Example
local sqlite = require "sqlite"
-- Create an in-:memory: database
local db = sqlite.Database(":memory:")