PWV Portfolio Feed

This is so wild btw

Yes, already >50% of tickets gone!

If you're using Postgres, you don't need a separate database to deal with documents.

JSONB in Postgres gives you document-store flexibility + ACID compliance + fast GIN indexes, all without adding complexity to your stack.

You don't need to split your data across DBs when PG already solves it ✌️

Now let's say there's some other systems operating which are responsible for making the database write for new messages. 

When they do, those new messages will go to our screen immediately 🙌

The key in the `streamNewMessages` function is that we're looking for any events with a type of `create` and then emitting the data from that event (using `event.created`).

Now we can pick this up in the client and set new messages to be rendered 👀

At this point, we're able to receive events that happen when changes occur in our database 🎉

But we're not yet set to have them automatically show up in the browser when new messages come in.

Next, extend Prisma Client to use Prisma Pulse.

We can use the `extends` method for this and pass `withPulse` to it.

Once that's in place, grab the Prisma Pulse extension from npm.

Copy over the `DATABASE_URL` and `PULSE_API_KEY` to the .env file in your Next.js project.

🧵 Let's build a quick realtime inbox with @nextjs and Prisma Postgres

an ai agent that runs on your desktop and has its own cursor and constantly sabotages your work, writing 'later nerds' at the end of emails right before you hit send, closing windows randomly, signing up for online games and doing all the in-app purchases

impersonation system not working well