Latitude Cuts DB Costs by $12K/Month While Scaling Real-Time AI Gaming 🎮
TL;DR: AI gaming company Latitude replaced Amazon Aurora with TimescaleDB for their interactive storytelling platform, cutting storage costs by $12K monthly while improving query performance.
--> ...
Trust But Verify: Evaluating Security When Choosing Data Infrastructure Tools
Cover Image: How data is stored on a server, as envisioned by Hackers (1995) Dir. Iain Softley ©Metro-Goldwyn-Mayer, Inc.
A data leader's guide to maintaining security when working with thi...
Installing MongoDB Using Docker: A Complete Guide
Docker provides an excellent way to run MongoDB without installing it directly on your system. This approach offers better isolation, easier version management, and simpler setup. In this guide, I'll ...
The filesystem - a quick & dirty way to store temp data in your API
I have an API service for a Google Sheets add-on that I built, and I wanted
to temporarily store some request metadata that I started collecting in the client.
How the add-on works. The API generates ...
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...