The Developer Space

Discover how to simplify your SQL queries and improve data security with Views. This beginner-friendly guide explains how Views work, how they differ from tables, how to create and manage them, and when to use materialized views for better performance across major RDBMS platforms.

Take your SQL skills to the next level with this beginner’s guide to subqueries. Learn how to write powerful queries using inline, scalar, and correlated subqueries—complete with practical code examples and clear explanations.

Learn how to master SQL JOINS with clear explanations and real-world examples. This third part of our SQL for Beginners series demystifies INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN using easy-to-understand Venn diagrams and sample queries. Perfect for developers looking to connect data across tables.

Take your SQL skills to the next level with this follow-up to our beginner’s guide. Learn intermediate SQL commands like subqueries, JOINs, CASE, and more with practical examples for real-world applications.

Learn SQL from scratch with this beginner-friendly guide. Discover key SQL commands, including SELECT, INSERT, UPDATE, and JOIN, with real-world examples to help front-end developers and beginners master database queries efficiently.

This concise eBook is intended to be a ready reference and a checklist for migrating your databases, applications and services from Microsoft SQL Server to PostgreSQL and discusses all the important information you need to be aware of before beginning a migration project.

The First Edition of this book was released in May 2020, about two and a half years ago. Since its…

Are you looking for resources to get started with migrating SQL Server Databases to PostgreSQL? This is the book for you. This concise eBook is intended to be a ready reference and a checklist for migrating your databases, applications and services from Microsoft SQL Server to PostgreSQL and discusses all the important information you need to be aware of before beginning a migration project.

One of the major challenges in Cloud is controlling costs effectively. This article discusses various strategies you can adopt to set up and operate non-critical workloads of your databases with minimal cost.

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 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…