PocketSQL — keyboard-first SQL editor for the small screen
lukacasey's lightweight web UI and API for running ad-hoc queries against MariaDB/MySQL, built around the uConsole's screen, keyboard and ARM64 footprint.
What it takes
- Software only
Difficulty 1 of 3 — easy.
Details
Written because no SQL editor worked well on the uConsole: a .NET backend (PocketSqlApi) with a Node.js front end (PocketSqlUI) — clone from GitHub, dotnet restore and npm install, then database credentials in appsettings.json. It targets MariaDB and MySQL, keeps the interface compact and drives everything from the keyboard, which matters when the trackball is your only pointer. Development resumed in July 2026 with browsing of stored procedures and views.
Links
Open at Forum thread- GitHubRepository
Related mods
Run a Meshtastic node on the console itself: meshtasticd drives the AIO's SX1262 over SPI, with the graphical MUI, the web UI or the Contact TUI client on top.
On Rex's images a single apt install gives you SDR++ for the AIO's RTL-SDR or a USB dongle; his AIO package adds the sdrpp-brown fork.
Rex's ClockworkPi-RetroPie image (Pi-Gen, EmulationStation, RetroArch) is the working answer; the Debian install and gamepad threads fill in the rest.
jutleys booted a prepared Windows 95 disk image in RetroArch's DOSBox-X core with working mouse buttons; plain DOSBox on the A-06 needs output=opengl to behave.
Two receivers, two recipes: the 4G card's GNSS via AT+CGPS on /dev/ttyUSB3, or the AIO's GPS on the serial port (/dev/ttyS0 CM4, /dev/ttyAMA0 CM5) at 9600 baud.
The AIO's PCF85063A keeps time off-grid once the right overlay is in config.txt — and on a CM5 the built-in fake RTC has to be switched off first.