Tag: Database
-
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 sql 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 sql 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 sql 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
-
Apache Cassandra: An essentials guide
Posted on August 25, 2020, Level intermediate Resource Length long
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. By Rebecca Mills, Developer Relations @ DataStax.
Tags apache database nosql cloud big-data
-
Introduction to Python SQL libraries
Posted on June 12, 2020, Level intermediate Resource Length long
All software applications interact with data, most commonly through a database management system (DBMS). You will develop a straightforward application to interact with SQLite, MySQL, and PostgreSQL databases. By Usman Malik.
Tags python sql database software-architecture
-
Setting SSL/TLS protocol versions with PostgreSQL 12
Posted on March 28, 2020, Level intermediate Resource Length medium
Straight to the point tutorial about setting SSL/TLS protocol versions in open source database PostgresQL. Published by Peter Eisentraut.
Tags infosec database devops performance servers
-
How container networking affects database performance
Posted on March 20, 2020, Level intermediate Resource Length medium
An article by Percona team about building and releasing Operators for Kubernetes to run traditional databases in a cloud-native fashion. They released Percona Server for MongoDB and Percona XtraDB Cluster; they were chosen because they both feature replication systems that can be made to work effectively in a containerized world.
Tags database sql performance devops kubernetes
-
Flexible MariaDB server Query Cache
Posted on March 5, 2020, Level intermediate Resource Length medium
The Server Query Cache (QC) is a well-known feature of MariaDB Server–it caches SQL statements and the corresponding result sets. Today we have faster, solid-state disks and more RAM, so the Query Cache is less important. Reducing reliance on cache alleviates its negative effects, such as mutex blocking. By Anders Karlsson.
Tags sql database devops miscellaneous
-
How to automate PostgreSQL 12 replication and failover with repmgr
Posted on February 17, 2020, Level intermediate Resource Length long
An article about using repmgr for Postgres replication failover. repmgr is an open-source toolset from 2ndQuadrant, a leading specialist in PostgreSQL-related technologies and services. The product is used to automate, enhance, and manage PostgreSQL streaming replication. By Sadequl Hussain.
Tags distributed database performance