Darsh Pateldarsh-patel.hashnode.dev·Jun 28, 2024What is the Raft Consensus Algorithm? A Simple GuideConsensus algorithms are crucial in distributed systems to ensure all the nodes agree on a common state, even when there are failures. One popular consensus algorithm is Raft. It is designed to be understandable and easy to implement. In this post, w...Discussraft
Shivanagouda Agasimanishiva02.hashnode.dev·Apr 17, 2024Problems with Replication LagLeader-based replication requires all writes to go through a single node, but read only queries can go to any replica. For workloads that consist of mostly reads and only a small percentage of writes (a common pattern on the web), there is an attrac‐...Discussdistributed system
Marco BambiniforSQLite Cloudsqlitecloud.hashnode.dev·Feb 29, 2024How (and why) we brought SQLite to the CloudSimplicity, efficiency, and reliability. For the last 24 years, these have been the guiding principles of the world’s most popular database engine, SQLite. SQLite was originally devised as a way for clients to talk directly to disk without the need f...Discuss·46 readsCloud
Dichen Lidichenli.hashnode.dev·Dec 11, 2023Strong Consistency On Asynchronous Read Replica Databases With Accurate ClockMy personal favorite for "what's new" from AWS re:invent 2023 was the announcement of the micro-second accuracy clock and ClockBound API. (There were other many exciting announcements too!) They brought two timely new features: micro-second accurate ...Discuss·1 like·446 readsDatabases
Shikhar BhushanProblog.schmizz.net·Nov 8, 2023The disaggregated write-ahead logThe traditional way replicated systems are architected is to physically co-locate the write-ahead log (WAL) on the nodes where the state is being maintained. Then a consensus protocol like Paxos or Raft is used to make sure the log on each replica ag...Discuss·2 likes·10.8K readsdistributed system
Gaurav Dhakgaurav789.hashnode.dev·Oct 21, 2023From Theory to Reality: How Google Spanner Challenges the CAP TheoremHi 🙌, I'm Gaurav, and I love understanding how computer systems work, especially when they're spread across different places. One big idea that's important for this is the CAP theorem. It was put together by a clever computer scientist named Eric Br...Discuss·1 like·114 readsSystem Design
Franck Pachotfranckpachot.hashnode.dev·Jun 29, 2023Indexing JSON in PostgreSQLIndexing JSON documents in PostgreSQL is similar to indexing relational table columns. Although the structure is not enforced at write time like normalized tables, we can still add indexes for our access patterns. In SQL, we index the values we selec...DiscussPostgreSQL
Franck Pachotfranckpachot.hashnode.dev·Jun 29, 2023when you have millions of insert statements in a file...Let's say you have a script of one million insert statements with literal values. Of course, this is a bad idea. SQL is a language, not a data exchange format. You should have a file to import with COPY, with all values as CSV for example. Or at leas...DiscussPostgreSQL
Gino Osahongino.hashnode.dev·Jun 23, 2023Fundamental Concepts on How IPFS WorksFundamental Concepts on How IPFS Works In this article, we will learn about the different stages of how IPFS works, the different protocols and tools/concepts like Chunking, IPLD, UnixFS, IPNS Multipart, and others that are used at each of the stage...Discuss·40 readsBlockchain
Marco BambiniforSQLite Cloudsqlitecloud.hashnode.dev·Mar 21, 2023Strong Consistency with Raft and SQLiteIn the recent past, a typical client/server environment consisted of multiple clients connected to a central database server. A central database architecture is a system where all data is stored in a single centralized location. When client A from Si...Discuss·9.2K readsSQLite
