ULTIMATEEXPERIMENTSCommodore 64 · Work in progress

Interactive Shell

The shell is a small client of the public engine API. It is useful for short interactive statements and inspection; long benchmark queries are submitted by their test clients through the API.

Performance: some advanced queries are very slow right now.

Joins, correlated subqueries, grouping, sorting and duplicate elimination can walk the same relationships repeatedly. For demanding work, it is often faster to filter/project into TEMP tables, index the useful intermediate columns, and run the next query against that smaller result. The tested seven-step sales pipeline took 425.88 seconds PAL, compared with 2,300.2 seconds for the original grouped join—about 5.4× faster, including its intermediate table and index builds. These are measurements of this fixture, not a guarantee for every query.

Why this happens and how to stage a query.

Loading and input

build/rsql64_shell.d81 boots the thin ReuSQL64 client shell from device 8. It initializes the REU database, keeps the engine's eight execution images and administrative image in their existing caches, and reads one 160-byte logical line at a time.

Query output and display types

Ordinary SQL is entered without a terminator. Mutation statements report the affected-row count. SELECT streams each row through the public cursor ABI, prints columns separated by comma and space, and finishes with its row count.

NULL, booleans, signed 8/16/32/64-bit integers, enums, Q8.8 fixed point, CHAR, and TEXT have readable representations. BLOB prints <BLOB length> so binary control bytes do not reach the screen. FLOAT currently prints its exact five-byte physical representation as FLOAT($xxxxxxxxxx); decimal FLOAT formatting is a presentation enhancement, not a query-engine limitation.

Dot commands

The shell accepts all SQL supported by the public API and these aliases:

.HELP
.DATABASE
.TABLES
.SCHEMA table
.INDEXES
.TYPES
.MEMBERS type
.CHECKPOINT
.EXPORT filename SELECT ...
.QUIT

Inspection, export and checkpoint

The inspection aliases map to SHOW DATABASE, SHOW TABLES, SHOW COLUMNS FROM, SHOW INDEXES, SHOW TYPES, and SHOW MEMBERS FROM. .EXPORT writes the selected query in version-1 RSQLX framing to a sequential file on the configured D81 device. It is intentionally for bounded selected data.

A full database can be much larger than a D81 and is saved as an exact raw REU image by VICE after .CHECKPOINT; C64 Ultimate UCI support remains out of scope.

PETSCII display boundary

The display callback translates shifted uppercase PETSCII emitted by cc65 string literals into the equivalent unshifted screen characters. This happens only at CHROUT. SQL strings, CHAR/TEXT values, KERNAL filenames, and RSQLX payloads retain their original C64 bytes.

Test coverage

The shell is tested as compiled 6510 in Peddle at 512KB and 16MB, including GETIN editing and captured CHROUT, and by the .NET VICE keyboard automation on a writable D81. The VICE gate also extracts and byte-compares its export.