DEV Community

Dmitry Romanoff profile picture

Dmitry Romanoff

404 bio not found

Joined Joined on  github website
Creating a Professional-Quality Slideshow with Python: A Guide to Building Your Own iMovie Alternative
dm8ry profile

Creating a Professional-Quality Slideshow with Python: A Guide to Building Your Own iMovie Alternative

#python #coding #startup
Comments
6 min read

Want to connect with Dmitry Romanoff?

Create an account to connect with Dmitry Romanoff. You can also sign in below to proceed if you already have an account.

Create Account
Already have an account? Sign in
How to Run an Application In A Docker Container: A Step-by-Step Guide
dm8ry profile

How to Run an Application In A Docker Container: A Step-by-Step Guide

#docker #devops #howto #tutorial
19
Comments 3
3 min read
Creating Dynamic Audio Narratives: A Guide to Combining Text-to-Speech and Music Using Python
dm8ry profile

Creating Dynamic Audio Narratives: A Guide to Combining Text-to-Speech and Music Using Python

#showdev #python #coding #programming
5
Comments
3 min read
Visualizing Options Flow with Python: A Step-by-Step Guide
dm8ry profile

Visualizing Options Flow with Python: A Step-by-Step Guide

#python #coding #tutorial #programming
Comments
4 min read
Automate Foreign Key Index Checks in PostgreSQL: A Practical Bash Script
dm8ry profile

Automate Foreign Key Index Checks in PostgreSQL: A Practical Bash Script

#postgres #database #bash #automation
Comments
5 min read
Optimizing PostgreSQL Buffer Cache: Automating Analysis with a Bash Script
dm8ry profile

Optimizing PostgreSQL Buffer Cache: Automating Analysis with a Bash Script

#postgres #bash #database #postgressql
1
Comments
4 min read
How to Automate Image Downloading with Python: A Comprehensive Guide
dm8ry profile

How to Automate Image Downloading with Python: A Comprehensive Guide

#python #howto #tutorial #coding
2
Comments
3 min read
Monitoring and Managing AWS RDS Snapshot Storage Across All Regions
dm8ry profile

Monitoring and Managing AWS RDS Snapshot Storage Across All Regions

#aws #devops #howto #database
Comments
3 min read
Understanding Recursive Queries in PostgreSQL: A Process Hierarchy Example
dm8ry profile

Understanding Recursive Queries in PostgreSQL: A Process Hierarchy Example

#postgres #database #howto #sql
Comments
3 min read
“docker.errors.DockerException: Error while fetching server API version: Not supported URL scheme http+docker”
dm8ry profile

“docker.errors.DockerException: Error while fetching server API version: Not supported URL scheme http+docker”

#docker #devops #howto #tutorial
2
Comments
3 min read
Automating Database Health Checks with Python: A Step-by-Step Guide
dm8ry profile

Automating Database Health Checks with Python: A Step-by-Step Guide

#database #monitoring #devops #tutorial
3
Comments
6 min read
Efficiently Managing AWS Unattached Volumes with a Shell Script
dm8ry profile

Efficiently Managing AWS Unattached Volumes with a Shell Script

#aws #devops #howto #tutorial
Comments
2 min read
How to Check Fragmentation in an Oracle Database
dm8ry profile

How to Check Fragmentation in an Oracle Database

#database #devops #howto #monitoring
1
Comments
4 min read
PostgreSQL. “Fatal error: failed to delete Postgres user.”
dm8ry profile

PostgreSQL. “Fatal error: failed to delete Postgres user.”

#database #postgres #devops #productivity
Comments 1
3 min read
PostgreSQL. How to move old historical records from your main table to a separate table?
dm8ry profile

PostgreSQL. How to move old historical records from your main table to a separate table?

#database #howto #postgres #sql
5
Comments
4 min read
AWS Aurora Global Database
dm8ry profile

AWS Aurora Global Database

#aws #database #cloud #postgres
Comments
3 min read
Optimizing MySQL Database Performance: Identifying and Managing Long Queries
dm8ry profile

Optimizing MySQL Database Performance: Identifying and Managing Long Queries

#mysql #database #devops #monitoring
1
Comments
4 min read
Python. Flipping Calendars.
dm8ry profile

Python. Flipping Calendars.

#python #programming #howto #tutorial
1
Comments
4 min read
Python. Exploring MySQL Table Sizes.
dm8ry profile

Python. Exploring MySQL Table Sizes.

