When to Use JSON in Your Database
In this blog, you will learn when you should consider adding JSON data types to your tables and when you should avoid them.
10 months ago
Antonello Zanini
I'm a software engineer, but I prefer to call myself a Technology Bishop. Spreading knowledge through writing is my mission.
How To Design a Multi-Language Database
In this blog, we look at three best-practice database designs to store data in multiple languages and easily scale to new markets.
10 months ago
A Complete Guide to Generated Columns in MySQL
Generated columns in MySQL pose as a powerful, easy-to-use, and advanced tool for anyone who wants to add automatically generated data to their tables - in this blog, we will learn everything you need to know to master them.
a year ago
Improving performance in a hierarchical SQL table structure with column propagation
Column propagation can help address the typical performance issues associated with hierarchical table structures which are inherently slow. Let’s learn how!
a year ago
Partitioning a billion-row table of soccer data using data context
Why you should study your application domain when defining efficient partitioning criteria for your database.
a year ago
How to fix a sequence when it goes out of sync in Postgres
Let's learn how to identify and then fix the out-of-sync issue leading to the "duplicate key value violates unique constraint" message error that occurs with PostgreSQL sequences.
a year ago
Improving performance with SQL aggregate functions
SQL aggregate functions helped me take the performance of my backend application to the next level and avoid the bottlenecks that were slowing it down.
a year ago