The Developer Space

This article describes different ways of setting up generated (computed) columns in different versions of PostgreSQL.

This article walks you through the summary of most important new features. enhancements and breaking changes in PostgreSQL 12.

This article describes the new Stored Procedure feature in PostgreSQL 11.5 and shows you how it differs from Functions.

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.

Part 4 of this multi-part article series discusses Maintenance and Monitoring, High Availability, Load Balancing, and Replication and Environment Stabilization.

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.

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.

Part 1 of this multi-part article series discusses Open Source considerations, history of SQL Server and PostgreSQL, choosing the right PostgreSQL version for your needs and On-Premise vs Cloud comparison.

This post explains a neat way to check if your are running on open source PostgreSQL or AWS Aurora (PostgreSQL compatible)

DbStudio is a Database access tool that enables you to connect to a wide variety of databases. It is designed…