#mysql #python #monitoring #tutorial
1
Comments
1 min read
How the presence of indexes and the size of tables affect the choice of execution plan when joining tables in PostgreSQL?
dm8ry profile

How the presence of indexes and the size of tables affect the choice of execution plan when joining tables in PostgreSQL?

#postgres #devops #database #performance
2
Comments
7 min read
Populating a table in PostgreSQL with one million records of random data.
dm8ry profile

Populating a table in PostgreSQL with one million records of random data.

#postgres #database #sql #tutorial
1
Comments
1 min read
The main methods of joining tables in PostgreSQL.
dm8ry profile

The main methods of joining tables in PostgreSQL.

#database #postgres #sql #tutorial
Comments
3 min read
The ARRAY_TO_STRING() function in PostgreSQL
dm8ry profile

The ARRAY_TO_STRING() function in PostgreSQL

#postgres #database #sql #tutorial
Comments
2 min read
How do you check a distribution of values that PostgreSQL has collected on some column of a table?
dm8ry profile

How do you check a distribution of values that PostgreSQL has collected on some column of a table?

#postgres #database #devops #tutorial
2
Comments
2 min read
Python code to know the zodiac sign based on the provided birthday.
dm8ry profile

Python code to know the zodiac sign based on the provided birthday.

#python #codenewbie #programming
1
Comments
2 min read
Python code that inserts a large number of records into a MySQL table.
dm8ry profile

Python code that inserts a large number of records into a MySQL table.

#mysql #python #database #postgres
Comments
2 min read
Python. Automating creation backups of MySQL database.
dm8ry profile

Python. Automating creation backups of MySQL database.

#python #mysql #devops #database
Comments
4 min read
How to calculate the distance between Kyoto and Tokyo using a PostgreSQL database?
dm8ry profile

How to calculate the distance between Kyoto and Tokyo using a PostgreSQL database?

#postgres #database #sql #howto
3
Comments 1
2 min read
DevOps. Monitoring Databases. On-Premise and Cloud Environments.
dm8ry profile

DevOps. Monitoring Databases. On-Premise and Cloud Environments.

#monitoring #database #postgres #devops
1
Comments
1 min read
PostgreSQL: Deleting all records from a table, except for the first and last ones.
dm8ry profile

PostgreSQL: Deleting all records from a table, except for the first and last ones.

#postgres #database #sql #data
3
Comments
2 min read
How to find the third and fifth-highest values in a PostgreSQL table?
dm8ry profile

How to find the third and fifth-highest values in a PostgreSQL table?

#postgres #database #howto #sql
2
Comments
2 min read
Understanding of NULL in PostgreSQL database.
dm8ry profile

Understanding of NULL in PostgreSQL database.

#postgressql #database #sql #howto
3
Comments
2 min read
How to join tables in PostgreSQL using the WITH clause?
dm8ry profile

How to join tables in PostgreSQL using the WITH clause?

#postgres #database #sql #howto
1
Comments
2 min read
PostgreSQL. How to check connections that are not using SSL encryption?
dm8ry profile

PostgreSQL. How to check connections that are not using SSL encryption?

#security #database #postrges #devops
2
Comments
2 min read
Statistical information about tables in a PostgreSQL Database.
dm8ry profile

Statistical information about tables in a PostgreSQL Database.

#postgres #database #sql #devops
3
Comments
2 min read
About transaction identifier (transaction_id) in PostgreSQL.
dm8ry profile

About transaction identifier (transaction_id) in PostgreSQL.

#postgres #devops #database #sql
8
Comments
2 min read
How to check if the PostgreSQL tables of the same structure have identical data using aggregated hash and md5?
dm8ry profile

How to check if the PostgreSQL tables of the same structure have identical data using aggregated hash and md5?

#devops #database #postgres #howto
1
Comments
2 min read
How to check the distribution of timestamps in a PostgreSQL table?
dm8ry profile

How to check the distribution of timestamps in a PostgreSQL table?

#postgres #database #sql #devops
Comments
3 min read
How to check if the PostgreSQL tables of the same structure have identical data using aggregated hash and md5?
dm8ry profile

How to check if the PostgreSQL tables of the same structure have identical data using aggregated hash and md5?

#howto #postgres #sql #database
Comments
2 min read
Getting error when starting Rancher Desktop on Mac.
dm8ry profile

Getting error when starting Rancher Desktop on Mac.

