News, tips, guides and tools by the creators of SimpleBackups web
December 1, 2023
PostgreSQL and MongoDB are popular DBMSs. Learn how they defer on performance, features, scalability, security, and more.
November 30, 2023
Every PostgreSQL data type with its storage size, plus how to choose between the pairs that trip people up: varchar and text, timestamp and ...
November 28, 2023
Explore our in-depth guide on Server-Side Encryption with Customer-Provided Keys (SSE-C). Learn how to securely upload and download data usi...
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
Three ways to list schemas in PostgreSQL, with psql, a catalog query and pgAdmin, plus how to read a single table's structure and check sche...
November 21, 2023
How PostgreSQL roles differ from users, how to grant and revoke privileges, and how inheritance decides what each role can actually do.
November 21, 2023
Check your PostgreSQL version on Linux, macOS, Windows or in pgAdmin, with the commands for each and what to do when psql is not on your PAT...
November 17, 2023
Discover the latest trends in database backup and recovery solutions, ensuring the safety and reliability of your valuable data.
