A trick to silence annoying React warnings
A trick to silence annoying React warnings
Turfemon
A blog about blockchain, Ethereum, and web development
Latest posts
Adding a Postgres kill-switch for firefighting
Learn how to create a Postgres kill switch to terminate database connections during emergencies. Solve the common 'connection slots reserved' problem with a dedicated terminator user and always-on connection. Includes SQL setup and a ready-to-deploy solution
How to manage a million dollars on Solana with Cloud KMS
Learn how to securely manage a million dollars on Solana using Google Cloud KMS for key management. This guide walks you through setting up a keypair with ED25519 signing, ensuring private keys are never exposed. Ideal for high-value transactions and sensitive operations.
Solana vs Ethereum for relaying transactions
In this post, we'll explore how Solana handles relayer transactions differently compared to Ethereum (EVM). We'll dive into the concepts of recent blockhashes and how they prevent double spends while allowing for parallel transaction execution.
Pings and pongs in WebSocket — There are two different types!
When building a real-time WebSocket server you often use a ping and pong message to verify that the connection is still open. But there are two common patterns used, one on the protocol and one in the application.
Scaling Websockets beyond 23K connections
Scaling Websockets beyond 23K connections
My go-to instant Caddy setup
My go-to instant Caddy setup
Scaling Websockets - Hitting a limit at 23K connections
This is me trying to deploy a Websocket server, but for some reason I hit a limit at 23K connections
How to Make a Datadog Clone in a Weekend
It is easier than ever to spin up your own custom observability solution. This is how I did it to create a customized view for slow postgres queries.
What I wish I knew about Cloudflare two years ago
What I wish I knew about Cloudflare two years ago
Batch-sending ERC-20 tokens
Discover how to batch-send ERC-20 tokens efficiently, reducing gas costs and optimizing transactions. Learn why batching is cost-effective, how to use a Gnosis Safe for batch-sending, and how to further optimize your own token for batch transfers. This guide provides practical examples and insights into the ERC-20 token batching process
Pre-calculate IPFS CID hashes for Pinata, Thirdweb, etc…
Pre-calculating ipfs cid hashes is a great way to improve performance. Here I detail how to do it and mimick the cid hashes generated by pinata, thirdweb, etc…
Storing large Ethereum numbers in Postgres
Should you store large Postgres numbers as bigint, text, varchar, real, double precision, decimal etc? Turns out there is no perfect solution, but this article discusses the different ones with their trade-offs.
DBT Incremental export to S3
Description
Rename Tables and Columns in Postgres with Zero Downtime
It’s not painless, but totally possible to rename a table or a column with zero downtime
Tightly packing Ethereum event logs
Tightly packing Ethereum event logs to save space and gas costs is a good idea, but in practice it's harder to do than you would think.
Snowflake vs Clickhouse for tracking event data
Snowflake vs Clickhouse for tracking event data
Undici proxyAgent with an authenticated HTTP proxy
Undici is a modern http framework for node, and is used under the hood in many libraries like
Finding the best provider for CDN IPFS Resized Images
Finding the best provider for CDN IPFS Resized Images
Cache Static Assets with NextJS using CDN and Cache Headers
Static assets should ideally be cached by a CDN. This post shows how to configure it for NextJS