Dmitry RomanoffOptimizing MySQL Database Performance: Identifying and Managing Long QueriesOptimizing MySQL Database Performance: Identifying and Managing Long Queries6 min read·May 17, 2024----
Dmitry RomanoffPython. Flipping Calendars.In the modern digital era, calendars have become indispensable tools that help us organize our lives, manage time, and stay abreast of…4 min read·May 17, 2024----
Dmitry RomanoffinDevOps.devPython. Exploring MySQL Table Sizes.This Python code is useful for monitoring the sizes of tables in a MySQL database. It connects to the database and prints out the tables…1 min read·May 16, 2024--1--1
Dmitry RomanoffPython. Automating creation backups of MySQL database.This script automates creating backups of MySQL databases, restoring them, and managing database and user creation on the destination MySQL…4 min read·May 13, 2024----
Dmitry RomanoffPython code that inserts a large number of records into a MySQL table.This Python code creates a MySQL table named my_table with columns name, age, and city.2 min read·May 13, 2024----
Dmitry RomanoffPython code that simulates talk between frogs using threads.We can use Python’s threading module to simulate the conversation between frogs using threads.2 min read·May 13, 2024----
Dmitry RomanoffPython. A conversation between the frogs.On the meadow sit five frogs. Each frog can croak once or twice. Write a Python program that simulates a conversation between the frogs.1 min read·May 13, 2024----
Dmitry RomanoffPython code to know the zodiac sign based on the provided birthday.This Python code determines the zodiac sign based on the provided birthday in the format “DD-MM”. For each zodiac sign, corresponding date…3 min read·May 13, 2024----
Dmitry RomanoffHow to check a distribution of values that PostgreSQL has collected on some column of a table?To check the distribution of values that PostgreSQL has collected on some column of a table, you can use the pg_stats system catalog table…2 min read·May 3, 2024----
Dmitry RomanoffinDev GeniusHow the presence of indexes and the size of tables affect the choice of execution plan when joining…When we talk about databases, a very interesting aspect is understanding how the optimizer chooses the execution plan for queries.7 min read·May 3, 2024----