User Files from Sand

• The SQL module only supports having one global database open at a time. This module simulates support for opening multiple databases concurrently, by storing a filesystem path in a database handle structure and re-opening the required database before every query.
• Converts the various magic strings that the SQL module may return, like "No rows found" and "query is empty", into regular Lua values and error returns.
• Converts result sets from a "coordinate-oriented" format, where table keys are an amalgam of the row and column, to a "row-oriented" format, where a top-level sequential table contains rows, and each row is a key–value table where keys are column names.

local sqlite = require("sqlite")
local db = sqlite.open("example.db")
assert(db:execute(
[[CREATE TABLE IF NOT EXISTS lag (
	frame INTEGER NOT NULL,
	islagged INTEGER NOT NULL
) STRICT]]))
assert(db:execute(string.format(
	"INSERT INTO lag VALUES (%s, %s)",
	sqlite.escape(emu.framecount(), emu.islagged())
)))

pandoc -f markdown -t tasvideos_forum.lua input.md

go e
go s
go e
open window
go in
go u
go u

s.e.open.in.u.u
[Plus an extra Return to dismiss a [MORE] prompt.]

• Omitting the initial go e command that tries to move into the blocked front door.
• Removing all go. For example, s does the same as go s and is shorter.
• Shortening open window to open. The object of the command is implied.
• Putting all the commands on one line, separated by .. This doesn't make YOU HAVE DIED arrive any quicker, but it allows ending input early. The large amount of output produced by the combined commands requires buffering an additional press of Return to dismiss a [MORE] prompt that appears, but that can be done immediately after entering the commands.

• 2 frames moving from 'd' to 'g' in "Wedg"
• 1 frame moving from 'A' to 'x' in "Axe "
• 2 frames moving from 'e' to ' ' in "Axe ".

1. Pause the emulator.
2. Reset the emulator.
3. Start recording a movie.
4. Load the script/main.lua script.
5. Unpause the emulator.
6. Wait for the emulator to pause again.
7. Stop recording the movie.