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 readsDatabases
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·381 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·1 like·10.1K 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·54 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
Amit Himaniblog.knowledge-cafe.dev·Feb 6, 2023Under the Hood: Understanding the Gossip Protocol in Apache CassandraApache Cassandra is a highly scalable and distributed NoSQL database management system designed to handle large amounts of data across many commodity servers. It was developed at Facebook and later became an Apache Software Foundation project. Cassan...DiscussGenericCassandra
M B A R Kmbarkt3sto.hashnode.dev·Jan 25, 2023What is a Distributed System?Definition A distributed system is a collection of independently running computer systems that are connected through a network, with the goal of achieving a common goal or providing a common service. These systems work together as a single, unified s...Discuss·61 readsdistributed system