News, tips, guides and tools by the creators of SimpleBackups web
November 23, 2023
Find slow & long-running postgreSQL queries, kill them and optimize your database.
November 23, 2023
Find out how to list indexes in PostgreSQL together with related commands and SQL queries.
November 22, 2023
Check PostgreSQL version on Linux and macOS with easy commands and SQL queries. Ensure compatibility and make informed decisions.
November 21, 2023
Check PostgreSQL version on Linux and macOS with easy commands and SQL queries. Ensure compatibility and make informed decisions.
November 21, 2023
Check PostgreSQL version on Linux and macOS with easy commands and SQL queries. Ensure compatibility and make informed decisions.
November 14, 2023
MySQL and PostgreSQL are popular relational database systems. how do they defer on performance, features, scalability, security, and more.
June 9, 2021
Automate Postgres backups and store them remotely. Complete guide, with scripts and examples.
December 1, 2020
Extensive guide about pg_dump and pg_restore commands, how to use them to back up and restore postgresql databases (pg_dump + pg_restore exa...
October 23, 2020
There are different types of database aside from the commonly used MySQL database. You might work on a project that uses another type of dat...