PinnedAnatolii Zhadan·2d agoReading Postgres EXPLAIN ANALYZE when the planner expects 300 rows and gets 15,000A bad plan starts at the lowest node where expected and actual rows split, and every node above it is built on that wrong number.
PinnedAnatolii Zhadan·6d agoPostgres not using your index? It's counting pages, not rowsYou get a Seq Scan even with an index because the planner prices a query in pages, and a small table is cheaper to read whole.A response icon1A response icon1
PinnedInCoinsBenchbyAnatolii Zhadan·Jul 14How to Deploy a Self-Hosted 2-of-3 MPC Signing Cluster (Without Losing Everyone's Keys)A restored MPC cluster can boot up, report [READY] on all three nodes, pass every health check — and have silently lost every private key…
PinnedInCoinsBenchbyAnatolii Zhadan·Jul 6How to Store Your Users' Crypto Wallets So Nobody Can Steal ThemYour backend can decrypt every user's private key. So can your ENCRYPTION_KEY. So can whoever gets far enough into your servers: a leaked…
PinnedAnatolii Zhadan·Feb 29, 2024The Complete Guide to Full Stack Solana Development with React, Anchor, Rust, and PhantomFull starting guide to Solana Development 2024 with Anchor and ReactA response icon4A response icon4
Anatolii Zhadan·Nov 29, 2023Full Docker guide from 0 to proguide to Docker in practice with examplesA response icon1A response icon1
Anatolii Zhadan·Oct 17, 2023A Beginner’s Guide to Object-Oriented Programming in C++In this article, I will explain classes, objects, access modifiers, constructors, encapsulation, abstraction, inheritance, and…A response icon2A response icon2
Anatolii Zhadan·Jul 11, 2023How to deploy a Node.js app with a domainToday, I will show you how to put your Node.js app with a domain on hosting.A response icon1A response icon1
Anatolii Zhadan·Apr 13, 2023Creating a Library in C using a MakefileHello everyone, today I’d like to discuss how to create a library using a Makefile in C with some practical examples.A response icon2A response icon2