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.
SQLazy: Convert Swipe Records into Single-Row Sessions by Pairing Order
esproc_spl profile
Judy

SQLazy: Convert Swipe Records into Single-Row Sessions by Pairing Order

#backend #database #sql
6
Comments 2
4 min read
SQL Cheat sheet
iliya_faz profile

SQL Cheat sheet

#beginners #database #sql #tutorial
1
Comments
7 min read
The Slow Query Sentinel: A Zero-Dollar Server That Explains Your Database's Worst SQL
dataio_4921 profile

The Slow Query Sentinel: A Zero-Dollar Server That Explains Your Database's Worst SQL

#sql #database #ai #python
Comments
4 min read
MCP vs. a Direct Database Connection: A Security and Workflow Comparison
vivekdraxlr profile

MCP vs. a Direct Database Connection: A Security and Workflow Comparison

#sql #database #ai #postgres
Comments
7 min read
GROUP BY & Aggregate Functions Explained (the WHERE vs HAVING mistake almost everyone makes)
neha_christina_1ac8651819 profile

GROUP BY & Aggregate Functions Explained (the WHERE vs HAVING mistake almost everyone makes)

#sql #snowflake #dataengineering #beginners
Comments
5 min read
Synthetic Data Is the Missing Layer in Your SQL Eval Harness
dataio_4921 profile

Synthetic Data Is the Missing Layer in Your SQL Eval Harness

#sql #ai #testing #dataprivacy
Comments
4 min read
Web Performance on a Budget: Bundle Size, API Limits, and Database Indexes
apeder profile

Web Performance on a Budget: Bundle Size, API Limits, and Database Indexes

#guide #webdev #api #sql
1
Comments
9 min read
Bind Variables: The Hard-Parse Storm That Melts Your Shared Pool
uptimearchitect profile

Bind Variables: The Hard-Parse Storm That Melts Your Shared Pool

#oracle #database #performance #sql
Comments 3
11 min read
Why I Chose SQLite Over PostgreSQL
vladshiyan profile

Why I Chose SQLite Over PostgreSQL

#database #sql #privacy #localfirst
Comments
7 min read
TIL mysqladmin ping returns exit 0 even on Access Denied. our backups were silently broken and nobody noticed
knutt3 profile

TIL mysqladmin ping returns exit 0 even on Access Denied. our backups were silently broken and nobody noticed

#sql
Comments
1 min read
Prove Your Backups Actually Restore Automatically, on a Separate Server
deepeshd profile

Prove Your Backups Actually Restore Automatically, on a Separate Server

#automation #database #devops #sql
Comments
7 min read
A Windows Service is Down. Now What?
prateek_srivastava_6a5661 profile

A Windows Service is Down. Now What?

#devops #microsoft #sql #sre
Comments
6 min read
Your Search Query Is a Program: Composing Role-Based SQL With the Strategy Pattern
purbano profile

Your Search Query Is a Program: Composing Role-Based SQL With the Strategy Pattern

#java #springboot #sql #security
Comments 1
13 min read
How to Pass the Amazon SQL Interview (A Practical Guide)
rahmanfrr profile
Rahman

How to Pass the Amazon SQL Interview (A Practical Guide)

#sql #dataengineering #career #interview
Comments
4 min read
SQL JOINS WITH EXAMPLES OF EACH
super_b8c82b4153dee9fab1c profile

SQL JOINS WITH EXAMPLES OF EACH

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