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.
Google Dorking in 2026: The Ultimate Guide for Security Researchers
vickybuilds profile

Google Dorking in 2026: The Ultimate Guide for Security Researchers

#sql #security #google #cybersecurity
6
Comments
11 min read
Postgres: force drop a database that is being accessed by other users
philip_mcclarence_2ef9475 profile

Postgres: force drop a database that is being accessed by other users

#database #postgres #sql #tutorial
Comments
4 min read
Build a Natural Language to SQL API in Python
sonam_50a41a4ced7e6b4f3fa profile

Build a Natural Language to SQL API in Python

#python #ai #flask #sql
1
Comments
2 min read
Find Your Worst Postgres Query in 15 Minutes with pg_stat_statements
mukesh_13 profile
Mukesh

Find Your Worst Postgres Query in 15 Minutes with pg_stat_statements

#postgres #performance #database #sql
1
Comments
4 min read
Microsoft SQL Server and its Components
kathir_2911 profile

Microsoft SQL Server and its Components

#architecture #database #microsoft #sql
Comments
5 min read
Understanding Subqueries and CTEs in SQL: A Complete Guide
samuel_mwai profile

Understanding Subqueries and CTEs in SQL: A Complete Guide

#beginners #database #sql #tutorial
1
Comments
4 min read
OrioleDB Multi-Version Concurrency Control
franckpachot profile

OrioleDB Multi-Version Concurrency Control

#postgres #sql #database #orioledb
Comments
7 min read
We Don't Need Another Go ORM. We Need a Better One.
nelthaarion profile

We Don't Need Another Go ORM. We Need a Better One.

#sql #go #orm #postgres
Comments
2 min read
Demystifying Vector Distance in PostgreSQL
rpi1337 profile

Demystifying Vector Distance in PostgreSQL

#algorithms #database #postgres #sql
1
Comments
2 min read
Why 'WHERE x = NULL' Never Works in SQL (And What to Use Instead)
systemcraftdev profile

Why 'WHERE x = NULL' Never Works in SQL (And What to Use Instead)

#sql #database #tutorial #beginners
Comments 2
3 min read
Query Optimization in IFS: The Hidden Performance Killer
saikat_bose_a5751ba13208b profile

Query Optimization in IFS: The Hidden Performance Killer

#database #debugging #performance #sql
Comments
5 min read
String#squish Quietly Changed My SQL
jessalejo profile

String#squish Quietly Changed My SQL

#rails #sql
Comments
4 min read
interlace.sh: Sandboxes That Cost Nothing
5c4989ca297ed profile

interlace.sh: Sandboxes That Cost Nothing

#sql #opensource #data #python
Comments 1
4 min read
My First Time Using GitHub Copilot to Master SQL Window Functions! 🚀
omargamal_data1 profile

My First Time Using GitHub Copilot to Master SQL Window Functions! 🚀

#sql #database #githubcopilot #beginners
Comments
1 min read
Stop the Schema Chaos: A Workflow Guide for Healthcare Data Architects
season_mudbhary_7856e4083 profile

Stop the Schema Chaos: A Workflow Guide for Healthcare Data Architects

#dataengineering #architecture #healthcare #sql
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.