Tag: Database
-
How to handle one-to-many relationships in NoSQL databases
Posted on July 11, 2021, Level beginner Resource Length medium
Data modeling in NoSQL is trickier than normal SQL. Sometimes, it goes against our intuition. Especially coming from an SQL background, I found it hard to comprehend the various reasons behind the data modeling in NoSQL databases like AWS DynamoDB or Firebase. By Mohammad Faisal.
Tags database nosql app-development performance
-
Neo4j 4.3: Relationship indexes
Posted on July 8, 2021, Level beginner Resource Length medium
The new index types in Neo4j 4.3 work in much the same way as Node and Node Property indexes do -- they enable you to quickly look up where there are references to a particular Relationship Type in the graph (i.e. which Nodes are connected by the relationship). By Stu Moore, Product Manager.
Tags data-science cloud database nosql
-
Behind the scenes of creating the world's biggest graph database
Posted on July 3, 2021, Level intermediate Resource Length long
How we'd decided to try and build the biggest graph database that has ever existed. By Chris Gioran.
Tags database queues search performance cloud devops aws streaming
-
Postgres is out of disk and how to recover: The dos and dont's
Posted on April 22, 2021, Level intermediate Resource Length medium
Welp ... sometimes "stuff" happens ... and you find yourself having a really bad day. We'd like to believe that every database is well configured from the start with optimal log rotation, correct alerting of high CPU consumption and cache hit ratio monitoring. By Elizabeth Christensen.
Tags mysql database teams programming agile
-
How we implemented Distributed Multi-document ACID Transactions in Couchbase
Posted on March 24, 2021, Level advanced Resource Length long
ACID Transactions are a must when you have strict data consistency requirements in your application. The costs of running transactions on distributed systems can rapidly create bottlenecks at scale. By Denis Rosa, Developer Advocate, Couchbase.
Tags database cloud cio nosql software-architecture
-
DynamoDB checklist
Posted on March 14, 2021, Level intermediate Resource Length medium
DynamoDB is the leading serverless database in the AWS suite of offerings. It provides an easy to configure, high-performance, NoSQL database with low operational overhead and almost endless scalability. By SenseDeep.
Tags serverless nosql miscellaneous database aws
-
10 reasons to use Azure SQL in your next project
Posted on February 7, 2021, Level beginner Resource Length long
There are many database technologies available on Azure that you can choose from. Why would you use Azure SQL. By Davide.
Tags azure database cloud cio
-
Firestore and authentication
Posted on January 11, 2021, Level beginner Resource Length medium
Firebase authentication makes it easy to add user identities to your app. When combined with Firestore, it can help to secure user data. By Steve Marx.
Tags nosql software infosec database
-
NULL values in SQL queries
Posted on December 24, 2020, Level beginner Resource Length medium
This post is about NULL values in SQL, and comes courtesy of my friend and database wizard, Kaley. You should check out his website if you'd like to learn more about SQL, Oracle database, and making queries run faster. By Mitchum.
Tags data-science mysql database programming
-
InnoDB Data Locking – Part 1 Introduction
Posted on October 20, 2020, Level intermediate Resource Length long
In this blog series, we would like to introduce you gently to the topic on which we were working over last 2 years. Improving how InnoDB locks data (tables and rows) in order to provide illusion to clients that their queries are executed one after another, while in reality there is a lot of concurrency. By Kuba Łopuszański.
Tags cloud mysql database devops software performance
-
Zero downtime on MySQL schema change
Posted on October 19, 2020, Level beginner Resource Length short
Have you ever deployed a feature which interrupted your application because the schema change on the MySQL database has locked the table? Then I have good news for you! There are some tools like the Percona Toolkit which can apply the operation without a downtime. By Michi Lehr.
Tags cloud mysql database devops performance
-
AWS NoSQL: Choosing the best option for you
Posted on September 15, 2020, Level intermediate Resource Length medium
NoSQL databases enable you to store data with flexible schema and a variety of data models. These databases are relatively easy for developers to use, and have the high performance and functionality needed for modern applications. NoSQL databases can hold large volumes of data while still providing low latency. By Yifat Perry.
Tags nosql cloud cio database software-architecture