# Tobbe (@tobbe.dev)

Profile: https://sifa.id/p/tobbe.dev

## Talks & sessions

### [@live GraphQL in Practice: Postgres-to-React Realtime Data Sync](https://sifa.id/p/tobbe.dev/talk/live-graphql-in-practice-postgres-to-react-realtime-data-syn-3mp5zjmucni2t)
_20 min · developers_
We built a real-time system for Postgres→React sync using a `LISTEN/NOTIFY` Postgres trigger, GraphQL `@live` queries, a React hook and a custom ORM-inspired GraphQL query builder. Starting from ESP32 microcontroller devices sending MQTT messages and a Node/Postgres backend, we moved from polling to a stand-alone PoC with Yoga, Prisma triggers, and a custom `useLiveQuery` hook. After proving that the PoC was working we integrated with all our existing full-stack apps. So now we have low-latency UI updates, reusable cross-app logic, and easier extension for new sensor values. Great UX and excellent DX.
 
TOC 
 
\- Title & minimal intro
\- Goals (What We Needed)
\- Existing System (What We Had)
\- Attempts & Why They Failed
\- Solution Overview 
\- Postgres `LISTEN/NOTIFY`
\- `useLiveQuery` React hook
\- Yoga and Apollo `@live` integration
\- GraphQL query builder
\- GraphQL SDL generator
\- GraphQL resolver generator
\- Demo / Results
\- Tradeoffs, Lessons & Next Steps
\- Q&A

## Publications

- Publish to the Atmosphere — tlundberg.com (Jul 2026) https://tlundberg.com/blog2026-07-15-publish-to-the-atmosphere/
- Sätteri and Expressive Code — tlundberg.com (Jul 2026) https://tlundberg.com/blog2026-07-08-satteri-and-expressive-code/
- Classless CSS Styling — tlundberg.com (Jul 2026) https://tlundberg.com/blog2026-07-07-classless-css-styling/
- Deploying to GitHub Pages — tlundberg.com (Jul 2026) https://tlundberg.com/blog2026-07-04-deploying-to-github-pages/
- Migrating off Hashnode — tlundberg.com (Jun 2026) https://tlundberg.com/blog2026-06-29-migrating-off-hashnode/
- Setting up Mastro — tlundberg.com (Jun 2026) https://tlundberg.com/blog2026-06-26-setting-up-mastro/
- Hosting a Verdaccio NPM Registry on Hetzner Cloud Part 4: Verdaccio — tlundberg.com (Apr 2024) https://tlundberg.com/blog2024-04-27-hosting-a-verdaccio-npm-registry-on-hetzner-cloud-part-4-verdaccio/
- Hosting a Verdaccio NPM Registry on Hetzner Cloud Part 3: nginx — tlundberg.com (Apr 2024) https://tlundberg.com/blog2024-04-26-hosting-a-verdaccio-npm-registry-on-hetzner-cloud-part-3-nginx/
- Hosting a Verdaccio NPM Registry on Hetzner Cloud Part 2: Adding a User and Securing the Server — tlundberg.com (Apr 2024) https://tlundberg.com/blog2024-04-24-hosting-a-verdaccio-npm-registry-on-hetzner-cloud-part-2-adding-a-user-and-securing-the-server/
- Hosting a Verdaccio NPM Registry on Hetzner Cloud Part 1: Buying a VPS — tlundberg.com (Apr 2024) https://tlundberg.com/blog2024-04-24-hosting-a-verdaccio-npm-registry-on-hetzner-cloud-part-1-buying-a-vps/
- WebSockets in RedwoodJS — tlundberg.com (Oct 2022) https://tlundberg.com/blog2023-02-25-websockets-in-redwoodjs/
- Using RedwoodJS as a Static Site Generator — tlundberg.com (Jul 2022) https://tlundberg.com/blog2022-07-31-using-redwoodjs-as-a-static-site-generator/
- Visualizing your Prisma schema in a RedwoodJS project — tlundberg.com (Jul 2022) https://tlundberg.com/blog2022-07-08-visualizing-your-prisma-schema-in-a-redwoodjs-project/
- Migrating data with prisma migrate — tlundberg.com (Nov 2021) https://tlundberg.com/blog2021-11-28-migrating-data-with-prisma-migrate/
- Adding Google Maps to your RedwoodJS App — tlundberg.com (Oct 2021) https://tlundberg.com/blog2021-10-13-adding-google-maps-to-your-redwoodjs-app/
- Moving to hashnode from my custom Gatsby blog — tlundberg.com (Oct 2021) https://tlundberg.com/blog2021-10-13-moving-to-hashnode-from-my-custom-gatsby-blog/
- Deploying a RedwoodJS app on Dokku — tlundberg.com (Mar 2021) https://tlundberg.com/blog2021-03-29-deploying-a-redwoodjs-app-on-dokku/
- Building a RedwoodJS Signup Form with Validation — tlundberg.com (Mar 2021) https://tlundberg.com/blog2021-03-06-building-a-redwoodjs-signup-form-with-validation/
- Using Github Flavored Markdown in the Netlify CMS Preview Pane — tlundberg.com (Feb 2021) https://tlundberg.com/blog2021-02-11-using-github-flavored-markdown-in-the-netlify-cms-preview-pane/
- Switching to Another GraphQL Client in RedwoodJS — tlundberg.com (Jan 2021) https://tlundberg.com/blog2021-01-18-switching-to-another-graphql-client-in-redwoodjs/
- Using RedwoodJS to download protected files from an Amazon S3 bucket — tlundberg.com (Nov 2020) https://tlundberg.com/blog2020-11-28-using-redwoodjs-to-download-protected-files-from-an-amazon-s3-bucket/
- Redwood Pagination Tutorial — tlundberg.com (Sep 2020) https://tlundberg.com/blog2020-09-15-redwood-pagination-tutorial/
- Running specific tests in RedwoodJS core — tlundberg.com (Jun 2020) https://tlundberg.com/blog2020-06-21-running-specific-tests-in-redwoodjs-core/
- Installing rsync on Windows — tlundberg.com (Jun 2020) https://tlundberg.com/blog2020-06-15-installing-rsync-on-windows/
- Getting something new and fresh up — tlundberg.com (Jun 2020) https://tlundberg.com/blog2020-06-13-getting-something-new-and-fresh-up/

## Links

- bsky: https://bsky.app/profile/tobbe.dev
- github: https://github.com/Tobbe