Universally Unique IDs (UUIDs) use random numbers to create unique IDs. UUIDs use more storage, but they provide a good solution for distributed databases and security.

SQL

PostgreSQL

Anatomy of a PostgreSQL Query Plan

9 Apr 2021 by Arctype SQL

Explanation of how a query gets execution and understanding the EXPLAIN command

How to Configure Extensions for Azure Postgres Flexible Server

21 Dec 2022 by Jeffrey T. Fritz

Migrate Azure Postgres database to a Flexible Server

PostgreSQL

Azure

Deploy and Manage PostgreSQL on Kubernetes

31 Mar 2021 by Arctype SQL

Easily deploy PostgreSQL pod in Kubernetes

Installing and Configuring PostgreSQL 9.4 on Linux Mint/Ubuntu

22 Apr 2015 by John Atten

Installing and configuring PostgreSQL on a Linux box is either simple, because you are a Linux and/or Postgres expert, or not so simple, because you are new(er) to Linux, Postgres, or both. Over the past year, I have resided firmly in the latter camp.

SQL

Linux

PostgreSQL

Need a UUID Generator for Postgres? Here are Two Ways to Set One Up.

1 Dec 2021 by Arctype SQL

In this article, you'll learn about Postgres UUIDs and how to generate them with examples from two different modules.

SQL

PostgreSQL

Migrating your SQL Server Workloads to PostgreSQL

22 Sep 2019 by Shameel

This multi-part article series discuss migrating your databases, applications and services from SQL Server to PostgreSQL and discusses all the important information you need to be aware of, before beginning a migration project..

PostgreSQL 12: New Features and Enhancements

21 Sep 2019 by Shameel

This article walks you through the summary of most important new features. enhancements and breaking changes in PostgreSQL 12.. The post PostgreSQL 12: New Features and Enhancements appeared first on The Developer Space..

Migrating your SQL Server Workloads to PostgreSQL – Part 4

21 Sep 2019 by Shameel

Part 4 of this multi-part article series discusses Maintenance and Monitoring, High Availability, Load Balancing, and Replication and Environment Stabilization.. The post Migrating your SQL Server Workloads to PostgreSQL – Part 4 appeared first on The Developer Space..

PostgreSQL finally gets Stored Procedures

21 Sep 2019 by Shameel

This article describes the new Stored Procedure feature in PostgreSQL 11.5 and shows you how it differs from Functions.. The post PostgreSQL finally gets Stored Procedures appeared first on The Developer Space..

Migrating your SQL Server Workloads to PostgreSQL – Part 3

22 Sep 2019 by Shameel

Part 3 of this multi-part article series discusses the actual migration process: Schema and data migration, ETL/ELT, Reporting & OLAP, Scheduling and Applications & Services migration.. The post Migrating your SQL Server Workloads to PostgreSQL – Part 3 appeared first on The Developer Space..

Migrating your SQL Server Workloads to PostgreSQL – Part 2

21 Sep 2019 by Shameel

Part 2 of this multi-part article series compares SQL Server and PostgreSQL article, database structure, language differences, data type mappings, functions and operators and other important considerations for migration..

Reserved Instances and Where Everyone Gets It Wrong

14 Apr 2020 by Kevin Mack

Cost projections and figuring out gross margin in cloud computing

SQL

cloud

PostgreSQL