#sql Development Tutorials & Tips | Roast Dev

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

Querying embedded arrays in JSON (PostgreSQL JSONB and MongoDB documents)

When working with document-based data structures, the fields at the root can be indexed using simple expression indexes. However, when an array is present in the path, representing a One-to-Many relat...

30.04.2025 0 Read More

Using SQLite in the Browser with WebAssembly and React (Local-First Apps with No Backend)

What if you could run a real SQL database in the browser — no backend, no server, and full support for joins, indexes, and transactions?Thanks to SQLite compiled to WebAssembly (via sql.js), you can...

30.04.2025 0 Read More

Improving Query Performance: Organized WHERE Clauses and Eager Loading 👨‍🔬

Let's illustrate the importance of properly ordering conditions in the WHERE clause.❌ Unorganized Search Query:In this version, the query logic lacks parentheses to group the conditions properly. As...

01.05.2025 0 Read More

Mastering SQL Joins: INNER, LEFT, RIGHT, FULL Explained

SQL Tutorial Introduction In any SQL tutorial, one of the most crucial topics to understand is SQL joins. Whether you're managing a small database or working on a large enterprise sy...

02.05.2025 0 Read More

Oracle 23ai — Read-Only User Feature

The Read-Only User is one of the new features introduced in Oracle Database version 23ai. This feature enables administrators to restrict users from making any data modifications, even if they have th...

02.05.2025 0 Read More

Mastering Neon: A Pro's Guide to Using Serverless PostgreSQL

Neon is reshaping the way developers interact with PostgreSQL by introducing a truly serverless experience. Whether you're building a side project, scaling a SaaS platform, or running machine learning...

02.05.2025 0 Read More

Level Up Your Data Skills: 10 Essential SQL Books for Devs & Data Scientists

Disclosure: This post includes affiliate links; I may receive compensation if you purchase products or services from the different links provided in this article. Hello friends, SQL (Structured Query ...

02.05.2025 0 Read More

The Five Levels Of SQL

Introduction. Hello there data enthusiasts and welcome to yet another post on SQL. Today we are gonna dive into the five levels of SQL and I promise you are gonna love it and learn. So let's ...

02.05.2025 0 Read More

Why uber ditched postgres for mysql: What every developer can learn from it

...

03.05.2025 0 Read More

DuckDB: When You Don’t Need Spark (But Still Need SQL)

The Problem Too often, data engineering tasks that should be simple end up requiring heavyweight tools. Something breaks, or I need to explore a new dataset, and suddenly I’m firing up Spar...

03.05.2025 0 Read More

Querying embedded arrays in JSON (PostgreSQL JSONB and MongoDB documents)

Using SQLite in the Browser with WebAssembly and React (Local-First Apps with No Backend)

Improving Query Performance: Organized WHERE Clauses and Eager Loading 👨‍🔬

Mastering SQL Joins: INNER, LEFT, RIGHT, FULL Explained

Oracle 23ai — Read-Only User Feature

Mastering Neon: A Pro's Guide to Using Serverless PostgreSQL

Level Up Your Data Skills: 10 Essential SQL Books for Devs & Data Scientists

The Five Levels Of SQL

Why uber ditched postgres for mysql: What every developer can learn from it

DuckDB: When You Don’t Need Spark (But Still Need SQL)

#reading

#popular