Building an OSS Postgres GUI with Typescript
summary
An open‑source Postgres GUI called DBLens (https://github.com/dblens/app and dblens.app) is a cross‑platform Electron client written in TypeScript/JavaScript with Tailwind and a Node IPC main, launched Oct 2021 and hitting ~227 Product Hunt upvotes. It visualizes disk utilisation per table and index usage, surfaces sequential scan counts, long queries and records‑per‑table trends, generates entity‑relationship diagrams on connect, and plans recording of metrics for trend analysis and a server mode.
AI-written summary · about
chapters (7)
- 0:00Introduction
- 1:32Postgres popularity
- 2:55DB Lens features
- 5:24Database exploration demo
- 7:28Tech stack overview
- 8:32Open source roadmap
- 9:15Q&A
related talks
51mBuilding a Realtime "Backend in a Box" with PostgreSQL and Vue
24mThe Upsidedown Stack: React on the Server and Postgres in the Browser
01h 12mWorkshop: Postgres for Frontend Developers (Part 1)
26mCompiling Postgres to WASM with PGlite
17mA new trend for databases: Platforms
51mExploring Postgres Databases with Graphs
43mEmbracing the Web with JSON and PLV8
30mPostgreSQL & NodeJs as Core Feature of Backend for Frontend