Postgres plays Pokémon!
summary
A Postgres foreign-data-wrapper written in Rust Postgres extension exposes Pokémon Red’s in-emulator memory as tables so SQL queries read and write actual game state; it uses the PI Boy emulator, Protobuf/gRPC to shuttle 44‑byte Pokémon structs, and direct memory patches instead of fragile code‑execution via the missingno glitch. Demonstrations show running SQL like insert into inventory (id, quantity) values (57,10) to add items and editing stats to win fights. Emulator uses ~180MB, the Game Boy data layout is fixed, and the approach reliably manipulates gameplay.
AI-written summary · about
chapters (5)
- 0:00Introduction to Pokemon Red
- 1:21Emulator gameplay demonstration
- 3:34Architecture and data extraction
- 6:34Postgres and rust integration
- 8:16Inventory hacking and conclusion
related talks
31mPostgres without SQL: Natural language queries using GPT-3 & Rust
39mDeveloping a Postgres Extension in Rust
26mCan We Use Rust to Develop Extensions for PostgreSQL?
25mRuby and PostgreSQL, a love story
48mHow I found my Pokémon cards thanks to Postgres: an AI journey
25mData modeling with PostgreSQL at the core of Software Development
29mPostgres Demystified
26mCompiling Postgres to WASM with PGlite