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.
How to see running queries in Postgres and kill them
dsplce-co profile

How to see running queries in Postgres and kill them

#database #performance #postgres #sql
Comments
3 min read
How to toggle realtime on a table in Supabase migrations
dsplce-co profile

How to toggle realtime on a table in Supabase migrations

#database #postgres #sql #tutorial
Comments
2 min read
PgBouncer: Effectively Managing Your PostgreSQL Connection Pool
gouranga-das-khulna profile

PgBouncer: Effectively Managing Your PostgreSQL Connection Pool

#postgres #sql #database
1
Comments
4 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
SQLite `ON CONFLICT DO SELECT` Proposal, PostgreSQL 19 Features & SQLite Critical Bug
soytuber profile
soy

SQLite `ON CONFLICT DO SELECT` Proposal, PostgreSQL 19 Features & SQLite Critical Bug

#database #sql #sqlite
Comments
3 min read
Pterocos: A free online editor for Python, Ruby, SQL, Lua, and web code
amine_kheddache_bef85e72e profile

Pterocos: A free online editor for Python, Ruby, SQL, Lua, and web code

#showdev #python #ruby #sql
2
Comments
1 min read
How I cut Django indexing from 23 minutes to 11 minutes with one SQL change
n3mo-dev profile
N3MO

How I cut Django indexing from 23 minutes to 11 minutes with one SQL change

#django #performance #postgres #sql
1
Comments
1 min read
Your Database Is Fast. Your Queries Are Slow.
qodors profile

Your Database Is Fast. Your Queries Are Slow.

#database #sql #linq #dotnet
Comments
4 min read
Inner vs Outer Joins: The Two Fundamental Join Types in SQL
michaelfv profile

Inner vs Outer Joins: The Two Fundamental Join Types in SQL

#gbase #database #数据库 #sql
2
Comments
1 min read
SQL for Developers: The Practical Guide (2026)
armorbreak profile

SQL for Developers: The Practical Guide (2026)

#beginners #database #sql #tutorial
1
Comments
6 min read
PostgreSQL Plan Signatures: Quick Reference
philip_mcclarence_2ef9475 profile

PostgreSQL Plan Signatures: Quick Reference

#database #performance #postgres #sql
Comments
7 min read
Delete record using JooqTemplate
javaer profile

Delete record using JooqTemplate

#database #java #sql #jooq
Comments
1 min read
SQL Formatting Best Practices: A Practical Guide for Engineers
moksh profile

SQL Formatting Best Practices: A Practical Guide for Engineers

#sql #database #webdev #productivity
4
Comments
4 min read
Automating SQL Server Database Administration with T-SQL Utility Scripts
dominic_robinson_ff89e6b5 profile

Automating SQL Server Database Administration with T-SQL Utility Scripts

#automation #database #opensource #sql
Comments
4 min read
REDB inside, part 1.1 — why the same 13 tables stay fast no matter how many classes you throw at them
rinat_kozin profile

REDB inside, part 1.1 — why the same 13 tables stay fast no matter how many classes you throw at them

#dotnet #postgres #sql #opensource
2
Comments 8
20 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.