Leader Election with PostgreSQL

What is leader election? A common scenario where leader election is needed is running scheduled (cron) jobs in a backend service that has multiple instances. If you have just one instance, life is simple — that instance runs all the jobs. But when you scale horizontally and run multiple instances, you want to make sure that a scheduled job runs only once, on one leader instance — not duplicated across all instances. This is where leader election comes in. ...

May 8, 2025

Solana Login Flow

https://stillearly.io/article/how-to-login-to-supabase-with-solana/

April 13, 2025

Solana dApp Architecture

Backend Architecture Data Flow The backend provides data to the frontend via an API, with its primary responsibility being indexing blockchain data, such as transactions. To achieve this, the indexer continuously queries the Solana blockchain and stores the relevant data for efficient retrieval. Why Indexing? The Need for Indexing Raw blockchain data is not optimized for fast queries. Without indexing, fetching relevant information directly from the blockchain is inefficient because: ...

March 28, 2025