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.
DocumentDB 0.109: $match $sort $limit $project covered by index scan
franckpachot profile

DocumentDB 0.109: $match $sort $limit $project covered by index scan

#postgres #sql #database #mongodb
Comments
5 min read
What I added to omni-sql after v0.2.5: local analytics, S3, and more
cccadet profile

What I added to omni-sql after v0.2.5: local analytics, S3, and more

#sql #opensource #database #duckdb
Comments
2 min read
# SQL Joins: How to Combine Tables the Right Way
patrickomondi profile

# SQL Joins: How to Combine Tables the Right Way

#backend #database #sql #tutorial
Comments
3 min read
# Subqueries & CTEs: Two Ways to Query Inside a Query
patrickomondi profile

# Subqueries & CTEs: Two Ways to Query Inside a Query

#sql #datascience #cte #subquery
Comments
3 min read
SQL Indexes
rhuturaj_takle profile

SQL Indexes

#dotnet #sql #programming #learning
1
Comments
17 min read
PostgreSQL vs MySQL: 7 syntax differences that break migrations
sharefun2023 profile

PostgreSQL vs MySQL: 7 syntax differences that break migrations

#postgres #mysql #database #sql
Comments
4 min read
# DDL, DML, DCL & TCL: SQL's Building Blocks in Plain English
patrickomondi profile

# DDL, DML, DCL & TCL: SQL's Building Blocks in Plain English

#sql #ddl #dml #dcl
Comments
4 min read
One long SELECT, one ALTER TABLE, and every query behind them
remdore profile

One long SELECT, one ALTER TABLE, and every query behind them

#postgres #database #sql #devops
6
Comments
6 min read
How I Recovered Deleted SQL Server Rows Without Ever Enabling CDC or Audit
caiderek profile

How I Recovered Deleted SQL Server Rows Without Ever Enabling CDC or Audit

#backend #database #sql #tools
1
Comments
3 min read
ROW_NUMBER vs RANK vs DENSE_RANK: one of them silently duplicates your Top-N
sharefun2023 profile

ROW_NUMBER vs RANK vs DENSE_RANK: one of them silently duplicates your Top-N

#sql #database #postgres #mysql
Comments
4 min read
The NOT IN trap: why your SQL query returns zero rows
sharefun2023 profile

The NOT IN trap: why your SQL query returns zero rows

#sql #database #postgres #mysql
Comments
3 min read
SqlStealthRogue: a zero-probe SQL and NoSQL data dumper
lupingqaq profile

SqlStealthRogue: a zero-probe SQL and NoSQL data dumper

#database #python #security #sql
Comments
2 min read
Cleaning and Analyzing Tembo Hotel's Bookings
david_mwandairo profile

Cleaning and Analyzing Tembo Hotel's Bookings

#showdev #postgres #sql #dataanalysis
2
Comments
27 min read
Your AI SQL Tool Doesn’t Have an “Undo Logic” Button – That’s the Real Problem
esproc_spl profile
Judy

Your AI SQL Tool Doesn’t Have an “Undo Logic” Button – That’s the Real Problem

#ai #programming #devops #sql
5
Comments
2 min read
How a Fox and a Single Quote Broke the Critter Gallery — SQLi in Intigriti Challenge 0926
duchuaz profile

How a Fox and a Single Quote Broke the Critter Gallery — SQLi in Intigriti Challenge 0926

#security #sql #bugbounty
1
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.