RedEventStore
Recently, I wrote my first blog post on this blog about Sourcing, a Raku framework I'm developing for Event Sourcing. One crucial component of Event Sourcing is the Event Store, which is responsible f...
Navigating PostgreSQL - Query Optimizations
In this part, we'll learn how to think about query optimizations in PostgreSQL with practical examples, using all our previous knowledge of different scans, joins, and indexes.
Query Optimizat...
What is MCP 💬 ? (Model Context Protocol) - A Primer ✅
The Model Context Protocol (MCP) is an open protocol that enables seamless integration between LLM
applications and external data sources and tools. It was announced by Anthropic on November 25, 2024....
The Basics of Relational Databases: Primary Keys and Foreign Keys Explained
What are Keys in Relational Databases?
In a relational database, keys are crucial for ensuring data integrity and establishing relationships between tables. The two most important types of keys are:
...
Secure Your Next.js App: Email & Google Authentication with Supabase, PostgreSQL RLS, and Triggers - Part 4
In this part of the series, we will focus on building the Profiles table for our users using Prisma, Supabase, and PostgreSQL for our Next.js application. This combination offers a powerful backend so...
Beyond CAP: Unveiling the PACELC Theorem for Modern Systems
Distributed systems are the backbone of modern computing, powering everything from cloud platforms to e-commerce applications. While the CAP theorem provided a foundational understanding of trade-offs...
Oracle 23ai — Track Table and Partition Scan Access
In Oracle 23ai, a new view named [dba|all|user]_table_access_stats has been introduced, enabling users to view the access history of tables and partitions. This view shows how many times each table or...
What is an ER Diagram
It ia a visual representation of different entities within a system and how the relate to each other.
It is a tool to design a relational database. It shows the logical structure of the database.
It...
How to Fix Duplicate Key Value Violates Unique Constraint in PostgreSQL: A Developer's Survival Guide
Ah, the dreaded duplicate key value violates unique constraint error in PostgreSQL. It’s like that one friend who always shows up uninvited to your party, eats all the snacks, and then leaves witho...
SQL Query Logical Order
SQL Query Logical Order: A Step-by-Step Breakdown
Understanding the logical execution order of an SQL query is essential for writing optimized and efficient database queries. Unlike the typical SQL sy...