The SimpleBackups Blog
News, tips, guides and tools by the creators of SimpleBackups
Latest Post
Introducing Supabase Object Storage Support
At SimpleBackups, we're committed to ensuring that your data is safe, accessible, and easily manageable, no matter where it's stored. With…
Elevating Our Commitment: SimpleBackups Earns ISO Certification
December 4, 2023
Today, we are thrilled to announce a significant milestone in our journey towards providing the utmost security and quality in our services…
PostgreSQL vs MongoDB: A Comprehensive Comparison
December 1, 2023
Picking the right open-source database for your next project can be a challenging task, as there is no one-size-fits-all solution. In this…
Mastering PostgreSQL Data Types: A Comprehensive Guide
November 30, 2023
In PostgreSQL, data types shape how the database manages, retrieves, and processes information. They define the characteristics of the data…
Server-Side Encryption with SSE-C in Cloud Object Storage
November 28, 2023
Have you ever wondered what the Server-Side Encryption is and how to use it? Simply put, it is a system for encrypting data, which is done…
How to find long-running queries in PostgreSQL
November 23, 2023
Long queries can slow down your system/app, and it will be helpful to be able to identify them and kill if needed. These few PostgreSQL…
How to List Indexes in PostgreSQL and Related Commands
November 23, 2023
Indexes in PostgreSQL are objects used to improve the speed of accessing data. They are created based on either database columns or partial…
How to List Schemas in PostgreSQL and Related Commands
November 22, 2023
Schema in PostgreSQL is nothing more than a folder in the sense of a standard operating system - it contains tables, views, and other…
Understanding Postgres Roles & Privileges
November 21, 2023
One of the main features of PostgreSQL is an access control system that allows administrators to assign roles and permissions. In this…
How to check PostgreSQL version
November 21, 2023
Have you ever had compatibility problems with specific features in a PostgreSQL database? The first thing in such cases is to check what…