Articles

Databases play a crucial role in modern software development, but selecting the right one can be challenging. SQL and NoSQL databases have distinct characteristics that make them suitable for different use cases.

Most performance war rooms start with the same sentence, but the real challenge lies in identifying and addressing the underlying bad queries that hinder database performance.

Discover how a simple SQL validation tool can save you from the stress of running malformed queries on a live database.

In this article, we'll delve into the world of vacuuming in PostgreSQL and explore its importance in maintaining database performance and integrity.

In this article, the author attempts to prove that SQL Server is slower on Linux but ultimately fails to demonstrate a significant performance difference.

Discover how to deploy a zero-cost SaaS project with Koyeb.com, a serverless platform that eliminates infrastructure costs.

Many developers struggle to understand database normalization, which is essential for efficient relational database design. This article delves into the truth about database normalization and its importance in database design.

SQL cursors are a powerful tool for row by row processing, enabling you to work with large datasets one row at a time. By using cursors, you can improve database performance and optimize query results.

A PostgreSQL database wraparound incident can be devastating. Discover the importance of having a runbook in place to prevent data loss and ensure business continuity.

By following this article, you'll have a fully functional web app running on your own computer that works just like the cloud version of Notion.

In high-availability databases, replication is essential for scalability and disaster recovery. MySQL offers three binary logging methods: statement, row, and mixed. Understanding the differences between these methods is crucial for effective database management.

For 20 years, PostgreSQL's fsync guarantees have been a topic of debate. A software engineer takes a closer look at the OS-level durability and the infamous 'fsyncgate' bug.