I give that an A+ for perseverance, but I would have hoped to see something that uses the strengths of SQL more.

For example, there could be a table with the decode ROM (https://www.cpcwiki.eu/index.php/MOS_6502#The_Decode_ROM_.28...) that could be used to drive the logic.

Have a main loop that uses the inputs of that ROM to look up the output bits and update a table, and add triggers that handle each “micro-op”. A SQL engine could run those triggers in parallel until they hit a race condition, but those can be avoided a bit by having separate tables for each register.

Even better would be if there were tables with every logic gate and wire in the original CPU, using a trigger to move the signals around. That would be a good test of the trigger handling in a SQL engine.

https://notes.eatonphil.com/exploring-plpgsql-forth-like.htm...

But I'd love it if it could run in SQLite3. The stored functions and procedures here are neat, but I wonder if they could be turned into views and combinations of built in functions...

I think triggers can do nearly everything that a stored procedure does, perhaps with a little bit more fiddling. I sometimes make "parameter tables" where I insert all the necessary data and a trigger does what effectively a stored proc does.

Maybe there'd need to be a few imported functions? I wonder if an AI could be persuaded...

https://t3x.org/t3x/0/sim65kit.html

https://t3x.org/kimuno/

Pocket calc as 6502 code

https://t3x.org/kimuno/kimcalc.html

T3x0 compiler to build the emulator:

https://t3x.org/t3x/0/index.html

I've got to run under OpenBSD/i386 but it needs a bit of tweaks in the Makefile. On the target section:

    # CFLAGS=$CFLAGS" -m32"                 # on x86 64-bit systems 
    CFLAGS=$CFLAGS" -static"                # in case all else fails
    CFLAGS=$CFLAGS" -fPIC"          # get rid of stupid linker errors
    CFLAGS=$CFLAGS" -Wl,-z,notext"  # get rid of stupid linker errors
    CFLAGS=$CFLAGS" -fno-PIE -no-pie"       # get rid of stupid linker errors

Also, T3XBIN it's set to BINDIR= /usr/local/t3x/bin

Then I ran:

      sh bin/modpath.sh /usr/local/t3x/lib 
      gmake all-native
      doas gmake install-native install-modules

TX3DIR is above, and ditto with the four CFLAGS flags I posted.

Just the ones at lines 38-42.

OFC set PATH to /usr/local/t3x0/bin:$PATH in ~/.profile:

        export PATH=/usr/local/t3x0/bin:$PATH

      'tx0 foo' 

This was compiled under an Atom n270 CPU based netbook. I think the author uses a Pentium III machine. If T3X0 can do a MOS 6502 emulation that well, you can try expanding s65/sim65 to cover the Apple I emulation.

And, as a plus, it might run fast on DOS 386 machines if s65/sim65 it's compiled a native binary.

Next step : insert the Applesoft Basic assembly code and allow programming in Basic through SQL