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 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
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
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
DuckDB Single-Node Analytics, PostgreSQL Bloom Filters, SQLite Compression
soytuber profile
soy

DuckDB Single-Node Analytics, PostgreSQL Bloom Filters, SQLite Compression

#database #sql #sqlite
Comments
4 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
10
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
SQLite Compression Discussions, Real-time Vector Search, & PostgreSQL Scaling Patterns
soytuber profile
soy

SQLite Compression Discussions, Real-time Vector Search, & PostgreSQL Scaling Patterns

#database #sql #sqlite
Comments
3 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
PostgreSQL: debugging a slow query and optimizing it
ohugonnot profile

PostgreSQL: debugging a slow query and optimizing it

#postgres #performance #sql #index
Comments
9 min read
SQLite Database & Expo SQLite A much easy to use docs.
dev_deepaksen profile

SQLite Database & Expo SQLite A much easy to use docs.

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