Dmitry RomanoffHow to Fix Docker Error: “docker.errors.DockerException:If you encounter the error docker.errors.DockerException: Error while fetching server API version: Not supported URL scheme http+docker, it…6d ago6d ago
Dmitry RomanoffUnderstanding Recursive Queries in PostgreSQL: A Process Hierarchy ExampleIn the world of databases, hierarchical data can often be tricky to handle. PostgreSQL, however, offers a powerful feature for this task…Aug 5Aug 5
Dmitry RomanoffPython code that generates a stock price chart for the last n days.Here’s a detailed description of what each part of the code does:Aug 5Aug 5
Dmitry RomanoffPostgreSQL. “Fatal error: failed to delete Postgres user.”You are trying to delete a PostgreSQL database user and encounter the following error:Jul 19Jul 19
Dmitry RomanoffPostgres. How to move old historical records from your main table to a separate table?I often encounter databases containing tables with old historical data. Such tables become heavy, occupy a lot of disk space, their indexes…Jul 18Jul 18
Dmitry RomanoffProactive PostgreSQL Database(s) Performance ScannerA critical situation in the system. CPU has reached one hundred percent. There is an urgent need to find a solution.Jul 13Jul 13
Dmitry RomanoffAWS Aurora Global DatabaseAurora Global Database is an option supported on AWS Aurora MySQL and PostgreSQL engines enabling two primary use cases.Jul 13Jul 13
Dmitry RomanoffOptimizing MySQL Database Performance: Identifying and Managing Long QueriesOptimizing MySQL Database Performance: Identifying and Managing Long QueriesMay 17May 17
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…May 17May 17
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…May 161May 161