Posts tagged "database"

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

TiDB Serverless vs PlanetScale: The Ultimate Cloud Database Showdown

Introduction If you're building an app, you likely juggle multiple roles—developer, DBA, and more—trying to choose the perfect cloud database solution. You need something scalable, reliab...

13.03.2025 0 Read More

Show Dev: Introducing Protect.js

Protecting data that’s sensitive — such as personal health or financial information — is crucial to building applications that users trust. But getting access control right is a tricky business....

13.03.2025 0 Read More

Oracle 23ai - Staging Table Feature

As you may know, using staging tables is a common practice in Data Warehouse environments, primarily during the data loading process into the Warehouse Database. Typically, raw data received from sour...

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

What is SQL? A Simple Introduction to Structured Query Language

What is SQL? SQL (Structured Query Language) is a programming language used to interact with databases. It allows you to create, read, update, and delete data (CRUD operations) in a database. With SQL...

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

The N+1 query problem in Laravel and how to solve it

The N+1 query problem in Laravel (and other ORMs) occurs when an application makes inefficient database queries, leading to performance issues. This problem typically arises in scenarios where a query...

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

Improving the documentation user experience

At SurrealDB, we’re constantly iterating to enhance our product and provide the best possible experience for our users. Recently, we've gathered feedback through our channels and made updates we bel...

14.03.2025 0 Read More

Why CRUD Doesn’t Work for ETL (And What to Do Instead)

Traditional CRUD operations don’t scale well in ETL workflows. Handling data row by row creates unnecessary overhead, slowing down performance. This article explores how to transition from CRUD-base...

14.03.2025 0 Read More

TiDB Serverless vs PlanetScale: The Ultimate Cloud Database Showdown

Show Dev: Introducing Protect.js

Oracle 23ai - Staging Table Feature

Navigating PostgreSQL - Join Strategies

What is SQL? A Simple Introduction to Structured Query Language

Postgresql vs. MongoDB

The N+1 query problem in Laravel and how to solve it

Efficient Percentile Ranking in PostgreSQL

Improving the documentation user experience

Why CRUD Doesn’t Work for ETL (And What to Do Instead)

#reading

#popular