Ankan Sahaaxiodb.hashnode.dev·Nov 2, 2024Introducing AxioDB: A Lightweight, JSON-Based Open-Source DBMS for Modern DevelopmentIntroductionEvery developer needs a fast, flexible, and easy-to-use database for managing JSON data. Existing solutions often have complex setups or require unnecessary overhead for small to medium-scale applications. That’s why I created AxioDB—a JS...46 readsDatabases
sathwikreddy GVsathwikreddygv.blog·Sep 25, 2024Sharding vs Partitioning: What’s the Difference?Introduction In a recent interview, I was asked about the difference between Sharding and Partitioning in the context of databases, and I couldn't answer properly. In this blog, we will learn what are they and the difference between them. Why “Shard ...sharding
Vivek Khatritech.peculiarvivek.com·Sep 15, 2024DDIA - Chapter 6 - Partitioning - thoughts and notesCool, so how do you replicate huuuuuge databases? Well, you don’t. You partition them and then replicate. So we are just adding additional complexity to an already complex system? Oh, Yes. It will be fun. Partitioning is important for efficiently sca...Databases
Saarthak Mainisaarthakmaini.hashnode.dev·Sep 14, 2024Indexing in DatabasesWhen working with databases, performance is often a key concern, especially as data grows in size. Efficient data retrieval becomes critical for applications that demand quick query results. One of the most effective ways to enhance database performa...Databases
Rajat Srivastavastackup.hashnode.dev·Sep 11, 2024Guide to Sharding and Partitioning in Relational DatabasesIntroduction As databases grow in size and complexity, managing and querying large volumes of data becomes more challenging. Two popular techniques to address these challenges are partitioning and sharding. Both methods involve breaking down data int...Database Scalability
Nicholas Diamondnicholasdiamond.hashnode.dev·Aug 16, 2024Optimizing Database Performance in Backend Systems with Indexing, Partitioning, and CachingDatabases are the backbone of most backend systems, and their performance directly impacts application speed and scalability. Poor database performance can lead to slow queries, high latency, and an overall degraded user experience. By leveraging tec...backend
DataWisokadatawisoka.com·Jul 8, 2024Choosing the right database: Large scale data growth in Postgres vs DynamoDBAs applications grow, so does the volume of data they generate and manage. Whether you're building a social media platform, an e-commerce site, or a data-driven analytics tool, handling large-scale data growth is a challenge that can make or break yo...choose the right databse
hai nguyenhainguyen.hashnode.dev·Jun 16, 2024Understanding Consistent Hash Ring: A Simple ExplanationProblem 1: We have a set of servers and need to distribute data and requests to those servers in a manageable, uniform way. If the data size increases (or the number of requests we need to serve increases), we can add or remove servers from the clust...distributed system
Ian Carsoniancarson.hashnode.dev·Jan 15, 20245 Database Lessons I learnt the hard way.Some of the lessons and patterns that are called standards or best practices, came as result of several years of experiences and in some cases, studies. I have had my fair share of tough lessons that I learnt the hard way. Below are a couple of the l...Databases
Kiều Tâm Đỉnhleonardkieu.hashnode.dev·Dec 29, 2023[PostgreSQL Scaling and Optimization] How to search on 10 GB data (1 million rows) within 5 ms?Warning This article will help you to make a full text search API on PostgreSQL - a kind of text and retrieval problem. Nowadays, in large-scale system, people usually decouple write-heavy DB and read-heavy DB, not one for all. Example: using Postg...1 like·299 readsComputer SciencePostgreSQL
![[PostgreSQL Scaling and Optimization] How to search on 10 GB data (1 million rows) within 5 ms?](https://cdn.hashnode.com/res/hashnode/image/upload/v1703854595422/51864952-389f-4c28-bcff-97f85bcd4fa0.jpeg?w=1600&h=840&fit=crop&crop=entropy&auto=compress,format&format=webp)