369 Stories To Learn About Database

Let's learn about via these 369 free stories. They are ordered by most time reading created on HackerNoon. Visit the to find the most read stories about any technology. Database /Learn Repo 'A database is an organized collection of data stored and accessed electronically from a computer system' 1. An Intro to Resiliency, DHT, and Autonomous Economic Agents According to the paper published by Lokman Rahmani et al., the S/Kademlia distributed hash table (DHT) used by the ACN is resilient against malicious attacks. 2. How to Сompress a mysqldump Backup Using Gzip What is mysqldump? 3. How Useful is PostgreSQL Full Text Search PostgreSQL is the jack of all trades when it comes to databases. It brings you all the features you've come to love about SQL plus a bunch of features from Non-SQL databases. Some of these Non-SQL features like the JSONB data type are wonderful and you don't even have to dare flirt with another database. Others are good but not as robust and featureful as other databases. 4. How to Erase Expired Docs Automatically with MongoDB (TTL index) Recently I needed to delete some documents that I saved in MongoDB after some time. I can think of a few examples of why we would want to delete data after some time: 5. The Difference Between JDBC, JPA, Hibernate, and Spring Data JPA Connecting a database to a Java application is not an easy process. You need to consider the connection pool, the data access layer, etc. 6. How to Build a Data-Driven Product Using Metabase Metabase is a business intelligence tool that lets you access your data in a read-only manner. 7. Assessing Your Organization's Customer Data Maturity Investing in customer data is a top priority for marketing leaders. 8. Create and Execute Stored Procedure in PHPMyAdmin First of all what is Stored Procedure? 9. How To Create and Load Test Data in PostgreSQL Learn what tools and approaches are available to create and load test data for webapps without an ORM. 10. How SQL Database Engine Work For now, I am assuming that you all know what is SQL or you have some experience with SQL or you are using SQL for many years. I know many people who know so much about SQL and even have created many projects based on SQL and they do not know what is SQL engine or how actually SQL database engine works. It’s obvious no one’s care about the internal working of SQL engine or something because without knowing How SQL works we can still create and access database using any SQL program. 11. 6 Months Of Using GraphQL Having worked on a project for 6 months using GraphQL on the backend, I weigh up the technology’s fit into the development workflow 12. SQLite vs Realm: Which Database to Choose in 2021? Image a situation wherein you have just launched your app. But the data of your app is not being properly displayed or you are not able to fetch the data that is being entered by the users. What will be the impression of your app in the user’s mind? 13. Augh, Someone deleted production data. “A man stretching out his two hands with careless written on them in black and white” by Mitchel Lensink on Unsplash 14. Your Guide To Schema-based, Multi-Tenant Systems and PostgreSQL Implementation There are several architectures that could be followed to achieve multi-tenancy at the database layer. 15. Setting Up a Backend for React App in 15 Minutes Recently I have introduced Directual on Hackernoon (see Low-code for hackers). Now I would like to continue with absolutely practical post. First, I will show the general scheme of combining Directual and React, and then you will find the live-demo of building an app from scratch to production-ready Docker-container. 16. How to Solve Race Conditions in a Booking System Race conditions in a database and how you can solve them using techniques such as pessimistic and optimistic concurrency control. 17. What’s the Database Plus Concept and What Challenges Can It Solve? Explaining the Database Plus concept, its impact on system architecture design, and its innovations: from Proxyless Service Mesh to microservice backend support 18. 8 Crucial Tips for Hardening PostgreSQL 14.4 servers in 2022 As of July 13th, 2022, there are 135 security flaws reported to the CVE database. Here are 8 essential measures you can take to protect your PostgreSQL server. 19. The Roadmap to Learning SQL in 90 Days A Zero to SQL 90 Days Roadmap 20. AWS RDS from a Serverless Perspective In this article, we'll deep dive into all the basics to help you hit the ground running when it comes to AWS RDS. 21. "Specified key was too long; max key length is 767 bytes" Error in Laravel One of these issues you might stumble across using the PHP framework Laravel is this one: 22. Catch Your Hacker: Use Honeypot Tools to Capture Hackers Red Handed The number of security breaches and cybercrimes is increasing rapidly. With more and more approaches being transferred online, hackers have found their way of hacking into a system and corrupting the information or stealing data to turn it into profits. As the technology keeps on changing, the hacking attempts are also becoming smart and upgraded to ensure hackers are never caught in action. 23. Mastering MongoDB - currentOp “Dashboard in the pilot's cockpit” by Mitchel Boot on Unsplash 24. A Brief Introduction to MongoDB MongoDB is a document-oriented NoSQL database for storing large amounts of data. MongoDB uses collections and documents instead of tables and rows 25. How to Create a View in SQL and Its Uses This brief article on VIews in SQL explains how to create a view and other various operations in a step-by-step explanation. 26. I Made ChatGPT Act as a MariaDB Database ChatGPT is truly impressive. You can instruct it to do all sorts of things when they can be communicated in plain text. 27. A Quick Start Guide For MariaDB Get started with MariaDB with just three steps using the official MariaDB docker container. 28. The Megashift Towards Decentralized Edge Computing Why do we need Edge Computing? Why is the cloud not the solution for everything? Why is Edge Computing adoption taking so long? What's the solution to it? 29. ObjectBox: Empowering the Edge An interview with the CEO of Berlin-based Startup solving local on-device data storage and decentralized data-flows out-of-the-box to empower Edge Computing. 30. A Quick Guide To Business Data Analytics For many businesses the lack of data isn’t an issue. Actually, it’s the contrary, there’s usually too much data accessible to make an obvious decision. With that much data to sort, you need additional information from your data. 31. What is an API, Simply Explained Connectivity is something amazing. Right now, we are used to use our computers or phones to buy, post, watch, etc. We can do lots of things actually. We are connected to the world and to each other. 32. What The Heck Is DuckDB? DuckDB is doing for embedded analytic workloads what SQLite did for embedded OLTP workloads. 33. How to Set Up a Dedicated Database Server for Analytics Have that old laptop that's just in the back of your closet? Figure out how to give it a new life! 34. An Internal Email to Tim Cook and the State of Business Intelligence We get a glimpse into the inner workings of a valuable company and it turns out it's not all sunshine and rainbows. 35. Database Vs Data Warehouse Vs Data Lake: A Simple Explanation A data lake is totally different from a data warehouse in terms of structure and function. Here is a truly quick explanation of "Data Lake vs Data Warehouse". 36. Hadoop Data Storage Explained Explore how exactly distributed storage works in Hadoop? We have to characterize an essential node (known as NameNode) from one of the workers (DataNodes). 37. 10 Best Online Courses to Learn Oracle and PL/SQL for Beginners 38. How to Manage Multiple Databases in Rails 6 With the launch of Rails 6, one of the new features that were announced was of multiple database support. 39. Mastering MongoDB - Introducing multi-document transactions in v4.0 Photo by Madison Grooms on Unsplash 40. Why You Shouldn't Use a Database as Your App’s Data Source Most apps and APIs use databases as their data source and that is for a great reason. Databases have been designed to be scalable, resilient, and fully featured to support many types of use cases and scenarios. 41. How to query JSONB, beginner sheet cheat Let’s say we have to query a user table with a metadata JSONB column on a PostgreSQL 9.5+ database. 42. Migrating Away From Query Builders and ORMs in JavaScript or TypeScript I spent the better part of a day moving a project completely off of the ORM we were using (TypeORM). Ever since I started doing web development, I’ve been using some kind of heavy abstraction on top of my database. Whether it’s Mongoose when I used MongoDB, or TypeORM when I decided to move to TypeScript and PostgreSQL. However, it turns out that ORMs and query builders aren’t so great. I used to be that person that thought ORMs and query builders did the job for me, and I used it as an excuse to not learn SQL (which is what everyone tells you NOT to do). Given the tools that exist today, I would wholeheartedly recommend doing it the opposite of how I did if you’re starting off new to these things — write your SQL stuff by hand, or with help from the tools I mention later in the post. It’ll feel really slow at first, but you’ll thank yourself later 😄 43. Homomorphic Encryption: Introduction And Use Cases Organizations nowadays are storing and performing computation of the data on the cloud instead of handling themselves. Cloud Service Providers (CSPs) provide these services at an affordable cost and low maintenance. But to ensure compliance and retain privacy, organizations need to transfer the data in an encrypted format, which does ensure the confidentiality of the data. However, once the data reaches the cloud, the CSP has to decrypt the data to perform operation or computation. 44. PostgreSQL diff Explained Normal development flow requires continuous patching the production database with local changes normally made automatically by the orm software, this method is not perect but deceptively simple, all we'll use is standard Unix commands, and is good enough for us. 45. Mastering MongoDB - one tip a day series 46. How Percolate Queries in Elasticsearch Make Alerting a Breeze Once upon a time, a company I worked for had a problem: We had thousands of messages flowing through our data pipeline each second, and we want to be able to send email and SMS alerts to ours users when messages matching specific criteria were seen. 47. Comparing Different Time-Series Databases A comparison of data models used in open-source SQL and NoSQL time-series databases for IoT. 48. MySQL Master-Slave Replication using Docker In this article I want to share my experience of how to setup MySQL replication locally with using Docker. 49. Fetch Data From a JSON File With a React & Redux App This guide explains how to use React and Redux to fetch data from JSON files in an easy and lightweight method through a real example and well explained steps. 50. ACID Transactions Are Coming To Apache Cassandra: Here's Why We're Excited An extraordinary computer science breakthrough called Accord is bringing globally available, general-purpose ACID transactions to the next Cassandra release 51. Build a CRUD API using DynamoDB and Serverless - Part 1 Guide on How to do CRUD operations like DynamoDB GetItem, PutItem, DeleteItem and UpdateItem using AWS Serverless and NodeJS. 52. Customer Data Platform (CDP) Vs Data Warehouse, CRM, and Data Management Platform In this post, we highlight some key differences between a Customer Data Platform (CDP) and other tools generally used in a marketing tech stack. We also tackle the all-important question on many companies’ minds: “should I build or buy a CDP?.” 53. The Easiest Way to Solve N+1 Problem on GraphQL GraphQL is awesome! But one of the most annoying parts to implement a GraphQL server is solving N+1 problem. 54. Learn Why and How to Use Relational Database Migrations Learn Why And How To Use Relational Database Migrations. The way to initialize and update schema for relational databases with Java. 55. How To Install PostgreSQL With Docker Quickly Many developers still install a database on their computer and work on it. It may be a preferable method, but using Docker takes only seconds to set up a database. I used PostgreSQL and Docker in my latest project. As a result, I have achieved efficiency and convenience. I will give you my experience with PostgreSQL and Docker. 56. How To Connect MariaDB Docker Containers with Java Spring And JDBC Since being forked from MySQL back in 2009, MariaDB has become one of the most popular databases of choice for developers over the past decade. While many technologists have likely gravitated to it as a solution due to its open source roots and that it's rooted in the relational database world, that really only begins to scratch the surface of what MariaDB has to offer. 57. Pilosa: A Scalable High Performance Bitmap Database Index Big data is a big problem, at least getting anything useful out of it. Every day there is about three quintillion (the next step up is sextillion or one zettabyte) bytes of data created and only about 20% of it is structured and available to easily process. Nearly all useful processing that is done relies on a philosophy that is little changed from the green bar reports we were generating during the night shift and handing out up till the turn of the century. The whole map/reduce process is overnight batch processing, you aren’t working on live data, you are working on a snapshot, which might be fine for some companies, but for others, they need to be able to make decisions on high-velocity inbound data in near/real time. 58. Wix Velo Introduction: Basic Tips for Beginners An Overview On Wix Velo 59. Why You Want Multi-Region Application Architecture for you Database Multi-region application architecture is a key way to solve a lot of potential headaches with globally distributed apps. It makes applications more resilien 60. GraphQL, GraphQuill, and You Let’s start with the idea of a database, and a basic query. Server taps the database. Server brings back persistent state information that allows an application to update, and maybe a GUI. What’s wrong with this picture? Not much at first, of course. A GET request is the anchor of RESTful architecture, and in some ways the anchor of the web. So basic that fetch syntax defaults to that type. 61. Scanning 2.6 Million Domains for Exposed .Env Files A software developer scanned 2.6 million domains for exposed.env files. 62. Building a MongoDB NoSQL E-Commerce Data Model MongoDB supports ACID transactions, and its cloud offering is PCI DSS compliant. It's one of the best NoSQL options for e-commerce. 63. How To Master Elasticsearch Query DSL Photo by Evgeni Tcherkasski on Unsplash 64. What devs need to know about Encoding / Encryption / Hashing / Salting / Stretching This is a typical exchange about encryption with someone willing to learn. 65. How to Quickly Get Started With PHP and MariaDB A simple tutorial on how to get started with PHP and MariaDB. 66. How to Setup a Better Column-based Habit Tracker in Notion Not another Column-based Habit Tracker. Try using Relation Property to Track Habits. 67. 7 Useful SQL Resources for Beginners In this post, I have compiled some of the most useful SQL resources that I recommend to everyone who wants to study SQL. Depending on how much time you can invest and the type of course one would prefer, I have segregated the resources into different segments. So, let’s begin: 68. The Most Convenient Ways of Writing Transactions Within the Nest.js + TypeORM Stack If you have some troubles with transactions in Nest.js - this article will help you. 69. Let’s Reconsider Tradition Before we Decentralize The Entire World Technology promises change across all markets, but not all technological advances are as beneficial as they seem. In some markets, attempts at improvement end up producing inferior, complex products that cost more and don’t work as well as the product it was designed to improve. 70. Top 9 SQL and Database Courses to Learn Online 71. SQL Databases Vs. NOSQL Databases The decision to choose a database for project is not that simple. But when it comes to choosing a database, the biggest decisions is picking a relational (SQL) or non-relational (NoSQL) data structure. 72. With JSONB Data in PostgreSQL, You Can Get the Best of Both Worlds JSONB in PostgreSQL offers the best of relational and NoSQL. Here are two techniques that we use at AppLand to make JSONB data even more effective. 73. Object-Oriented Databases And Their Advantages Object oriented database is a type of database system that deals with modeling and creation of data as objects. The main advantage of this database is the cons 74. Introducing Bun: A Golang ORM Bun is a SQL-first Golang ORM for PostgreSQL, MySQL/MariaDB, MSSQL, and SQLite. It supports migrations, fixtures, and performance monitoring. 75. A Guide on The Future of ETL: EL(T) not ELT How we store and manage data has completely changed over the last decade. We moved from an ETL world to an ELT world, with companies like Fivetran pushing the trend. However, we don’t think it is going to stop there; ELT is a transition in our mind towards EL(T) (with EL decoupled from T). And to understand this, we need to discern the underlying reasons for this trend, as they might show what’s in store for the future. 76. 5 Best Courses to Learn MySQL Database for Beginners If you are interested in learning SQL with MySQL database then you have come to the right place. 77. Golang Tutorial: How to Migrate Your Database Golang - How to handle database migration using GORM. 78. An Introduction to Database Testing With an Example of MariaDB Here's an example of Database testing with the MariaDB Server, one of the most popular open-source relational databases. 79. Trino: The Open-source Data Query Engine That Split from Facebook If you want to accelerate Trino queries with a response time of seconds to minutes, click here to learn how Trino helps engineers. 80. Principles of a Clean Relational Database The article describes how a relational database should be designed to properly work in OLTP mode. 81. Fundamentals of Data Structures [Part 1] A trip down memory lane avid reader. Let's take a walk through the core of it all: data structures. What are they and why are they so important? A 'hello' to a reader that might have missed our talk on Memory management, where we delved into what happens to our code in variable assignment. Do take a look, even if it's a refresher you're looking for. 82. Here is the Fastest GraphQL Playground It's been 2 months of Firecamp's GraphQL playground launching, throughout this time I have been discussing with so many folks about their GraphQL usage and experience with Playground. 83. When to Use a Relational, Non-Relational, or Graph Database Graph databases are anticipated to surpass other types of databases, especially the still-dominant relational database. 84. 6 Database Migration Tools For Complete Data Integrity & More Database migrations are driven by benefits like lower costs, better features, and the ability to scale. However, the security of data is essential. 85. 7 Database Optimization Best Practices for Django Developers In this article, we will be discussing the ways to optimize the database for speed in Django applications. 86. What the Heck is PRQL? Another clever tool for a powerful SQL pre-processor 87. Data Lakes Are Crucial To Business Analytics and Big Data Processing While the term Data is in cognizance of business of all sizes even the most layman person is aware of the buzz and fuss around Data. So from Database to Data Warehouse and now this Data Lake, we have come a long way. 88. How To Show User Friends Posts Using Ruby on Rails In this post, I’ll explain a trick that will give your web application the ability to show friends’ posts. 89. Logical Replication: Real-time Web Updates From Your PostgreSQL Database I wrote a small open-source library that combines dotNetify with PostgreSQL logical replication. 90. SQLAlchemy is a Better Way to Run Queries In college, I discovered a new and even better way to run queries, SQLAlchemy. 91. Middleware to Ecosystem Evolution: Understanding New Features of Apache ShardingSphere 5.0.0 ShardingSphere recreates the distributed pluggable system, connecting actual user implementation scenarios and contributing valuable solutions. 92. How to Seed Your Rails Database with Faker I built a Customer Support System a few days ago and started to think of a way to seed my rails database with random data for testing without having to manually type in the data. This may not be the best way to do it, but it works and allows you to test your application. 93. How to Manage Databases with CI/CD If you’re still doing manual migrations on the database you’re doing it wrong. Databases are as much part of the application as the code. 94. Extracting Information From Hash in Ruby on Rails When I was recently working in one of the client project, I had to communicate with external mariadb server to store records from react/rails app, that means I would get activerecord hash from our app which I had to convert to pure sql query and send it to external server for storing. If you have worked with sql queries previously then you must know that keys and values must be separated for insert operations like 95. An Overview of SQL Antipatterns I was recently going through my notes of SQL Antipatterns and was shocked to realize how actual this book still is. 96. Check Out These 8 Free SQL Courses to Learn About Oracle, MySQL, and SQL Server SQL is very important and many programmers realize this, however, I have found that many more programmers just don't spend much time improving their SQL skills. 97. What Is the Difference Between Enum, Varchar and Int Data Types in MySQL The 'varchar' and 'enum' fields are different types of data types. They are different in terms of performance, easiness to use, and support for feature changes. 98. How to Install MySQL 8 on macOS Using Homebrew A step-by-step guide 📙 on how to install, configure and run MySQL 8 server on macOS using Homebrew 🍺 99. MongoDB 101: A Free Course By Academy 3T MongoDB is a document-based NoSQL database, typically used for its ability to quickly scale, especially large amounts of data. MongoDB has two clear main benefits over SQL when it comes to data organization: 100. Taking a Closer Look into Google's AlloyDB Architecture for PostgreSQL An exploration of AlloyDB's architecture and design, focussing on its storage engine, with descriptions of how it handles reads and writes 101. Setting Up a Dedicated Database Server on Raspberry Pi Learn how to set up a MariaDB database server on a Raspberry Pi 4 Model B with 8 GB of RAM that you can connect to your local network through WiFi or Ethernet 102. Data Management Patterns for Microservices Architecture Microservices architecture patterns have highly transformed and streamlined the development process and have increased the performance of applications. 103. What is the Future for SQL Developers in a Machine Learning World? Do you know the machine learning global market is estimated to reach $30.6 billion by 2024? This marvellous growth is the outcome of Omni-presence of artificial intelligence and its trending subset; machine learning. 104. How to Connect Your Bastion Server to a PostgreSQL Server with an SSH Tunnel In this article, you'll learn how to connect to an RDS server through a bastion server in Bash using an SSH tunnel. 105. How to Choose the Right Database for your Requirements Imagine — You’re in a system design interview and need to pick a database to store, let’s say, order-related data in an e-commerce system. Your data is structured and needs to be consistent, but your query pattern doesn’t match with a standard relational DB’s. You need your transactions to be isolated, and atomic and all things ACID… But OMG it needs to scale infinitely like Cassandra!! So how would you decide what storage solution to choose? Well, let’s see! 106. Reasons Why Everybody Loves The New GraphQL Editor 3.0 We’ve just launched GraphQL Editor 3.0 and I must say it’s nothing like a year ago as we released it. When we started our vision was to provide an alternative way of designing a GraphQL schema, but what we ended up with is a lot more. 107. Intro to Databases: Using Different Data Models and Representing Databases Visually As you get into the Databases and Data Science, the first thing that you have to master is the relations between entities in your database. That is important because the data that you use has to be absolutely efficient for its further implementations. 108. How To Populate Your Database with Fake Data: Ruby On Rails Tutorial This is going to be a very straightforward article, no jokes included. 109. How to Deploy Strapi v4 on the DigitalOcean App Platform with MySQL Database This is a step-by-step guide for deploying a Strapi v4 project to DigitalOcean's App Platform with managed mySql Database. 110. Is GraphQL Still a Thing in 2020? GraphQL has become the most loved tool for API development in a very short span of time, and developers across the world cannot seem to get enough of it. Today I met with the founder of Windsor.io, Pranay Prakash, who has worked on the team behind GraphQL during his time at Facebook. I chatted with him to find out more about his experience working closely with Lee Byron, the creator of GraphQL, and some of GraphQL’s benefits. 111. What is the Significance of Time-Weighted Averages in Data Analysis Learn how time-weighted averages are calculated, why they’re so powerful for data analysis, and how to use TimescaleDB hyperfunctions to calculate them faster. 112. MongoDB: Exploring Data Visualization Tools and Techniques Looking for MongoDB data visualization tool? There are plenty of options but firstly its better to explore what kinds of solutions there are on the market. 113. How To Query JSON in Couchbase via Collections and Scopes This week I’m attending the 3-day Couchbase Connect event and will be reporting on some of the topics that I find most interesting. 114. Build a Live Dashboard with Materialize, Airbyte, MySQL and Redpanda/Kafka 115. MySQL Errors Messages And Common Problems Errors or mistakes are common in any aspects, especially in development. Using MySQL or any database can't guarantee you an error-free environment. 116. Introduction to a Career in Data Engineering A valuable asset for anyone looking to break into the Data Engineering field is understanding the different types of data and the Data Pipeline. 117. How to Get Started With JPA/Hibernate JPA was born as the acronym for Java Persistence API. 118. Build your Own ORM from Scratch With Python curious about how ORM works! read this tutorial and make one from scratch using python programming language. 119. How to Convert Rest APIs into Databases: Create a JDBC driver A lot of data over the web or internally in an enterprise is available and accessible only through Rest APIs. Rest APIs do provide a secure and authenticated mechanism to access these services, but they are not very intuitive sometimes to query upon the data which is fetched through them. 120. Top 10 Microsoft SQL Server Tips There is a lot of information about different T-SQL features. I want to tell you about equally useful, but less popular tips for working with this language! 121. HarperDB: Build Your Application Backend in One Place with Custom Functions Introducing the newest innovation from HarperDB: HarperDB Custom Functions. With the release of HarperDB 3.1 users are able to define their own API endpoints within HarperDB. What does that mean for you? HarperDB grows from a distributed database to a distributed application development platform with integrated persistence - one that can serve as a single solution for all of your backend needs. We’re collapsing the stack! 122. Exploring PL/SQL Nested Tables in Oracle In this tutorial, you will learn how to declare and initialize Oracle PL/SQL collections (Nested Tables). 123. Nontechnical Explanation for Why Relational Databases Don't Work This is What I’m Telling Business People About Why Relational Databases Are So Bad 124. What Web3 & Decentralization Mean for Data Storage I think of web3 and decentralization on a spectrum - it’s not just one or the other, but you can take incremental steps on the path towards your end goal. 125. Optimized Metadata Loading Process on ShardingSphere: A Technical Deep-Dive The powerful database middleware ShardingSphere core functions such as data sharding, encryption and decryption are all based on the database metadata. 126. Apache Cassandra – An Essentials Guide Need to get up to speed on Cassandra and learn how it can benefit your software development practices? These are the essentials that cover the basics. 127. How To Build Graphql API with Spring Boot, Neo4j and Kong [Part 1] Introduction 128. The Two Best Ways to Scan for PII in Your Data Warehouse Find PII data by scanning column names and/or data in your data warehouse with these two easy to create methods and a step-by-step guide on how to do it. 129. Unlock the Power of ACID Properties in Databases: A Comprehensive Guide for Developers ACID stands for Atomicity, Consistency, Isolation and Durability and each of these have a specific purpose when it comes to databases. 130. An Overview of Database Indexing for Beginners Database Indexing is the most common way known and utilized by backend developers to optimize database queries. 131. Introducing GitHub Based Airports API Service Hello developers and enthusiasts! 😍 132. 2 Error-Free Options for Decimal handling in Golang CockroachDB and using a popular database are two error-free options for decimal handling in Golang. 133. SQL Server container in Azure Kubernetes Services (AKS) So recently I got involved with an ASP.NET project which was build over 10 years ago and over the years Developers and Change Requests came and went. And over the period the Application became quite cumbersome and quite hard to understand and manage, the Application became quite large in terms of functionality, codebase and data. 134. Postgres and MySQL: Performance Comparisson What workload analysis and running queries can teach us about the performance differences in JSON, indexing, and concurrency. 135. Debugging Has_Many, Through Relationships in Ruby on Rails Working with model associations can be difficult. 136. Solving Data Integration: The Pros and Cons of Open Source and Commercial Software There was an awesome debate on DBT’s Slack last week discussing mainly two things: 137. Why Appwrite 0.8 Is A Great Open-Source Firebase Alternative Announcing Appwrite 0.8 with JWT authentication, ARM support, Anonymous Login, new storage capabilities and many more new features. 138. #NoBrainers: You Need A High Performing Low Latency Distributed Database Certain industries greatly benefit from high-performing, low-latency, geo-distributed technologies. 139. Why Kubernetes Is The Best Technology For Running A Cloud-Native Database We’ve been talking about migrating workloads to the cloud for a long time, but a look at the application portfolios of many IT organizations demonstrates that there’s still a lot of work to be done. In many cases, challenges with persisting and moving data in clouds continue to be the key limiting factor slowing cloud adoption, despite the fact that databases in the cloud have been available for years. 140. Introduction to GraphQL TL;DR 141. Think Before You Hibernate This article explains what the general pros and cons of Hibernate are so that you can better determine your need to add this dependency in a new microservice. 142. Advanced and Efficient MongoDB Pagination How to make clean pagination with no additional dependencies. Basically for Node.js but can be used in any other languages and platforms. 143. Jaeger Persistent Storage with Elasticsearch, Cassandra and Kafka Running systems in production involve requirements for high availability, resilience and recovery from failure. When running cloud-native applications this becomes even more critical, as the base assumption in such environments is that compute nodes will suffer outages, Kubernetes nodes will go down and microservices instances are likely to fail, yet the service is expected to remain up and running. 144. Take your Materialized Views to the Next Level by Joining MySQL and Postgres 145. How To Integrate Your Laptop With AWS And Deploy DynamoDB Locally How to Interact with AWS (Amazon Web Services) cloud from your local machine. 146. Building An In-memory Database in Go Building an in-memory database in golang is a basic task that you are likely to have to do. It needs you to make a database and a table before organising. 147. How to Handle Database Versioning on Multiple Environments Ok, so here is the situation: you work in a team, and each developer works with a local environment. Or you have multiple environments. Or... We don't care. The only thing is, you have to handle different versions of databases, and you don't know how to do this safely and efficiently. 148. My System Design Interview Checklist in 8 Simple Steps That dreaded system design interview. I remember the first system design question I was asked. “Design WhatsApp”, he said. I didn’t know where to start! I was a fresher. Data structures and algorithms were the only things I knew. I am sure you can guess how that interview went. Then after enough research, I made myself a checklist of components, of sorts, to navigate me through my next system design interviews. And I sh*t you not, it works! 149. Introduction to Recursive CTE This article will introduce the concept of SQL recursive. Recursive CTE is a really cool. We will see that it can often simplify our code, and avoid a cascade of SQL queries! 150. How to Build Cloud-Based Data Architectures Building Cloud-Based Data Architectures is necessary to making use of Big Data and gaining the ability to process significant amounts of data for analysis. 151. Which Database Is Right For You? HarperDB vs. MongoDB vs. PostgreSQL The purpose of this article is not to determine which database is the best but to help determine which is a fit for your specific project. 152. AvionDB: A MongoDB-like Distributed Database In the past few months we have been getting this question a lot: 153. How to Set up a Heroku Postgres Database with Librato In this article, you will learn how to set up a Heroku Postgres database with Librato for automated monitoring. 154. Breaking Down MSON Template Queries Template Queries are dynamic templates constructed with MongoDB-style operators, which allow you to customize MSON components with less code. 155. dbForge Studio vs. PL/SQL developer: Which Oracle IDE to choose? Both dbForge Studio and PL/SQL Developer are integrated development environments (IDEs) designed to help with Oracle database developmenttasks and PL/SQL coding productivity. However, just as any two tools,the ones we’re discussing are not exactly the same. Sometimes, it’s very important to know which solution to choose given your specific needs and preferences. In this article, we’ll look at the differences of dbForge Studio and PL/SQL Developer and analyze their strengths and weaknesses in detail. 156. MongoDB vs. DocumentDB: Which Is A Better Choice for You? Are you trying to decide if you should use MongoDB or DocumentDB? With the recent controversy surrounding licensing with MongoDB, it can be confusing to decide which option is right for your company or project. Amazon decided the core MongoDB code is challenging to scale while remaining highly available. Amazon wrote their implementation, which is compatible with the Apache 2.0 open source MongoDB 3.6 API. MongoDB, Inc. has also recently changed their license to make future imitations more difficult. To do this, they created an entirely new license called the Server Side Public License. 157. NoSQL: A Brief History and the DynamoDB Challenge Dynamo accelerated the NoSQL revolution that’s driving the database industry. 158. Data Services for the Masses I’ve held several roles in my career in IT, ranging from software developer to enterprise architect to developer advocate. I’ve always been fascinated by the role that data plays in our applications—putting it into databases, getting it back out quickly, making sure it remains accurate when transferred between systems. Many of the hardest problems I’ve encountered have centered around data. For example: 159. InfluxDB: From Open Source Time Series Database to Millions in Revenue The InfluxBD Origin Story: How Paul Dix took a failing SaaS product and turned it into a successful commercial open source time series database company. 160. Database Connection Pooling With pgbouncer Introduction: The Postgres Connection Pool Problem 161. Graphs in the 2020s: Databases, Platforms and The Evolution of Knowledge Graphs, and knowledge graphs, are key concepts and technologies for the 2020s. What will they look like, and what will they enable going forward? 162. How to Consolidate Real-Time Analytics From Multiple Databases Have you ever waited overnight for that report from yesterday’s sales? Or maybe you longed for the updated demand forecast that predicts inventory requirements from real-time point-of-sale and order management data. We are always waiting for our analytics. And worse yet, it usually takes weeks to request changes to our reports. To add insult to injury, you keep getting taxed for the increasing costs of the specialized analytics database. 163. Active Record Associations in Rails An association is a connection between two Active Record models. It makes much easier to perform various operations on the records in your code. We will divide associations into four categories: 164. Supporting 'Citizen IT': It’s Critical to Democratize Your Data Democratizing data to enable Citizen IT provides a competitive advantage to organizations - here's why. 165. Learning Self JOIN Queries With SQLZOO This article uses Exercise number 10 on the Self JOIN SQL ZOO tutorial to teach self JOINs in a beginner-friendly way. 166. [Tutorial] Top 5 Ways to Query your Relational Database in JavaScript [Part 1] If you’re developing web applications, you’re almost certainly going to be constantly interacting with a database. And when it comes time to select the way you’ll interact, the choices can be overwhelming. 167. The Essential Data Cleansing Checklist After some time working as a data scientist in my startup, I came to a point where I needed to ask for external help with your project. 168. An Introduction to Blockchain + NoSQL Databases Both NoSQL databases and modern Blockchain ledgers benefit from a set of common principles. When they are both implemented for an application, a lot can be accomplished as the platforms can complement each other. 169. TMNT: Translation Memory and Neural Translation As we advance the state of machine translation, translation memory has its place in todays’ translation tech stack that benefits MT users and human translators. 170. Connecting Securely to Private AWS Resources by Using SSH Tunnels and Bastion Hosts The Problem with Publicly Accessible AWS Resources and how to solve it 171. Make Your Application Scalable Optimizing the ORM Performance In this article I would share a set of ORMs optimization strategies that I'm using in almost every backend service I'm working on. 172. The Rise of Reusable SQL-based Data Modeling Tools and DataOps services The resurgence of SQL-based RDBMS 173. The Importance of a Single Source of Truth for Enterprises A single source of truth (SSOT) enables that synchronization. A company with SSOT relies on one and only one point of reference for the latest, aggregated info. 174. Vagrant with Oracle Database: For When You Need More Than a Container Image! I’ve written about my love for Vagrant a few times already here, today I will show the steps to getting an Oracle Database with Vagrant. 175. Everything You Need to Know About AWS DynamoDB AWS DynamoDB changed the database game in Serverless and continues to do so, as its design repeatedly proves its huge value. 176. 9 Best Data Integration Software in 2022 Every business needs to collect, manage, integrate, and analyze data collected from various sources. Data integration software can help! 177. A Guide to Using MongoDB Database in a ASP NET Core Web API Application When you think about database providers for ASP NET Core apps, you probably think about Entity Framework Core (EF Core), which handles interacting with SQL databases. But what about the NoSQL options? A popular option for NoSQL is MongoDB. So in this article we're going to learn how to create a simple ASP NET Core CRUD API using MongoDB as the database provider. 178. How To Handle Complex User Permissions in GraphQL I have been working on a GraphQL workshop, and it’s been a great learning experience. One of the trickiest things I have had to deal with in GraphQL is handling complex user permissions. It used to be a hassle until a friend pulled my attention to Hasura. 179. Mastering MongoDB - Faster elections during rolling maintenance Photo by annie bolin on Unsplash 180. Design for E-Commerce Apps Using a NoSQL Database Working with a lot of data like products, orders, categories, users and payments is a very important topic when building e-commerce applications. In this post you'll learn the very basics of structuring your noSQL schema so it's fast and scalable for e-commerce scenarios. 181. How To Work with External Database When you enable Velo you also automatically get Wix Data, which lets you work with our built-in databases on your site. You may also want to work with data that you maintain in an external database. Velo lets you connect your site to an external database and then work with that database collection in your site just as you would with our built-in collections. 182. How to Connect MongoDB(4.2.10) and MongoDB Compass Locally What is MongoDB? 183. HarperDB is More Than Just a Database: Here's Why HarperDB is more than just a database, and for certain users or projects, HarperDB is not serving as a database at all. How can this be possible? 184. MongoDB vs. DynamoDB: Choosing the Best Database for Your Business All about MongoDB vs DynamoDB. Explore benefits, and in-depth comparison to find out the best choice for your business app. 185. A Comprehensive Guide To Database Architectures And Use Cases This article will provide an overview on database architectures, including use cases and pros & cons for each of them. 186. How To Add Data Sensitivity Classification Command in SQL Server 2019 For a database administrator, the common everyday practice involves running multiple operations targeted at ensuring database security and integrity. Thus, we shouldn’t overlook the importance of sensitive data stored in the database under any circumstances. In light of this, we are excited to demonstrate the new ADD SENSITIVITY CLASSIFICATION command introduced in SQL Server 2019, which allows adding the sensitivity classification metadata to database columns. 187. Adding Encryption to a Fast Database, Without Compromise This article will be of particular interest to people who are curious about how powerful encryption can be implemented in high performance systems. It is also for people who just want to know a bit more about how strong encryption works and how all the pieces fit together. 188. Introduction to RDS Proxy: Exploring with Benchmarks in Go A deep dive into the performance characteristics of RDS Proxy vs RDS 189. Apache Cassandra Guide: Data Modeling Data modeling is probably one of the most important and potentially challenging aspects of Cassandra. CQL will look familiar if you come from a relational background, but the way you use it can be very different. For our third guide, we will walk you through the process of creating a basic data model. Read part one on Cassandra essentials and part two on bootstrapping. 190. HarperDB - How and Why We Built It From The Ground Up on NodeJS The founding team at HarperDB built the first and only database written in Node.js. Here's the story of this (what some called crazy) endeavor. 191. Decentralized Databases Reduce Data Latency With Geographically Distributed Data Centers Latency is caused by offloading processing from an app to an external server. But what if there was a solution to the monolithic common single-cloud geography? 192. The Pros and Cons of NoSQL Learn how NoSQL differs from SQL and how it's built for high performance and availability. And no, it doesn't stand for "No SQL". 193. The Big Bad Guide on Database Testing The process of checking data integrity and consistency of the database is called database testing. Ultimately, it aims to create complex queries to check database responsiveness to load/stress putting schema, tables, triggers, stored procedures, etc., under test. 194. 10 Ways to Optimize Your Database Take these 10 steps to optimize your database. 195. Why We Should Have Different Databases Today there are hundreds of SQL and NoSQL databases. Some of them are popular, some are ignored. Some are user-friendly and well documented and some are hard to use. Some are open sourced and some are proprietary. And, perhaps, the most important - some are scalable, optimized, highly available and some are difficult to scale or maintain. 196. Why do we need a through table explained with Rails? In a many to many relationship, it's just a table between the entities, but what is the purpose of this table to be between them? 197. Know the Vitality of Mobile App Architecture The output is what measures the success of a business. Therefore, all the business houses are adopting all the inevitable methods and programs to intensify their productivity/ output by adopting new technologies and concepts. There are several technologies available and many in the developing phase, which effectively fulfil customers’ needs and generates high output. 198. Native Analytics On Elasticsearch With Knowi Table of Contents 199. Functional Testing With Your Backend in Go For Terrastruct, which has a little over 50K lines of code as of now, I've only written functional end-to-end tests. This blog post describes a successful setup that took some iterating to get to, and it's one I wish existed when I started with a Go API backend. 200. Graph Databases: Full Detailed Review There are many ideas and considerations behind graph databases. This includes their use cases, advantages, and the trends behind this database model. There are also several real-world examples to dissect. 201. Stream and Display Data in Realtime with Materialize and Adonis In this tutorial, we are going to build a web application using AdonisJS and integrate it with Materialize to create a real-time dashboard 202. Which Database Is Right For You?Graph Database vs. Relational Database Learn about the main differences between graph and relational databases. What kind of use-cases are best suited for each type, their strengths, and weaknesses. 203. Integrate Java Database Versioning with Liquibase using MySQL [A Step by Step Guide] Versioning database changes is as important as versioning source code. By using a database migration tool we can safely manage how the database evolves, instead of running a bunch of non versioned loose SQL files. In some frameworks like Ruby On Rails, database versioning occurs along the development. But when it comes to Java world, I don't see it happening so often. 204. Intro to Structured Query Language (SQL) In the post, I used a simple SQL query to explain how certain things work in SQL. I also outlined problems with the query and potential ways to improve the code 205. CouchDB vs MariaDB- Which is better? In simple terms, a database is a collection of information. It is organized to ensure easy accessibility, management, and updates. 206. Guiding Observers Through Prometheus' Architecture We heard of Prometheus being an open-source solution for system monitoring, thanks to SoundCloud. But what are its other use cases? How is it being leveraged? 207. Percentile Approximation Vs. Averages Get a primer on percentile approximations and why they're useful for time-series data analysis. 208. Step-by-Step Guide on How to Use External Database Collections for Better Wix Website Performance Integrate your external databases into your Wix sites. Learn more. 209. Top 3 Databases Every New Developer Should Know Most new developers wonder which database is suitable for their project since they don't want to get off on the wrong foot. So, first and foremost, let's define a database. A database is a type of storage facility that electronically stores and organizes data so that it may be utilized and accessed later. 210. How PostgreSQL Aggregation Inspired Timescale Hyperfunctions’ Design Get a primer on PostgreSQL aggregation, how PostgreSQL´s implementation inspired us as we built TimescaleDB hyperfunctions and what it means for developers. 211. How to Migrate Data from an MSSQL Server to PostGreSQL? Thinking of shifting to a new database management engine? Here's how to migrate data from SQL server to PostgreSQL. 212. Graph Databases Introduction: The Power of Connected Data In today's economy, more and more companies exist primarily online. While there's much discussion around the consequences of leaving behind the traditional brick and mortar business, one aspect that gets less attention is the significant change in how these companies are now managing their data. Increasingly, businesses seek to understand their customers and how best to meet their needs in a way that monthly reports and KPI charts just can’t address. 213. SQL's 50 Year Reign: Here's Why SQL Is Still Relevant Today Dive into the detailed history of SQL's rise and reign over the past 50 years. They remained relevant by listening and adapting to the market. 214. What happens inside an Amazon warehouse: A software engineer's guide Have you ever wonder what happens inside of an Amazon warehouse? As a software engineer, the supply chain field has plenty of technical challenges. 215. Zilliqa (ZIL) Review: What You Should Know One of the most significant problems cryptocurrencies and their blockchains face today is scalability. Unlike today’s leading blockchain networks, such as Bitco 216. Building Advanced Forms and Custom Interactions with Velo: A How-To Guide With Velo and Wix's custom input elements, you can make extremely sophisticated forms which can do almost anything you can imagine at a fraction of the cost. 217. Velo How-To: API Aggregations Using the aggregation functionality of the Data API you can perform certain calculations on your collection data, as whole or on groups of items that you define, to retrieve meaningful summaries. You can also add filtering and sorting to your aggregations to retrieve exactly what you need. 218. Semantic Search Queries Return More Informed Results In this article, you will learn what a vector search engine is and how you can use Weaviate with your own data in 5 minutes. 219. Use Google Sheets as a Database, Responsibly: A Step-by-Step Guide While database technology and other tools have come a long way, it's still tough to beat the humble spreadsheet's versatility and intuitiveness. While using them for sensitive, critical applications like storing COVID-19 patient data is ill-advised, the fact that everyone knows how to use a spreadsheet means they're great for smaller cross-functional projects where a non-developer might need to examine or edit data. 220. Event-Driven Change Data Capture: Introduction, Use Cases, and Tools How to detect, capture, and propagate changes in source databases to target systems in a real-time, event-driven manner with Change Data Capture (CDC). 221. Making It Easier To Deploy Machine Learning For All [A Deep Dive] With the quality of machine learning packages being developed today, testing and creating models couldn’t be easier. Data scientists can simply import their favorite library and have immediate access to dozens of cutting edge algorithms. 222. 5 Top Skills To Consider When You Choose An Android Developer Android development has many functionalities depending on the developer. There are several essential components of Android app development to be executed by an Android developer and choosing the right developer for your Android app development is as important as the process itself. Three basic components most recruiters would consider is Design, Coding, and deployment of the application. 223. Holy Land of Crypto Users: How does Web3.0 Data Empower Centralized Exchanges? Designing a data-oriented, user-incentive mechanism is a good path when developing the future of centralised exchanges for the cryptocurrency industry. 224. 10 Ways to Reduce Data Loss and Potential Downtime Of Your Database In this article, you can find ten actionable methods to protect your mission-critical database. 225. Apache Cassandra – Bootstrapping Our first article covered Cassandra essentials: the “what” and “why” about the architecture. If you’re ready to try Cassandra, the next few articles will explain the “how.” At the end of these tutorials you should have a database up and running, experienced using Cassandra Query Language (CQL), gained some practical data modeling expertise, and learned best practices for building applications with Cassandra. 226. dksnap Introduction: Docker Snapshots for Development and Test Data TL;DR 227. Querying Complex JSON Objects With SQL How many times have you run into a situation where you wish you could do a SQL join without getting duplicate rows back? What if we could get a list "column" returned instead? HarperDB’s ARRAY() function enables just that. In this post we’re going to take a look at a basic example of people with addresses and phone numbers. 228. Are NoSQL databases relevant for data engineering? In this article, we’ll investigate use cases for which data engineers may need to interact with NoSQL database, as well as the pros and cons. 229. RocksDB Is Steadily Eating the Database World Technical design. Because one of the most common use cases of the new databases is storing data that is generated by high-throughput sources, it is important that the store engine is able to handle write-intensive workloads, all while offering acceptable read performance. RocksDB implements what is known in the database literature as a log-structured merge tree aka LSM tree. 230. Object Recognition With SPOT from Boston Robotics Earlier this month, we were joined by Joris Sijs, Lead Scientist at TNO on the second series of Grakn Orbit. 231. Meet SOPHIA: A Clinical Decision Support System Built with Open Source Technologies A Clinical Decision Support System (CDSS) provides the doctor with a tool that eases their work, and increases the value of the time spent with the patient. 232. The Apprentice's Guide to Apache Kafka Apache Kafka is a distributed event streaming platform built over strong concepts. Let's dive into the possibilities it offers. 233. How to Run Node.js with MongoDB [Tutorial] Many of today’s web applications use node.js in conjunction with MongoDB to store and access data on the backend server. Not only does node.js excel in ease of access to non-relational databases like MongoDB, but brings scalability and speed to the server side of your app. 234. Changing Database Column in Rails 5 While working on a Rails application, we all have had to change the database column in some way. You can change the column name and the column type, as well as changing the column with the type conversion. 235. Going From Data Lakes to Oceans Aggregating into data lakes is the solution of today — but are Federated Sources the solution of tomorrow? 236. The HackerNoon Podcast: Managing Databases on Kubernetes with Anil Kumar Amy Tom talks to Anil Kumar, the Product Manager at Couchbase, about becoming a Product Manager, writing his book, and creating a multi-cloud strategy. 237. Migration Makes My Skin Crawl: From SQL to NoSQL Is database migration as scary as it sounds? Amy Tom talks to Matt Groves, Senior PM Manager at Couchbase, and Curt Gratz, Co-Owner of CKH Consulting. 238. Ruby on Rails Hidden Secrets: How To Get The Most Out Of Active Record Associations Hello folks! In this article, we are going to unravel the mystery behind the Rails Active Record class. To be honest, I struggled a lot with Rails models as a beginner. I spent a lot of time reading the docs, read a couple of medium articles, watched some youtube videos but all in vain. I have chosen to draft a nice article that constitutes of baby steps that is suitable for aspiring Rails Engineers. 239. Most Common Redis Use Cases by Core Data Structures Redis, short for Remote Dictionary Server, is a BSD-licensed, open-source in-memory key-value data structure store written in C language by Salvatore Sanfillipo and was first released on May 10, 2009. Depending on how it is configured, Redis can act like a database, a cache or a message broker. It’s important to note that Redis is a NoSQL database system. This implies that unlike SQL (Structured Query Language) driven database systems like MySQL, PostgreSQL, and Oracle, Redis does not store data in well-defined database schemas which constitute tables, rows, and columns. Instead, Redis stores data in data structures which makes it very flexible to use. In this blog, we outline the top Redis use cases by the different core data structure types. 240. Composable Resource Management in Scala We’re all using resources on a daily basis. You turn on the water tap, wash your hands for at least 20–30 seconds, and turn it off. You switch the light on if it’s dark, and off when you no longer need it. 241. 3 Years After Forking Sphinx: A Brief Report on Manticore Search In May 2017 we made a fork of Sphinxsearch 2.3.2, which we called Manticore Search. Below you will find a brief report on Manticore Search as a fork of Sphinx and our achievements since then. 242. Dependencies, Entity Classes, and Configuration for Jinq to Create Database Queries in Java Jinq is a library that provides a convenient and natural way to build typesafe database queries in Java. It is easy to use and does not require code generation 243. What is SQL? And Where is it Used? What is SQL? Databases use it, query APIs use it, even energetic big data dashboards use it! Where did it come from and how are developers, DBAs, and app using. 244. Upgrading MySQL 5.5 to MySQL 8: A Step by Step Guide It is one of the dogmas that upgrading freeware libraries is a drag - but not anymore especially for MySQL. Check out this article for more information. 245. Should I Use An Embedded Database In My Mobile Application? (Podcast Transcript) Amy Tom chats to Jens Alfke about embedded databases in mobile applications and how they live within your application and sync to your server. 246. Implementing A Distributed Multi-document ACID Transactions in Couchbase: A How-To Guide A story about how we implemented support for distributed transactions with no central coordinator and no single point of failure. 247. How to Create World Leading Databases Jason Repp is the SVP of HarperDB, a world-leading database and development platform that is leading the charge in terms of performance, flexibility, and ease. 248. 9 Of The Most Popular Headless CMS' In 2021 Check the list of the best headless cms on the market and learn more about how Headless CMS Can Help You Build Fast 249. PostgreSQL Index Types: Beyond the B-tree bad indexing is the main source of bad performance of your database 250. How To Build A Time-Traveling Contacts App with SirixDB A tutorial showing the use of SirixDB and pysirix in perserving and querying old data with ease. 251. How to Create a RESTful API With HarperDB and FastifyJS Learn how to build a course management REST API with Node.js, HarperDB and FastifyJS. 252. How to Achieve Schema and Validation in NoSQL Using Ottoman and Couchbase Ottoman is an Object Data Modeler (ODM) for Couchbase's Node.js SDK providing JSON schema and validation for a NoSQL database. 253. Database Schema Versioning and Migrations Made Simpler For High Speed CI/CD If you are a back-end developer, you are often faced with having to migrate your database schema with each new release. 254. MySQL FAQs MySQL is an open-source relational database management system. As the name suggests, it is used to create, update, and store databases. It is based on SQL (Structured Query Language). So, today we will be checking out the 13 most asked questions on MySQL. 255. A Comprehensive Guide to Apache Cassandra Architecture Introduction 256. [Tutorial] Top 5 Ways to Query Your Relational Database in JavaScript [Part 2] Welcome back! In the first part of this series, we looked at a very "low-level" way to interact with a relational database by sending it raw SQL strings and retrieving the results. We created a very simple Express application that we can use as an example and deployed it on Heroku with a Postgres database. 257. Creating Developer-Friendly Data Services with Apache Cassandra Using data APIs and advanced data modeling will make it far easier for JSON-oriented developers to connect to Apache Cassandra. 258. How To Restore Your Database From a SQL Backup Backing up SQL and databases using the manual restore method, the full database backup, the incremental restore, or the manageauditing command. 259. How to Install and Use Materialize to Run SQL Queries on your nginx Logs In this tutorial, I will show you how Materialize works by using it to run SQL queries on continuously produced nginx logs. By the end of the tutorial, you will 260. How To Setup An Effective Refactoring Process of a Heavy Database Interface This story is about pain, agony, and denial of ready-made solutions. It is also about changes that improve the code’s readability and help the development team stay happy. The object of this post is an interface that helps a program communicate with a database. 261. How to Test Your Postgres Business Logic with Jest Plugin With great power comes great responsibility and the bigger the project gets the easier it is to break something. Therefore you should test Postgres logic! 262. How to Query Deeply Nested JSON Data in PSQL Recently I had to write a script, which should’ve changed some JSON data structure in a PSQL database. Here are some tricks I learned along the way. 263. Knowing Where and When to Enforce the Uniqueness of Your Data This article looks at data uniqueness and discusses where it should be enforced. At application level or database level? 264. Decoding MySQL EXPLAIN Query Results for Better Performance (Part 2) Understanding MySQL explains query output is essential to optimize the query. EXPLAIN is good tool to analyze your query. 265. Why Normalizing Your Database Is Just Like Organizing Your Closet Explore database normalization in an easy-to-understand way using pet store examples. Discover the different levels from 1NF to 3NF and the importance of data 266. WunderGraph's Integration with Fauna Fauna is a distributed document-relational database delivered as a cloud API. 267. How to Query Multiple Results with Dapper ORM Efficiently Dapper is a powerful and lightweight Object-Relational Mapping (ORM) tool for C#. It is designed to be simple and fast, allowing developers to execute SQL query 268. Build Flexible GraphQL APIs by Treating the Schema like a Database Build flexible GraphQL APIs by treating the Schema like a Database 269. Ghost in Your Machine What’s more frightening than Halloween? Data migration. 270. The Importance Of Staying Humble And Strong Company Culture: Stephen Goldberg, HarperDB CEO Harper DB is a startups of the year nominee from Denver, Colorado. Stephen Goldberg, CEO, shares the origin story and what makes their company culture relevant. 271. rake db:drop 🐑 The terminal comands below will allow you to delete and re-create your Active Record database. 272. Join to Write Data Into Your First Decentralized Database The DB3 Network is a start-up project to build a decentralized, permissionless platform for programmable data processing. 273. Top 6 Databases for React Native App Development In this post, we are reviewing the best databases for React Native to help you create your new app. 274. Alibaba Cloud’s OpenSergo & ShardingSphere Release Database Governance Standard for Microservices ShardingSphere partners with Alibaba Cloud's OpenSergo to combine Database Plus & Database Mesh and release a database governance standard for microservices. 275. How technology has changed our lives Did you ever realize that technology is changing our life gingerly? In the last few years, the world has experienced some surprising inventions and technologies. All of these have made our life faster and easier. We have jotted down some major fields where technologies bring on dramatic changes. Let’s explore how it has changed our lives. 276. Spending Weekend with GraphQL Have you ever experienced an itch you just can’t scratch? If yes, then you will feel my pain. A few days back, everything was fine, I was happily writing code(!) and doing standup meetings regularly. Just before the weekend, my boss called me and shared this problem with me. 277. Database Management: Why Do Developers Prefer PostgreSQL? PostgreSQL development has built-in support for the hash table and regular B-tree indexes. The best database management system has four index access methods. 278. Generating Databases for Tests or Other Purposes Some time ago, a friend told me that she was having trouble testing a certain application. All test solutions stressed the platform correctly, generated relevant scalability results, but at the same time they looked very artificial, she said. Well, as a self-proclaimed information security student, also known as the weird-looking-guy-guy, I could adapt some of my studies to the case. 279. ShardingSphere-Proxy Front-End Protocol Troubleshooting Guide and Examples Case study: introducing the tools used in database protocol development with a troubleshooting guide for ShardingSphere-Proxy MySQL protocol issues. 280. A Mistake That Could Cost You Millions: What it Is and How to Fix It This small golang mistake could cost your business a million-dollar problem. You could easily avoid the mistake read the blog 281. Yet Another Blockchain Based OS - YABBOS What is YABBOS? 282. Applications of DistSQL: Build a Dynamic Distributed Database Taking data sharding as an example, we illustrate DistSQL's application scenarios to create a distributed database. 283. Do Not Add Database Index If It Already Exists in Rails Rails 6 added an option if_not_exists to the create_table method which will not create the table if it already exists. This option is handy when we have added a table directly in production but now want to add it through a migration so that it is available in other environments as well. 284. What Is Redis and How Can It Make Your Website 30-40% Faster? Redis is a type of database that can be used to significantly improve your website's loading speed thanks to its design and its versatile selection of modules. 285. Unexpected Discoveries in TypeORM 0.3.11 TypeORM is an ORM tool for TypeScript, supports popular databases and make it easy to interact with them. Upgrade to v0.3.11 for new features and improvements. 286. An Introduction To The GraphQL Editor v 4.5 GraphQL Editor new release 287. What Are Conflict-free Replicated Data Types (CRDTs)? In a world where most of the apps that we use on the internet are collaborative in nature, conflicts in data are common. Is there a way to avoid it? 288. Explaining Amazon RDS Through Comics Amazon RDS is the SQL Database service provided by AWS. In this blog post, learn about Amazon RDS and its feature through a comic explanation 289. Setup a GraphQL API for a Firebase Realtime Database With StepZen The Firebase Realtime Database is a NoSQL database in the cloud. It doesn't have a GraphQL API, but it has a REST API that you can convert with StepZen. 290. How Smart Analytics Can Help Small Businesses Boost Sales Technology has taken over the world, now is the time for small businesses to realize that what they need is tech. Smart analytics makes everything easier. 291. 7 Data Quality Metrics To Prioritize Having high-quality data can make or break your projects in machine learning or business management. These 7 data quality metrics have the largest impact. 292. The Newest Frontiers on the Modern Data Stack Data-driven operations are the newest frontier of the Modern Data Stack with tools. 293. 6 Reasons You Should Transition to PostgreSQL from Oracle As opposed to proprietary solutions (like Oracle), you won’t get locked in with ever-escalating license fees. Here are 6 reasons you should move to PostgreSQL. 294. The SAS (Statistical Analysis System) Response To SQL Challenges in a Data Warehouse Environment As computing hardware became more powerful, so datasets grew. SAS in turn evolved to harness greater computational power and meet the data challenge. 295. Build your own User-friendly Cross-platform Password Manager I use a local password manager on my computer: I just stick with a password, which is the only password I memorize. 296. Introducing RecallGraph (formerly CivicGraph) I had posted earlier about an open source temporal graph database that I have built, named CivicGraph. 297. SubQuery to Provide Indexing and Querying Infrastructure to Developers on Algorand SubQuery is a blockchain developer toolkit that makes it easier to build upcoming Web3 apps. 298. A Snap Is Worth A Thousand Words (Podcast Transcript) Is database migration as scary as it sounds? Amy Tom talks to Matt Groves, Senior PM Manager at Couchbase, and Curt Gratz, Co-Owner of CKH Consulting. 299. What They Don't Tell You About Headless CMS' Reflections on two headless CMS implementation projects. 300. When ORMs Disobey: A Mongoose Story In hindsight, it seems like mongoose was doing the sensible thing by simply ensuring that the document existed in the database. 301. Data Engineering Hack: Using CDPs for Simplified Data Collection From simplifying data collection to enabling data-driven feature development, Customer Data Platforms (CDPs) have far-reaching value for engineers. 302. How to Improve Data Quality in 2022 Poor quality data could bring everything you built down. Ensuring data quality is a challenging but necessary task. 100% may be too ambitious, but here's what y 303. So Much Data. So Little Time for Ineffective Searches. How can we access this data correctly? Without simplifying it or opening this door, information is just bits. 304. Blockchains Missing Ledgers - The Myth of DLTs Blockchains and DLTs are not the same thing. Here's why. 305. Improving Your Experience With CriteriaAPI Using Builder Pattern and JPA Static Metamodel - Part III An extension for the Criteria API using Builder pattern and JPA Static Metamodel Generator to reduce complexity with explicitness and to increase readability 306. A Beginner's Introduction to Database Backup Security With more companies collecting customer data than ever, database backups are key. 307. Decoding MySQL EXPLAIN Query Results for Better Performance Understanding MySQL explains query output is essential to optimize the query. EXPLAIN is good tool to analyze your query. 308. Tencent Music Transitions from ClickHouse to Apache Doris Evolution of our data processing architecture towards better performance and simpler maintenance at Tencent Music. 309. Using a Self-serve Data Architecture to Share Data Across Development Teams This article highlights synergy between the two widely adopted open-source projects, Alluxio and Presto. 310. Database Proverb: Patience is NOT a Virtue In a world of technological abundance, it can be quite a challenge to pick the right database. 311. How to Efficiently Manage Queues in SQL Databases A queue using an SQL-database? well, you need to know pros and cons, and a typical implementation. 312. A Primer on Decoupling SQL Engines from Hive Data Warehouse Are you using SQL engines, such as Presto, to query existing Hive data warehouse and experiencing challenges? 313. How to Improve Query Speed to Make the Most out of Your Data In this article, I will talk about how I improved overall data processing efficiency by optimizing the choice and usage of data warehouses. 314. How to import your MS SQL database to Amazon RDS I will show you how to create a database in the cloud, connect it to MS SQL, deploy from a database backup. 315. Using dbt with Materialize and Redpanda 316. Refi App Allows Devs to Get Through 4 Firestore Issues at Once: Learn More Refi App - A tool to make developer less painful when interacting with Firestore DB 317. Breaking the Distributed Database Performance Record with 10 Million tpmC! Apache ShardingSphere & openGauss: Breaking the Distributed Database Performance Record with 10 Million tpmC. 318. Building a REST API in Go with MongoDB Integration: A Step-by-Step Guide Code or Write a REST API with GO internal libraries and MongoDB as database 319. Kubernetes-Native Database: TiDB Vs. DataStax Astra DB A look at two databases that have made claims to the Kubernetes native label: TiDB and DataStax Astra DB. 320. An In-depth Look Into MySQL Vs. PostgreSQL PostgreSQL and MySQL are both reliable, secure and scalable databases that have been around for years. 321. What Are Redis Hashes Redis hashes are a type of record stored in a Redis database. They are little like JSON objects and store data as key-value pairs. 322. Building an Open-Source Python API (Tribal) Using the Django REST Framework - Part Three I am happy to give comprehensive tuition on building and deploying an open-source grade REST API using the Django REST framework. 323. 4 Data Transformations Made Spreadsheet-Easy Gigasheet combines the ease of a spreadsheet, the power of a database, and the scale of the cloud. 324. 10 Principles of Proper Database Benchmarking In this article, learn all about how to benchmark your DB tests. 325. Disabling Logging of (sensitive) Arguments in Active Job in Ruby [A How-To Guide] If you are using Active Job for managing background jobs in Rails, you might have noticed that it logs the job arguments when the job is enqueued or run. Let's see an example of this. 326. Apache Druid, TiDB, ClickHouse, or Apache Doris? A Comparison of OLAP Tools The OLAP experience of an automobile manufacturer. 327. Active Record Validations In Rails: How They Work ver open up a Rails console to debug a problem and come away wondering how the data got so funky? Despite our best efforts the database will accept plenty of garbage data if you let it. There are tons of methods to bypass the Rails callbacks and validations while still updating your database. If you are like me you have probably used these methods in the Rails console to fix some of that funky data you found after some other code created it in the first place. 328. How to Use Postgres to Recreate YikYak YikYak was an anonymous social network that used your location to show you posts 5km around you. Users of the app could create new posts and the people around them could view the posts and vote up or down. 329. Tips About Kafka Connect On Heroku You Can't Afford To Miss Introduction 330. Apache ShardingSphere's SPI and why it’s simpler than Dubbo’s Compared to Dubbo, the ShardingSphere SPI is more streamlined, powerful, and easier to use. This post reviews Apache ShardingSphere’s SPI, and why it’s simple. 331. How To Get Real-Time Analytics By Consolidating Databases Benchmark a Hybrid Transactional and Analytical RDBMS (Photo: Sawitre) 332. Understanding the Command Query Responsibility Segregation Pattern 333. Best Types of Data Visualization Learning about best data visualisation tools may be the first step in utilising data analytics to your advantage and the benefit of your company 334. SQL Queries: Why You Need SQL-Agnostic Parsing No need to be an expert in thousands of combinations of SQL, data types, and databases to master SQL queries. A good SQL agnostic parser will take care of all. 335. Become a Better Database Administrator [A How-To Guide] With cutting-edge technology emerging every year the future of database and cloud technologies look secure. Every organisation whether it big or small need database to store all the relatable data because data is more valuable than money itself. 336. Exploring the Neo4J Graph Database In this article you'll learn more about the NoSQL Graph database - NEO4J. 337. When and How Should You Use Merge Purge Software? Merging data entries from your company’s database, especially when it is coming in from multiple sour... 338. Introducing Apache ShardingSphere 5.2.0! ShardingSphere 5.2.0 is released bringing new cloud-native possibilities, elastic migration from Oracle, MySQL, and PostgreSQL, and more features & enhancements 339. How to Use OpenTelemetry to Identify Database Dependencies Tired of debugging your application to find out its database dependencies? There is a smarter way to track them with OpenTelemetry. 340. 10 Minute Guide to Fixing Damaged SQL Databases - No Recovery Required! In this article, I covered the use of a freeware application called FDR which can help you recover corrupt or damaged MS SQL databases. 341. The Computational Infrastructure Behind Habidatum Location Risk Score Learn about space-time indexing at scale using quadkeys and clickhouse. 342. Optimizing Database Operations With OpenTelemetry Learn to use OpenTelemetry to monitor and identify the database issues in your application and remediate them to optimise your database operations quickly. 343. A Quick Start Guide to Use ShardingSphere-Proxy in Real Production Scenarios This post describes how to use ShardingSphere-Proxy and what's its differences with ShardingSphere-JDBC. 344. Dealing With Replication, High-Performance Queries And Other Data Platforms Challenges Many products solve for global issues and load balancing but unless a platform is built from the ground up with the necessary backbones, it becomes a nightmare to manage. 345. How to protect us from unknown calls? You must be getting unknown spam calls every single week. We often see how people get into trouble by responding to these spam calls. Hence, it is important for you to have a clear understanding about what these spam calls are and how to ensure your protection against them. Then you will be able to keep the peace of mind and ensure your own privacy. 346. Analyzing 110 Million Comments from Hacker News In this article, we’ll observe another test with1.1M Hacker News curated comments with numeric fields 347. Integrating Flyway With Spring Boot Learn how to integrate FlywayDB to Spring boot application to help with adding database migration functionality to your Spring Boot project using Flyway. 348. Are MySQL replications as smooth as you think they are? What are you actually missing out on in MySQL replication? It appears easy, but to debug the problem caused by it takes a lot of time. So, here's your answer. 349. An In-Depth Guide to Blue-Green Deployments with Materialize Minimizing downtime during any deployment is a key part of any successful deployment strategy. There are many ways to achieve this. 350. Azure Data Factory: An Amazing Data Migration Tool This blog will highlight how users can define pipelines to migrate the unstructured data from different data stores to structured data via Azure Data Factory 351. Building the Next-Generation Data Lakehouse: 10X Performance How to connect various data sources easily and ensure high query performance. 352. AvionDB Introduction: A MongoDB-like Distributed Database In the past few months we have been getting this question a lot: 353. Open Source is the Only Way to Address the Long Tail of Integrations Wouldn’t it be great to bring the time needed to build a new data integration connector down to 10 minutes? This would definitely help address the long tail of 354. Understanding Database Plus Concepts and the Challenges It Can Solve Explaining the Database Plus concept, its impact on system architecture design, and its innovations from Proxyless Service Mesh to microservice backend support 355. How To Manage Sensitive Data Using SQL Data Discovery and Classification The 17.5 version of SQL Server Management Studio (SSMS) brought with it a new built-in security tool. Since then, the Data Discovery and Classification feature has become a difference-maker in the protection of sensitive information. 356. Introduction to Redis: The In-memory Database Redis is a type of database and it can be added to your production level application to make it more performant. I will cover the basics of Redis and show a real world example of Redis. 357. Collecting Data from 1.1M Hacker News Curated Comments In this test we use the data collection of 1.1M Hacker News curated comments with numeric fields from https://zenodo.org/record/45901. 358. Database Monitoring and Alerting with n8n 📡 In the past few months, I have been playing around with different kinds of IoT devices and sensors. I quite enjoy how these can be used to monitor different things like humidity, temperature, pressure among other things in the house. In this tutorial, I want to show you how you can monitor sensor readings in a database and send alerts when it crosses a threshold value using n8n workflows. 359. Creating A Meme Sharing App Using Slash GraphQL A walkthrough the process of creating a Slash GraphQL backend service to meet the needs of a fictional client, called InstaMeme. 360. How to Extract Insights From Your Data Manage data using the HarperDB database. Access your data from HarperDB using Custom Function. Automate EDA with data from the harperDB database using sweetviz. 361. Nginx Logs - Fair Database Benchmarks How one test works to analyse millions of Nginx logs from a live website and what to learn from the analysis results while processing it in a timely way. 362. Dapper Best Practices: C# Developers' Guide to Database Management Dapper is an open-source ORM tool that is easy to use and lightweight, which makes it a popular choice for .NET developers. It is designed to work with various 363. Data Testing: It's About Both Problem Detection and Quality of Response Congratulations, you’ve successfully implemented data testing in your pipeline! 364. GitOps, Kubernetes, and Databases (Podcast Transcript) Amy, Matt, and Curt talk about migrating from a SQL database to a NoSQL database, what happens when shit hits the fan, and assessing your database usage. 365. What The Shell?! (Podcast Transcript) Amy Tom chats with Michael Nitschinger, a Software Architect at Couchbase, and Jonathan D. Turner (AKA JT), the Co-Creator of NuShell, about Shell scripting. 366. From Farm To Data - A Tech Career in Product Marketing (Podcast Transcript) Amy Tom talks to Matt Groves, Senior Product Marketing Manager at Couchbase, and Rob Hedgpeth, Developer Advocate at MariaDB about their careers. 367. How To Add Action Mailbox To A Rails 6 Application Sending mail from a Rails application has been covered by hundreds or thousands of articles, however, there is not a ton of articles about receiving, parsing and using the new ActionMailbox. 368. Document Databases vs Relational Databases (Podcast Transcript) Amy Tom talks to Eric Bishard and Arun Vijayaraghavan about the differences between a Document Database and a Relational Database. 369. She's At The Edge Of The Cloud (Podcast Transcript) Amy Tom chats with Mark Gamble, the Product & Solutions Marketing Director at Couchbase, about Edge Computing and tiered data systems. Thank you for checking out the 369 most read stories about Database on HackerNoon. to find the most read stories about any technology. Visit the /Learn Repo