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.
PostgreSQL Benchmarking Tool & SQLite Internals: API Error Handling, Join Optimization
soytuber profile
soy

PostgreSQL Benchmarking Tool & SQLite Internals: API Error Handling, Join Optimization

#database #sql #sqlite
1
Comments
3 min read
ClickHouse Duplicates: Clean Your Results vs. Clean Your Storage
mohhddhassan profile

ClickHouse Duplicates: Clean Your Results vs. Clean Your Storage

#clickhouse #database #dataengineering #sql
3
Comments
3 min read
One Free Database Client That Replaced Five Tools in My Daily Workflow
ashish_srivastava_e6b8ecc profile

One Free Database Client That Replaced Five Tools in My Daily Workflow

#database #sql #productivity #ai
Comments
4 min read
Soft Delete vs Archive Table: The Choice That Haunts Your Queries
gabrielanhaia profile

Soft Delete vs Archive Table: The Choice That Haunts Your Queries

#postgres #database #sql #backend
Comments
6 min read
SQLite `generate_series` Precision Bug, PostgreSQL Pagination Tuning, & Large Table Replication
soytuber profile
soy

SQLite `generate_series` Precision Bug, PostgreSQL Pagination Tuning, & Large Table Replication

#database #sql #sqlite
Comments 1
3 min read
How I Built a Real-Time PostgreSQL WAL Reader in GO
mujib77 profile
Mujib

How I Built a Real-Time PostgreSQL WAL Reader in GO

#postgres #go #opensource #sql
1
Comments
2 min read
Why I Built a Go SQL Helper
kirillscherba profile

Why I Built a Go SQL Helper

#go #sql #database #opensource
1
Comments 1
8 min read
Master Window Function trong SQL: Bí Kíp Tối Ưu Phân Tích Dữ Liệu
itprepvn profile
ITPrep

Master Window Function trong SQL: Bí Kíp Tối Ưu Phân Tích Dữ Liệu

#sql #database #dataanalysis
Comments
4 min read
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
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
3
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.