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
Injection Attacks Are Not Dead: SQL, NoSQL, ORM, and Command Injection — How to Actually Fix Them (2026)
mahdi0shamlou profile

Injection Attacks Are Not Dead: SQL, NoSQL, ORM, and Command Injection — How to Actually Fix Them (2026)

#sql #nosql #security #injection
1
Comments
5 min read
Coding Cat Oran S2 Ep1 — The Excel Republic
syslayer profile

Coding Cat Oran S2 Ep1 — The Excel Republic

#sql #cim #database #dataclean
Comments
2 min read
One Free Database Client That Replaced Five Tools in My Daily Workflow
ashish_srivastava_e6b8ecc profile

One Free Database Client That Replaced Five Tools in My Daily Workflow

#database #sql #productivity #ai
Comments
4 min read
SQLite `generate_series` Precision Bug, PostgreSQL Pagination Tuning, & Large Table Replication
soytuber profile
soy

SQLite `generate_series` Precision Bug, PostgreSQL Pagination Tuning, & Large Table Replication

#database #sql #sqlite
Comments 1
3 min read
How I Built a Real-Time PostgreSQL WAL Reader in GO
mujib77 profile
Mujib

How I Built a Real-Time PostgreSQL WAL Reader in GO

#postgres #go #opensource #sql
1
Comments
2 min read
Gnoke-Database: Firebase in your pocket.
edmundsparrow profile

Gnoke-Database: Firebase in your pocket.

#php #gnoke #sql #backend
1
Comments 2
2 min read
Master Window Function trong SQL: Bí Kíp Tối Ưu Phân Tích Dữ Liệu
itprepvn profile
ITPrep

Master Window Function trong SQL: Bí Kíp Tối Ưu Phân Tích Dữ Liệu

#sql #database #dataanalysis
Comments
4 min read
You need foreign keys and surrogate keys because you broke your relationships
franckpachot profile

You need foreign keys and surrogate keys because you broke your relationships

#architecture #database #sql #document
2
Comments
9 min read
Hiểu Chuẩn ACID & Transaction: Đừng Để Database Của Bạn "Toang" Vì Lỗi Cơ Bản!
itprepvn profile
ITPrep

Hiểu Chuẩn ACID & Transaction: Đừng Để Database Của Bạn "Toang" Vì Lỗi Cơ Bản!

#database #sql #backend #architecture
Comments
6 min read
How to Find the Postgres Indexes Your Planner Never Picks (I Found 20 of 51)

78% index disk waste revealed by custom tools
alimafana profile

How to Find the Postgres Indexes Your Planner Never Picks (I Found 20 of 51)

#postgres #database #performance #sql
10
Comments 3
10 min read
How to Make xt850 Match xt 850
sanikolaev profile

How to Make xt850 Match xt 850

#database #nlp #sql #tutorial
Comments
6 min read
SQLite Internals & Audit Patterns; New Open-Source PostgreSQL UI
soytuber profile
soy

SQLite Internals & Audit Patterns; New Open-Source PostgreSQL UI

#database #sql #sqlite
Comments
4 min read
1.2.2 Semantic analysis: name resolution, type checking, catalog lookup
joonghyukshin profile

1.2.2 Semantic analysis: name resolution, type checking, catalog lookup

#postgres #database #internals #sql
Comments 1
10 min read
PostgreSQL Plan Signatures: Quick Reference
philip_mcclarence_2ef9475 profile

PostgreSQL Plan Signatures: Quick Reference

#database #performance #postgres #sql
Comments
7 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.