Using Postgres to \watch Star Wars!
summary
A complete pipeline loads Simon Jansen’s Episode IV 2 megabytes of ASCII frames into a table, parses groups of 14 lines per frame, stores them with an auto increment sequence, and uses PG_SLEEP for timing plus psql \watch loop to rerun a display query. It uses Postgres sequences as a frame counter, handles non‑UTF8 quirks, and actually plays Star Wars in the terminal; \watch lands in Postgres 9.3 (2013) and the demo works.
AI-written summary · about
chapters (13)
- 0:00Intro
- 0:37Brief
- 1:06Simon Jansen
- 1:30Compression
- 1:58HTML
- 2:35Table
- 2:53Extract Transform
- 3:52Add to Postgres
- 4:14Sleep
- 4:58Sequences
- 5:50Watch
- 6:34Postgres
- 7:02Watch Star Wars
related talks
20mUsing psql to \watch Star Wars And other silly things!
51mWhen Postgres Can't, You Can!
45mSELECT 'amazing_features' FROM "postgresql"
51mHow does PostgreSQL actually work
49mProfessional PostgreSQL monitoring made easy
56mPostgreSQL at low Level: stay curious!
42mProfessional PostgreSQL monitoring made easy
34mSimple and Awesome Database Tricks