MBEESQL.MWB - Connecting a microbee program to the world

[fathertedcrilly]

(SQL, or Structured Query Language, is the standard used by database systems for over 20 years worldwide, to store, retrieve and manage structured data.)

Originally I wrote a SQL demo program and then thought why not make it actually do something useful.

MBEESQL is a relational database engine written in MicroWorld BASIC for the MicroBee Z80 running CP/M. It implements four fundamental SQL database operations known as CRUD — Create (INSERT), Read (SELECT), Update (UPDATE) and Delete (DELETE) — along with WHERE clauses for filtered searching, primary key management, and a VACUUM command to compact the database by removing deleted rows.  MBEESQL brings these concepts to the Microbee, emulated using UBEE512. The BASIC program stores its data in DBMWB.DAT — a plain comma-delimited text file cataloguing the MicroWorld BASIC programs from the MBUG disk library by name and disc nos. RAM constraints prevent listing what each program does.

it'd be interesting to see how you've modelled your data structures.

Given the relative paucity of what is available in basic

Thanks
Tony