#postgres Development Tutorials & Tips | Roast Dev

100daysofcode 100daysofdevops 100pay 10mistakes 10yearworkanniversary 11 11labs 11tly 11ty 127001

Open-Source Databases for Real-Time Analytics

Real-time analytics break conventional databases. When milliseconds matter and data floods in by the millions, you need purpose-built solutions.For a deep dive, jump to 👉 The Complete Guide to Time...

13.03.2025 0 Read More

Data Redaction and View Enhancements – Oracle 23ai(23.6)

Oracle 23.6 introduces new capabilities in Data Redaction, one of which is Data Redaction support at the view level. In previous versions, attempting to access a redacted column in a view resulted in ...

13.03.2025 0 Read More

Navigating PostgreSQL - Join Strategies

Nested Loops Nested loops join is one of the simplest join strategies that PostgreSQL uses. It works by taking each row from one table (outer table) and finding matching rows in another table...

14.03.2025 0 Read More

Postgresql vs. MongoDB

PostgreSQL vs. MongoDB is the one of the most wondered comparisons in the database world. Let me compare them in a concise way. PostgreSQL vs. MongoDB: A Concise Comparison PostgreSQL and Mong...

14.03.2025 0 Read More

We don't need DynamoDB when we have Aurora Postgres

Aurora Postgres has many cool features. Let's compare them to DynamoDB and review them. While I'm writing this article, the latest version of Postgres - v17.4 Key-value and document data models - We d...

14.03.2025 0 Read More

Efficient Percentile Ranking in PostgreSQL

When analyzing data, percentiles help us understand the relative ranking of records within a dataset. In PostgreSQL, we can compute percentiles efficiently using the PERCENT_RANK() OVER window functio...

14.03.2025 0 Read More

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

14.03.2025 0 Read More

Aplicação 397x mais rápida com desnormalização

Quando trabalhamos com bancos de dados relacionais, é comum nos depararmos com situações onde precisamos contar registros relacionados em uma tabela.Primeiramente vamos considerar as seguintes tabe...

14.03.2025 0 Read More

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

15.03.2025 0 Read More

Secure Your Next.js App: Email & Google Authentication with Supabase, PostgreSQL RLS, and Triggers - Part 1

In this 4-part series, we will explore the process of creating robust, scalable, and secure web applications using the powerful combination of Next.js and Supabase. NextJS, a leading React framework, ...

15.03.2025 0 Read More

Open-Source Databases for Real-Time Analytics

Data Redaction and View Enhancements – Oracle 23ai(23.6)

Navigating PostgreSQL - Join Strategies

Postgresql vs. MongoDB

We don't need DynamoDB when we have Aurora Postgres

Efficient Percentile Ranking in PostgreSQL

Latitude Cuts DB Costs by $12K/Month While Scaling Real-Time AI Gaming 🎮

Aplicação 397x mais rápida com desnormalização

Navigating PostgreSQL - Query Optimizations

Secure Your Next.js App: Email & Google Authentication with Supabase, PostgreSQL RLS, and Triggers - Part 1

#reading

#popular