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.
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.
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.
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 mysql 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.
The rise and fall of the OLAP Cube
Posted on January 30, 2020, Level beginner Resource Length long
One of the biggest shifts in data analytics over the past decade is the move away from building "data cubes", or "OLAP cubes", to running OLAP workloads directly on columnar databases. By Cedric Chin.
SQL Injection: A beginner's guide for WordPress users
Posted on January 22, 2020, Level beginner Resource Length medium
SQL injection, or SQLi, is an attack on a web application by compromising its database through malicious SQL statements. As it's a common attack, let's try to learn more about what it is, how it happens, and how to defend yourself from it. By Shaunik Daityari.
Tags mysql database miscellaneous cloud
Geospatial queries, reinvented
Posted on December 12, 2019, Level interemediate Resource Length long
In this article author goes through the details of how Beat managed to achieve lightning fast queries during the driver dispatching process; getting the nearest driver to a passenger. by Fotis Papadopoulos.
Building a distributed time-series database on PostgreSQL
Posted on October 18, 2019, Level intermediate Resource Length long
TimescaleDB, a time-series database on PostgreSQL, has been production-ready for over two years, with millions of downloads and production deployments worldwide. Authors publicly shared their design, plans, and benchmarks for the distributed version of TimescaleDB. By Mike Freedman and Erik Nordström.
Managing hundreds of millions of orders with Table Store
Posted on September 16, 2019, Level intermediate Resource Length medium
This article discusses how Table Store can help you store and manage massive amounts of data by using a fictional e-commerce platform as an example.
To run or not to run a database on Kubernetes: What to consider
Posted on July 21, 2019, Level beginner Resource Length short
Benjamin Good, Solutions Architect, Google Cloud, wrote this piece in which he considers if you should run a database on Kubernetes. Today, more and more applications are being deployed in containers on Kubernetes—so much so that we've heard Kubernetes called the Linux of the cloud.
Tags database devops kubernetes google
Look at how Twitter handles its time series data ingestion challenges
Posted on June 11, 2019, Level intermediate Resource Length short
Ram Dagar is author of this overview on the time series topic. The components of time-series are as complex and sophisticated as the data itself. With increasing time, the data obtained increases and it doesn't always mean that more data means more information but, larger sample avoids the error that due to random sampling.