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.
I built a VS Code extension to debug MySQL queries step by step
ariel_e3e7016e92641fadead profile
Ariel

I built a VS Code extension to debug MySQL queries step by step

#sql #vscode #database #mysql
Comments
1 min read
I built a PostgreSQL learning platform with labs & quizzes — would love feedback
missak_boyajian profile

I built a PostgreSQL learning platform with labs & quizzes — would love feedback

#database #postgressql #sql #product
Comments
1 min read
GBase 8a Full-Text Index: Features, Queries, and Configuration
michaelfv profile

GBase 8a Full-Text Index: Features, Queries, and Configuration

#backend #database #sql #tutorial
2
Comments
2 min read
Backend Basics for Frontend Engineers: Dive into SQL and APIs with Node.js
fuadhusnan_f44f3e13 profile

Backend Basics for Frontend Engineers: Dive into SQL and APIs with Node.js

#backend #frontend #node #sql
Comments
7 min read
SQL Window Functions: A Practical Guide to ROW_NUMBER, RANK, LAG, and LEAD
snappy_tools profile

SQL Window Functions: A Practical Guide to ROW_NUMBER, RANK, LAG, and LEAD

#webdev #sql #database #beginners
1
Comments
4 min read
Simple SQL Tool
sayonilmitra profile

Simple SQL Tool

#showdev #sql #webdev #javascript
Comments
2 min read
Top 5 Data Engineering Tools for 2026: Why Python and SQL remain Kings
ahmeddeelhassancode profile

Top 5 Data Engineering Tools for 2026: Why Python and SQL remain Kings

#webdev #python #sql #dataengineering
Comments
2 min read
SchemaSpy vs SchemaCrawler - Which Database Documentation Tool is Right for You?

Maintainer insights on CI/CD and linting
sualeh profile

SchemaSpy vs SchemaCrawler - Which Database Documentation Tool is Right for You?

#database #devops #sql #opensource
11
Comments 9
3 min read
SQL Pattern Series #1: The Presence Pattern
baldwin_apps profile

SQL Pattern Series #1: The Presence Pattern

#beginners #database #sql #tutorial
Comments
3 min read
GBase 8a Operations Cheat Sheet: Essential Commands for DBAs
michaelfv profile

GBase 8a Operations Cheat Sheet: Essential Commands for DBAs

#cli #database #sql #tutorial
2
Comments
2 min read
I built 'Ask Your Life' — a personal Coral agent that answers questions about your money & deadlines with SQL
sahil9001 profile

I built 'Ask Your Life' — a personal Coral agent that answers questions about your money & deadlines with SQL

#ai #sql #webdev #hackathon
2
Comments 2
8 min read
One Practical SQL Trigger Example You Can Actually Use
baldwin_apps profile

One Practical SQL Trigger Example You Can Actually Use

#sql #database #dataengineering #programming
Comments
6 min read
A-Z Database Glossary
preetid profile

A-Z Database Glossary

#database #beginners #basic #sql
Comments
17 min read
Turn Anything Into a Queryable SQLite Database
mukhtar_onif profile

Turn Anything Into a Queryable SQLite Database

#discuss #sql #buildinpublic #data
5
Comments 2
6 min read
Before SQL, We Had to Tell Computers Everything. Then One Idea Changed That Forever.
baldwin_apps profile

Before SQL, We Had to Tell Computers Everything. Then One Idea Changed That Forever.

#sql #database #programming #beginners
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.