List: Mastering PostgreSQL | Curated by Java Jedi

Java Jedi

Jan 13, 2025

8 stories

Mastering PostgreSQL

Although I've been working as a Software Engineer for several years and feel confident using PostgreSQL as my primary database, I decided to take an extra course to refresh and deepen my knowledge. Below are some key takeaways from the course as blog posts

Exploring Query Execution Plan

Java Jedi

Understanding Query Execution Plans

How Query Plans Affect Query Performance

Jan 13

Jan 13

Introduction To Types of Database Indexes.

Java Jedi

Types of Database Indexes: Understanding Their Role and Differences

Primary Key vs Secondary Index: Key Distinctions Explained

Jan 12

Types of Database Indexes: Understanding Their Role and Differences

Jan 12

Introduction To Database Index and Data Storage.

Java Jedi

Exploring Database Indexes. Introduction.

A Key to performant Database

Jan 9

Exploring Database Indexes. Introduction.

Jan 9

Explore how to ensure that no two bookings overlap

Java Jedi

Exclusion Constraints in Postgres

How to Implement Accurate Booking in Reservation Systems?

Jan 8

Jan 8

From Serial to Identity as Primary Key Data Type

Java Jedi

The Evolution of Primary Keys in PostgreSQL: From Serial to Identity

Welcome back. This is the following post on Mastering Postgres series. If you skipped earlier posts, I recommend checking them out where we…

Jan 7

The Evolution of Primary Keys in PostgreSQL: From Serial to Identity

Jan 7

Learn how to define Custom Data Types and Enums in Postgres

Java Jedi

PostgreSQL Domain Types and Enums: Ensuring Data Integrity

Welcome back to the third post in our series on advanced PostgreSQL features. In the previous posts, we explored how to design a database…

Jan 6

PostgreSQL Domain Types and Enums: Ensuring Data Integrity

Jan 6

Explore Constraint Checks in Postgres

Java Jedi

Enforcing Data Integrity with PostgreSQL Constraints

This is the second post on Postgres series, I recommend starting there to get familiar with some other important concept of PostgreSQL. But…

Jan 5

Enforcing Data Integrity with PostgreSQL Constraints

Jan 5

Dive deeper into some of Postgres Data Types

Java Jedi

Efficient PostgreSQL Database Design and Data Types

Although I’ve been working as a Software Engineer for several years and feel confident using PostgreSQL as my primary database, I decided…

Jan 4

Efficient PostgreSQL Database Design and Data Types

Jan 4