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.
Coding Cat Oran S2 Ep2 — The Big Customer
syslayer profile

Coding Cat Oran S2 Ep2 — The Big Customer

#career #webdev #sql #database
Comments
4 min read
SQLite RISC-V Fix, Formal Verification & pg_grpc for SQL-Native gRPC
soytuber profile
soy

SQLite RISC-V Fix, Formal Verification & pg_grpc for SQL-Native gRPC

#database #sql #sqlite
Comments
3 min read
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
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
Review the Logic, Not Whether the Junior Used AI
bradleymatera profile

Review the Logic, Not Whether the Junior Used AI

#ai #sql #hiring #career
Comments
5 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
1
Comments 2
8 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
The Five Most Important Columns to Add to Every Database Table
lessonsfromproduction profile
Mark

The Five Most Important Columns to Add to Every Database Table

#database #sql #beginners #webdev
Comments
5 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
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.