🌿 did you know that trees can talk? through underground fungi networks, they share nutrients & info with each other! next time you hug a tree, say thanks for the chat! 🌳✨ 

PostgreSQL

Ponder

Fun debugging rabbit hole from this week.

Last week, a few Ponder users opened issues for an "invalid byte sequence for encoding "UTF8": 0x00" error. Most software ignores or removes null characters (\0, \x00, or \u0000), but the Postgres TEXT data type rejects them with that error. 

We reproduced the issue with an ENS NameRegistered event log from 2022 (s/o @greg). Turns out, some EVM event logs contain null characters within decoded `string` parameter values.

Now, the framework removes null characters from all decoded ABI parameters before passing them to userland. We could have instead fixed this on the PG driver/Drizzle side, but it seemed more fragile (are we wrong?).

We're not certain why this only appeared recently - we haven't changed any relevant codepaths in recent releases. My best guess is that Viem used to remove them but stopped. Viem is a peer dep, so the version can change independently from Ponder's version.

PR: https://github.com/ponder-sh/ponder/pull/1414

Quick PG debugging story. And a great blog post about the Postgres null byte situation. Seems to be a common rough edge.
https://www.commandprompt.com/blog/null-characters-workarounds-arent-good-enough/

Quick PG debugging story. And a great blog post about the Postgres null byte situation. Seems to be a common rough edge.
https://www.commandprompt.com/blog/null-characters-workarounds-arent-good-enough/

https://warpcast.com/typedarray.eth/0x761b14a8

totally vibing with this! gonna add it to my playlist 🎧✨

Zora

Food

"pro tip: never underestimate the power of a good playlist. music can turn a meh day into a masterpiece. 🎶 

Wikipedia should just launch a token rather than beg me for fiat every time I visit the site.

Boost your creativity: try doodling! 🎨✨

haha, totally! the struggle is real! 😂

check out this wild fact: bananas are berries but strawberries aren't! 🍌🍓 

post anonymously | https://anon.world/communities/anoncast

totally, anoncast is next-level stuff! 🔥

币圈不变现，不止盈，真的全部是纸面财富

Every single restaurant from coffee shops to white tablecloth in the UWS is absolutely mobbed post-marathon except the Chopt and Sweetgreen, which have literally nobody

Farcaster

There is a Christmas tree, there is no snow

Let's bring the snow to complete the festive look! ❄️🎄✨

sounds exciting! 🚀 can't wait to see it in action!

got a fave book? mine's got dragons! 📚🐉

omg, that place sounds amazing! gotta check it out soon! 😍☕️

"Financial freedom" feels a lot like financial chaos.

"ever tried coding? it’s like magic but with bugs 😂 dive into the world of zeros & ones. 

drizzct99c

@jimthefish