DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
PART 5 — The Rise of Network SQL (N-SQL)

PART 5 — The Rise of Network SQL (N-SQL)

4
Comments
26 min read
catalog

catalog

Comments
1 min read
dupl

dupl

Comments
1 min read
Introducing the All-New SLS SQL Copilot

Introducing the All-New SLS SQL Copilot

Comments
15 min read
🚀 Cómo Crear una Vista en SQL Server 2022: Simplifica tu Acceso a Datos

🚀 Cómo Crear una Vista en SQL Server 2022: Simplifica tu Acceso a Datos

Comments
2 min read
select2

select2

Comments
1 min read
How I Optimized an Extremely Slow Oracle SQL Query (Real Case Study)

How I Optimized an Extremely Slow Oracle SQL Query (Real Case Study)

Comments
2 min read
SQL Server Performance: How the Query Optimizer Really Works

SQL Server Performance: How the Query Optimizer Really Works

1
Comments
10 min read
Relica: A Zero-Dependency Query Builder for Go That Won't Break Your Code

Relica: A Zero-Dependency Query Builder for Go That Won't Break Your Code

Comments
9 min read
Mastering SQL: Revisiting the Basics

Mastering SQL: Revisiting the Basics

Comments
3 min read
What is Cyber Resilience Act, and what cybersecurity requirements does it impose?

What is Cyber Resilience Act, and what cybersecurity requirements does it impose?

1
Comments
7 min read
Quick Recap: SQL Databases

Quick Recap: SQL Databases

Comments
2 min read
How to Limit Comment Nesting Depth in Self-Referencing Tables

How to Limit Comment Nesting Depth in Self-Referencing Tables

Comments
2 min read
Simple Tweaks That Make SQLite Lookup Faster – Part 1

Simple Tweaks That Make SQLite Lookup Faster – Part 1

6
Comments
4 min read
Understanding Common Table Expressions (CTEs) in SQL — And Why They Matter in Data Analysis

Understanding Common Table Expressions (CTEs) in SQL — And Why They Matter in Data Analysis

Comments
3 min read
No, MongoDB Does Not Mean Skipping Design

No, MongoDB Does Not Mean Skipping Design

7
Comments 1
6 min read
SLS Copilot in Practice: Building a Flexible Data Infrastructure for LLM Applications with SLS

SLS Copilot in Practice: Building a Flexible Data Infrastructure for LLM Applications with SLS

Comments
15 min read
Dear Developer: Your Database Isn't a File Cabinet!

Dear Developer: Your Database Isn't a File Cabinet!

9
Comments
4 min read
Saving Game Data in Unity — Part 4: SQLite

Saving Game Data in Unity — Part 4: SQLite

1
Comments
3 min read
How I Reduced My Oracle SQL Query Time from 110s to 1s

How I Reduced My Oracle SQL Query Time from 110s to 1s

Comments
3 min read
Versioning Your Database with SQLAlchemy and Alembic: From Models to Safe Migrations

Versioning Your Database with SQLAlchemy and Alembic: From Models to Safe Migrations

Comments 1
5 min read
limit

limit

Comments
1 min read
Rolling Back Online Table Redefinition

Rolling Back Online Table Redefinition

Comments
2 min read
Strategies to Analyze Any Size Dataset with LLMs Beyond its Context Limit

Strategies to Analyze Any Size Dataset with LLMs Beyond its Context Limit

2
Comments
2 min read
📝 Fixing BigInt Serialization Error in Node.js + Express (A Beginner-Friendly Explanation)

📝 Fixing BigInt Serialization Error in Node.js + Express (A Beginner-Friendly Explanation)

4
Comments
3 min read
loading...