Forem

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.
MySQL COUNT Scalar Subquery Optimization: The Complete Guide
Cover image for MySQL COUNT Scalar Subquery Optimization: The Complete Guide

MySQL COUNT Scalar Subquery Optimization: The Complete Guide

Comments
4 min read
form8

form8

Comments
7 min read
SQL parameterization
Cover image for 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
Debunking the Myth: Is JOIN Always Faster Than Correlated Subqueries?

Debunking the Myth: Is JOIN Always Faster Than Correlated Subqueries?

Comments
3 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
OpenTelemetry database sql [otelsql]
Cover image for OpenTelemetry database sql [otelsql]

OpenTelemetry database sql [otelsql]

Comments
3 min read
I built a free AI Regex & SQL Generator to save developers time (no login, open models)

I built a free AI Regex & SQL Generator to save developers time (no login, open models)

Comments
2 min read
SQL: Keeping Your Data Organized
Cover image for SQL: Keeping Your Data Organized

SQL: Keeping Your Data Organized

Comments
2 min read
🐬 MySQL — The Complete Guide for Developers (2025 Edition)
Cover image for 🐬 MySQL — The Complete Guide for Developers (2025 Edition)

🐬 MySQL — The Complete Guide for Developers (2025 Edition)

Comments
4 min read
Getting started with SQLite using C#/Microsoft Visual Studio

Getting started with SQLite using C#/Microsoft Visual Studio

Comments
4 min read
🧾 Understanding Transactions in SQL Databases — A Complete Guide for Developers
Cover image for 🧾 Understanding Transactions in SQL Databases — A Complete Guide for Developers

🧾 Understanding Transactions in SQL Databases — A Complete Guide for Developers

Comments
3 min read
Similarities Between a Stored Procedure in SQL and a Function in Python

Similarities Between a Stored Procedure in SQL and a Function in Python

Comments
3 min read
Recursive CTEs: Because Writing Nested Loops for Trees is Psychopathic (and a Little Masochistic Too)
Cover image for Recursive CTEs: Because Writing Nested Loops for Trees is Psychopathic (and a Little Masochistic Too)

Recursive CTEs: Because Writing Nested Loops for Trees is Psychopathic (and a Little Masochistic Too)

3
Comments
10 min read
Day 62 of My Data Analytics Journey !
Cover image for Day 62 of My Data Analytics Journey !

Day 62 of My Data Analytics Journey !

Comments
2 min read
How to Handle NULLs in Snowflake: A Complete Guide!

How to Handle NULLs in Snowflake: A Complete Guide!

Comments
4 min read
loading...