Shreyansh Guptashreyanshgupta.hashnode.dev·Nov 24, 2024Indexes in MySQLWhat is an index? An index is a - A separate data structure - It is separate from the actual table. A copy of (part of) our data - Whenever we add an index to any column or columns in a table, it copies a part of the data into the index table. Point...MySQL
Vivek Khatritech.peculiarvivek.com·Aug 17, 2024DDIA - Chapter 3 - Storage and Retrieval - (Part 2)Henlo frens We discussed till LSM-tree in the last blog, had to break it down into 2 cause this chapter has too much information. Many databases use B-trees, it has become the standard. LSM-tree and B-tree both keep the key value pair sorted, but bot...Databases
Arya Lanjewararyalanjewar.hashnode.dev·Feb 10, 2024How Database works under to hood. So you know which one to useSo, what's your intuition? The simplest database you can build uses a bash script to write data to a file and retrieve data from that file. If you need to update data, just append the updated data with the same key but a different value. Essentially,...4 likessstable
DataWisokadatawisoka.com·Sep 1, 2023Optimizing your Postgres: Indexing and Execution PlansQuery performance is a critical factor in the efficiency and scalability of any database-driven application. Whether you're dealing with a small web app or a large-scale enterprise system, slow queries can become bottlenecks that degrade user experie...PostgreSQL
Shivanagouda Agasimanishiva02.hashnode.dev·Jul 20, 2023Data Storage and Retrieval: Log-Structured and Page-Oriented Storage EnginesAs an application developer, you must give some thought to your choice of database best suited for your needs since you are not going to implement your storage engine from scratch. In order to make the choice, you should at least have a rough idea of...1 likeDatabases
Retrieverretriever.hashnode.dev·Jul 3, 2023BTreeSet in RustProblem: Binary Search Trees (BST) are theoretically optimal for sorted maps, but they're inefficient in practice. This is mainly due to each element being in its own heap-allocated node, leading to a heap allocation at every insertion and potential ...28 readsRust
JITPOMIblog.jitpomi.com·Jun 1, 2023Web Based Local First P2P Development with Holepunch's EcosystemMemorial Day was bliss for our team, we found a ward into a dimension of software development we'd all thought was fictitious before - The World of Local-first P2P software development on the web. A world where your data is yours despite the cloud, a...1 like·564 readspeer to peer