#devops #docker #opensource #howto
Comments
1 min read
How to find the number of SELECTs, INSERTs, DELETEs, and UPDATEs on a specific table in PostgreSQL?
dm8ry profile

How to find the number of SELECTs, INSERTs, DELETEs, and UPDATEs on a specific table in PostgreSQL?

#database #tutorial #devops #postgressql
2
Comments
1 min read
How do you check the top IOPs intensive queries in PostgreSQL DB?
dm8ry profile

How do you check the top IOPs intensive queries in PostgreSQL DB?

#database #devops #sql #performance
Comments
2 min read
PostgreSQL. How do you find potentially ineffective indexes?
dm8ry profile

PostgreSQL. How do you find potentially ineffective indexes?

#database #postgres #sql #devops
Comments
2 min read
Unveiling Differences: A Deep Dive into Comparing Tables, Indexes, and Functions Across PostgreSQL Databases
dm8ry profile

Unveiling Differences: A Deep Dive into Comparing Tables, Indexes, and Functions Across PostgreSQL Databases

#database #postgres #sql #howto
Comments
7 min read
How to reset pg_stat_database statistics for all DBs on a PostgreSQL Server?
dm8ry profile

How to reset pg_stat_database statistics for all DBs on a PostgreSQL Server?

#postgres #database #devops #bash
1
Comments
2 min read
How to check the number of queries per second (QPS) on the PostgreSQL DB instance?
dm8ry profile

How to check the number of queries per second (QPS) on the PostgreSQL DB instance?

#postgres #database #sql #devops
5
Comments
1 min read
How to check the number of transactions per second (TPS) for the given PostgreSQL DB instance?
dm8ry profile

How to check the number of transactions per second (TPS) for the given PostgreSQL DB instance?

#postgres #devops #bash #database
4
Comments
2 min read
PostgreSQL: pg_stat_reset() is not resetting all statistics counters.
dm8ry profile

PostgreSQL: pg_stat_reset() is not resetting all statistics counters.

#postgres #devops #database
Comments
1 min read
How do you check temporary file generation for each PostgreSQL DB on the Server?
dm8ry profile

How do you check temporary file generation for each PostgreSQL DB on the Server?

#postgres #database #devops #sql
Comments
1 min read
PostgreSQL: script to connect to DB, and get tables, their records number and size.
dm8ry profile

PostgreSQL: script to connect to DB, and get tables, their records number and size.

#postgres #database #devops #bash
1
Comments 1
2 min read
MySQL: ERROR 1227 (42000) at line 27: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
dm8ry profile

MySQL: ERROR 1227 (42000) at line 27: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

#mysql #devops #database #howto
Comments
1 min read
Python: How to check telnet status?
dm8ry profile

Python: How to check telnet status?

#python #devops #programming #tutorial
Comments
1 min read
Postgres. How to check the top queries that use temporary files?
dm8ry profile

Postgres. How to check the top queries that use temporary files?

#postgres #sql #devops #performance
1
Comments
1 min read
PostgreSQL. How to list the most IOPs-intensive queries?
dm8ry profile

PostgreSQL. How to list the most IOPs-intensive queries?

#postgres #sql #database #devops
3
Comments
1 min read
Postgres: DB parameters configuration on the level of User / Database
dm8ry profile

Postgres: DB parameters configuration on the level of User / Database

#postgres #database #sql #devops
1
Comments
1 min read
Postgres Order By: the resultset is sorted differently
dm8ry profile

Postgres Order By: the resultset is sorted differently

#postgres #database #devops #sql
1
Comments
1 min read
PostgreSQL DB Server. The read-only user is able to create and own tables.
dm8ry profile

PostgreSQL DB Server. The read-only user is able to create and own tables.

#postgressql #database #devops #sql
1
Comments
2 min read
How to estimate the number of rows and size of tables in Postgres DB?
dm8ry profile

How to estimate the number of rows and size of tables in Postgres DB?

#devops #postgres #database
1
Comments
1 min read
How to limit the number of connections on the level of the DB user / Database in the Postgres Server?
dm8ry profile

How to limit the number of connections on the level of the DB user / Database in the Postgres Server?

#postgres #devops #tutorial #database
2
Comments
1 min read
ERROR: permission denied to create extension "pg_trgm". HINT: Must be part of the azure_pg_admin role to create this extension.
dm8ry profile

ERROR: permission denied to create extension "pg_trgm". HINT: Must be part of the azure_pg_admin role to create this extension.

#devops #postgres #database #performance
1
Comments
2 min read
loading...