Building a Realtime "Backend in a Box" with PostgreSQL and Vue
summary
Built a prototype called Velzy that provides a backend-in-a-box using PostgreSQL JSONB, Express/Node, GraphQL, socket.io and a Vue/VueX client; realtime updates come from LISTEN/NOTIFY pub/sub and lightweight triggers so the DB pushes changes directly to clients. Functions in PL/pgSQL execute dynamic SQL to create tables, triggers and lookup columns on the fly, auto-generate tsvector full‑text indexes (and use websearch_to_tsquery), and deploy via Docker/Azure; it’s pre‑alpha but the demos show it working end-to-end.
AI-written summary · about
chapters (4)
related talks
30mPostgreSQL & NodeJs as Core Feature of Backend for Frontend
24mThe Upsidedown Stack: React on the Server and Postgres in the Browser
43mEmbracing the Web with JSON and PLV8
45mBuilding Scalable APIs: PostgreSQL Meets GraphQL
47mMeet Your New BFF: Backend to Frontend without the Duct Tape
20mLeveraging PLV8 in Javascript heavy Web Applications
01h 12mWorkshop: Postgres for Frontend Developers (Part 1)
53mModern PostgreSQL for AI...