Posts tagged "database"

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

What's New in MySQL 9 - a DBA's Perspective

Release Timeline MySQL 9.0.0: July 1, 2024 (Innovation Release) - Removed from distribution due to critical bug MySQL 9.0.1: Released as replacement for 9.0.0 MySQL 9.1.0: October 15, 20...

29.04.2025 0 Read More

#34 50 Advanced SQL Queries Every Developer Should Know

SQL is a powerful language for managing and querying relational databases. While basic queries like SELECT, INSERT, UPDATE, and DELETE are essential, mastering advanced SQL techniques can significantl...

29.04.2025 0 Read More

How to Design a Write-Heavy System: A Beginner-Friendly Guide You’ll Want to Bookmark

When designing a system that handles a lot of incoming data—like transactions, logs, messages or orders—your priority is not reading that data, but writing it fast and efficiently. These systems a...

29.04.2025 0 Read More

SQL: The Secret Weapon Behind Data Analytics and Data Science

In today’s era, businesses, companies and organisations thrive more on data insights. Whether it’s understanding customer behaviour, staff behaviour, analysing the products and services in markets...

29.04.2025 0 Read More

I built a blazing-fast AI-Powered SQL editor ⚡️

Hello!If you're like me, you've probably spent countless frustrating hours wrestling with clunky, slow SQL clients. I was tired of feeling frustrated every time I had to write, organize, or manage som...

29.04.2025 0 Read More

Export database tables to Excel with one click

At work, we often need to export database tables to Excel. Usually we use the export function provided by tools such as database editors to export, but their export functions are usually relatively si...

29.04.2025 0 Read More

Understanding Complex Database Concepts: An In-Depth Guide

Welcome! In the world of software development, databases are the bedrock upon which applications are built. While basic CRUD (Create, Read, Update, Delete) operations are fundamental, truly robust, sc...

30.04.2025 0 Read More

How to simplify the Merge Operations Across Tables from Multiple Databases

Due to business requirements, data is stored by year in two structurally identical databases. To perform statistical analysis on this data, it will involve cross-database computation. Implementing thi...

30.04.2025 0 Read More

#35 Python & Alteryx Integration: Unlocking Advanced Analytics

Introduction Alteryx is a powerful data analytics platform known for its intuitive workflow-based approach to data preparation, blending, and advanced analytics. While Alteryx provides a rich...

30.04.2025 0 Read More

Database Sharding 101

The systemWhen we start with designing large scale systems, we usually have a three tier set up. The frontend(client), backend(app servers) and the database server. We start development with such an i...

30.04.2025 0 Read More

What's New in MySQL 9 - a DBA's Perspective

#34 50 Advanced SQL Queries Every Developer Should Know

How to Design a Write-Heavy System: A Beginner-Friendly Guide You’ll Want to Bookmark

SQL: The Secret Weapon Behind Data Analytics and Data Science

I built a blazing-fast AI-Powered SQL editor ⚡️

Export database tables to Excel with one click

Understanding Complex Database Concepts: An In-Depth Guide

How to simplify the Merge Operations Across Tables from Multiple Databases

#35 Python & Alteryx Integration: Unlocking Advanced Analytics

Database Sharding 101

#reading

#popular