SHUBHADIP BHOWMIKshubhadip.hashnode.dev·Dec 8, 2023Difference between PostgreSQL and MySQL1. Introduction: PostGreSQL and MySQL, both being open-source and relational database management systems, have garnered immense popularity and trust within the tech community. While their core purpose remains similar—to efficiently manage and manipul...DiscussMySQL
Pragya Srivastavaitspragya028.hashnode.dev·Dec 3, 2023SQL Interview Preparation: Last Hour1: Basic SQL Questions- What is the purpose of the SQL WHERE clause? Answer: The WHERE clause filters rows in a SQL query based on a specified condition. It is commonly used in SELECT, UPDATE, and DELETE statements. sqlCopy code-- Example: R...Discuss·10 likesSQL
Anthony Bosekdeveloperant.hashnode.dev·Nov 30, 2023Understanding DatabasesAs a developer learning to build full-stack applications, one of our most important early decisions is selecting the right database management system (DBMS). This under-the-hood software handles the complex task of storing, organizing and managing ac...DiscussDBMS
Ahmed Rezaahmedreza.hashnode.dev·Nov 25, 2023The Evolution of Data StorageIn the digital age, data is the new gold. Whether it's managing a small business's inventory or handling global-scale transactions, databases are the backbone of storing, organizing, and retrieving information efficiently. Let's take a deep dive into...Discuss·1 likeDatabases
Sebinsebzz.hashnode.dev·Nov 18, 2023Understanding PaginationPagination, the process of dividing a large set of query results into manageable chunks or pages, is a crucial technique in web development and database management. Particularly useful when dealing with large datasets, pagination ensures that loading...Discuss·6 likesSQL
Dominik KellerforLow-Code Software Engineeringfive.hashnode.dev·Nov 13, 2023Modern Database Management ExplainedDatabases play a pivotal role for businesses, serving as the backbone of countless applications, websites, and internal processes. As the world continues to generate vast amounts of data, the efficient organization, storage, and retrieval of this dat...DiscussDatabases
Komal Kumariclouddiva.hashnode.dev·Nov 13, 2023What is attribute , tuple , horizontal and scaling in RDBMSRelational database A relational database is a data structure that allows you to link information from different ‘tables’ or different types of data buckets. Tables are related to each other All fields must be filled. Best suits for OLTP (Online ...Discuss·29 readsAWS
Ayush Kumar Singhayushkumarsingh.hashnode.dev·Nov 9, 2023Introduction to Database Management SystemDatabase Management Systems (DBMS) are software systems used to store, retrieve, and run queries on data. Before studying DBMS we should know what exactly is this data and how it is different from the information. Data: Data is an unprocessed set of ...DiscussDBMSDBMS
Samuel Nwankwosaminwankwo.hashnode.dev·Nov 7, 2023Pagination in GraphQL: Exploring Node.js and MySQL ImplementationImplementing pagination in a GraphQL query using Node.js and MySQL involves breaking down the query results into smaller chunks or pages. Here's a step-by-step guide on how to achieve this: Setup Your Environment: Make sure you have Node.js and the...DiscussNode.js
Siddhartha Khuntiasidkhuntia.hashnode.dev·Nov 2, 2023What is a B+tree?These are self-balancing data structures used to search, sequential access, insert, and delete data quickly. You might be wondering binary search of the ordered list is also quick, but here is the thing suppose if the array size is 1,000,000, then th...DiscussDBMS
