YellowedPlasticSQL, ypsql for short, is a PostgreSQL client running natively
on the Commodore 64 using RR-net and IP65 for network access. It implements a
subset of the PostgreSQL wire protocol, with more support planned for future
updates.
The app is still under heavy development, it was written over the course of a weekend for the PostgreSQL project 30 year anniversary celebration at PGConf.dev 2026. It can log in using password, or trust, authentication and can issue queries. Errorhandling is still very limited but will be improved.
Queries are not ended with semicolon as that is hard to type on a C64 keyboard, the code will inject the semicolon as needed. The query will is sent with ENTER.
Unlike psql ypsql use : instead of backslash for the metacommands since
it's a lot more convenient on a C64 keyboard. The available metacommands are:
| Command | Description |
|---|---|
| :clear | Clear the screen |
| :help | Print helpscreen |
| :host | Print address and port of server connected to |
| :quit | Logout and quit |
| :watch | Run last query every 1s |
- Working ASCII ot PETSCII conversion
- Pretty table printing using PETSCII characters
- Improved errorhandling to handle misformed queries
- Code optimization
- MD5 Password auth using md5_6502
- SCRAM authentication using sha256_6502 and 8-bit sha1 for HMAC.
- Split up the code in libpq and app code for easier porting to Apple II
YellowedPlasticSQL use the PostgreSQL license which is an OSI approved license. See LICENSE for full details.