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.
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
📝 Fixing BigInt Serialization Error in Node.js + Express (A Beginner-Friendly Explanation)

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

Comments
3 min read
Nested Loop and Hash Join for MongoDB $lookup

Nested Loop and Hash Join for MongoDB $lookup

13
Comments 1
9 min read
SQL as Contract vs. Python as Procedure — a Short Note on Atlas vs. Alembic

SQL as Contract vs. Python as Procedure — a Short Note on Atlas vs. Alembic

Comments
2 min read
Understanding SQL Window Functions (Part 1)

Understanding SQL Window Functions (Part 1)

Comments
7 min read
limit

limit

Comments
1 min read
Beginner-Friendly PL/SQL and JavaScript MLE Examples for Oracle 26ai

Beginner-Friendly PL/SQL and JavaScript MLE Examples for Oracle 26ai

9
Comments 1
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
Master SQL with 100 Challenging Questions: Test Your Database Skills

Master SQL with 100 Challenging Questions: Test Your Database Skills

3
Comments 2
19 min read
Using CTEs When Your ORM Says No (The Lazy Developer's Survival Guide)

Using CTEs When Your ORM Says No (The Lazy Developer's Survival Guide)

4
Comments
14 min read
MySQL COUNT Scalar Subquery Optimization: The Complete Guide

MySQL COUNT Scalar Subquery Optimization: The Complete Guide

Comments
4 min read
util

util

Comments
1 min read
form8

form8

Comments
7 min read
SQL parameterization

SQL parameterization

Comments
11 min read
blob16

blob16

Comments
1 min read
perl

perl

Comments
1 min read
perl2

perl2

Comments
1 min read
full text

full text

Comments
1 min read
loop

loop

Comments
1 min read
blob15

blob15

Comments
1 min read
blob10

blob10

Comments
1 min read
blob6

blob6

Comments
1 min read
Indexing, Hashing & Query Optimization in SQL

Indexing, Hashing & Query Optimization in SQL

Comments
2 min read
Getting Started with Database Entity Relationship

Getting Started with Database Entity Relationship

Comments
5 min read
How I built a free AI Regex Generator using Hugging Face + Next.js (no API costs)

How I built a free AI Regex Generator using Hugging Face + Next.js (no API costs)

Comments
2 min read
loading...