Migrating to utf8mb4: MySQL things to consider
Posted on May 1, 2022, Level intermediate Resource Length medium
The utf8mb4 character set is the new default as of MySQL 8.0, and this change neither affects existing data nor forces any upgrades. By Sveta Smirnova.
MySQL 8: Password verification policy
Posted on April 28, 2022, Level intermediate Resource Length medium
The artcicle discusses the password verification-required policy introduced in MySQL 8.0.13. With this feature, it is possible to require that attempts to change an account password be verified by specifying the existing current password to be replaced. By Brian Sumpter.
Tiered datastore solution for high data growth MySQL using Distributed SQL Databases (DSQL)
Posted on December 10, 2021, Level intermediate Resource Length medium
Usually, entities like order, order items etc tend to grow substantially year on year as we scale more and serve large customers. Generally, MySQL is the widely used datastore due to its durable & ACID guarantees. While MySQL is a brilliant tech stack, it comes with the overhead of data maintenance. By Manohar K.
Tags cloud database mysql cio distributed
How does an SQL injection attack work? Examples & types
Posted on December 6, 2021, Level intermediate Resource Length medium
A SQL injection (SQLi) attack is one of the most threatening issues for data integrity and confidentiality today, allowing attackers to access secure data where they are not authorized. In this article, we discuss SQLi and how these attacks work, with types and examples. By Al Mahmud Al Mamun.
Transitioning from MySQL to MongoDB
Posted on November 7, 2021, Level beginner Resource Length long
This article will not discuss the different types of database systems, like RDBMS and so on. We will, however, focus on two concepts: SQL Databases and NoSQL databases. By @peteradeojo.
Hosting SQLite databases on Github Pages
Posted on October 25, 2021, Level beginner Resource Length medium
I was writing a tiny website to display statistics of how much sponsored content a Youtube creator has over time when I noticed that I often write a small tool as a website that queries some data from a database and then displays it in a graph, a table, or similar. But if you want to use a database, you either need to write a backend (which you then need to host and maintain forever) or download the whole dataset into the browser (which is not so great when the dataset is more than 10MB). By phiresky's blog.
Postgres full-text search: Search engine in a database
Posted on October 9, 2021, Level intermediate Resource Length medium
So when we say PostgreSQL is the "batteries included database," this is just one reason why. With Postgres, you don't need to immediately look farther than your own database management system for a full-text search solution. If you haven't yet given Postgres' built-in full-text search a try, read on for a simple intro. By Kat Batuigas.
ETL pipeline from AWS DynamoDB to Aurora PostgreSQL
Posted on July 20, 2021, Level intermediate Resource Length long
In a world where an ever-increasing amount of data is being gathered, companies often find themselves without the tools to optimally use the often unstructured data they've gathered. By trackit.io.
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
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.
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.
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