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.
SQL Basics: A Real-World Guide to Databases and Queries
harshitha_madhavarapu profile

SQL Basics: A Real-World Guide to Databases and Queries

#sql #database #beginners #tutorial
Comments
4 min read
SQL Starters
kalyanam_venumadhav_aaddf profile

SQL Starters

#sql #sqlserver #database #mysql
Comments
2 min read
Speeding Up a Slow PL/SQL Routine with BULK COLLECT and FORALL
zahid23saim profile

Speeding Up a Slow PL/SQL Routine with BULK COLLECT and FORALL

#database #performance #sql #tutorial
Comments
3 min read
The Data Modeling Concepts Nobody Mentions After Star Schema 101
rahmanfrr profile

The Data Modeling Concepts Nobody Mentions After Star Schema 101

#dataengineering #datamodeling #sql #tutorial
1
Comments
6 min read
How I stopped manually rebuilding Java PreparedStatement SQL
olimar50 profile

How I stopped manually rebuilding Java PreparedStatement SQL

#java #sql #jdbc #webdev
Comments
2 min read
Why Adding an Index Won't Fix Your Slow COUNT(*) in PostgreSQL
bodanthebackend profile

Why Adding an Index Won't Fix Your Slow COUNT(*) in PostgreSQL

#postgres #sql #database #performance
1
Comments 1
5 min read
SQL PRACTICAL GUIDE
karen_wangui_ profile

SQL PRACTICAL GUIDE

#sql #datascience
1
Comments
4 min read
When a SQL Engine Records Column Types but Never Reads Them
megapixel99 profile

When a SQL Engine Records Column Types but Never Reads Them

#sql #database #node #javascript
Comments
3 min read
No More Rewriting the Same Logic for Every Database
esproc_spl profile
Judy

No More Rewriting the Same Logic for Every Database

#programming #devops #sql #sqlazy
5
Comments
4 min read
PostgreSQL Graph Queries with MATCH: 3 Practical Traversal Patterns
ineron profile
Eugene

PostgreSQL Graph Queries with MATCH: 3 Practical Traversal Patterns

#postgres #sql #backend #ai
Comments
2 min read
CVE-2026-24031 Analysis — Dovecot SQL-Based Authentication Bypass (an auth_username_chars Regression)
guidance_white profile

CVE-2026-24031 Analysis — Dovecot SQL-Based Authentication Bypass (an auth_username_chars Regression)

#database #vulnerabilities #cve #sql
1
Comments
6 min read
Paginating hybrid search on Postgres, and why the obvious fix is worse
pavangupta352 profile

Paginating hybrid search on Postgres, and why the obvious fix is worse

#postgres #sql #database #search
Comments
4 min read
Running Total in SQL: The Window Frame That Decides the Answer
michaelnocito profile

Running Total in SQL: The Window Frame That Decides the Answer

#sql #database #tutorial #beginners
Comments
14 min read
Temp Table vs View in SQL: A Saved Answer or a Saved Question
michaelnocito profile

Temp Table vs View in SQL: A Saved Answer or a Saved Question

#sql #database #tutorial #beginners
Comments
13 min read
Subquery vs CTE in SQL: Same Logic, One You Can Check
michaelnocito profile

Subquery vs CTE in SQL: Same Logic, One You Can Check

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