← Open Lab
// OPEN LAB

visualdb

Local app to build forms, sheets and reports over existing databases, no cloud.

Python 3.11+ · NiceGUISQLAlchemy 2.0PostgreSQL · MySQL · SQL Server · Oracle · SQLite · DuckDBMIT

A local monolithic application in the spirit of Visual DB: a single Python codebase (NiceGUI UI, SQLAlchemy Core 2.0 engine) that runs as a native desktop window or a web app on 127.0.0.1. Everything derives from a JSON query-spec: forms, sheets (Excel-like editable grid) and reports are just different renders of it. Supports PostgreSQL, MySQL/MariaDB, SQL Server, Oracle, SQLite and DuckDB; bound parameters everywhere (no SQL injection), writes only on the main_table, read-only lookup columns, secrets never in clear text. Features: optimistic locking, validation and computed columns, atomic master-detail, reports with grouping and subtotals, saved views (private/shared/locked), point-in-time HTML and Excel snapshots, schema/DDL management with review, webhooks, PostgreSQL row-level security and an NL→SQL AI assistant (read-only). MIT-licensed.

Resources

Code on GitHub ↗ Technical wiki → Blog article →

Other repositories

USBPD-Stack Cross-platform distribution of the NXP USB Power Delivery stack for the PTN5110. Details → x-cube-n6-camera-capture-nucleo Exploring the STM32N6: a UVC webcam with the hardware H.264 encoder. Details → arducam-evk-gui Tkinter GUI for the Arducam EVK SDK, sensor data-driven. Details → acmap Browser-based acoustic mapping: sound-level surveys + ISO 9613-2 propagation with Maekawa diffraction on real OSM buildings. Live tool at /en/tools/acoustic-map/. Details → noise-barrier-calc Noise-barrier attenuation calculator: ISO 9613-2 §7.4 + Maekawa selectable, line/area/point sources. Live tool at /en/tools/barrier-calculator/. Details → pffdtd (fork) Wave-based FDTD solver for room acoustics — fork with CUDA optimizations, a cross-validation reference for RaySound. Details →

A similar project?

Embedded, protocol, calculation tools: if you have a related use case, let’s talk.

Talk about your project ← Open Lab