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.
Data Analyst Interview Questions 2026: SQL, Business Cases, and Behavioral (What Actually Gets You Hired)
manyoffer_career profile

Data Analyst Interview Questions 2026: SQL, Business Cases, and Behavioral (What Actually Gets You Hired)

#dataanalyst #sql #interview #career
Comments
4 min read
Coding Cat Oran S2 Ep1 — The Excel Republic
syslayer profile

Coding Cat Oran S2 Ep1 — The Excel Republic

#sql #cim #database #dataclean
Comments
2 min read
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
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
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
Indexes: Quickstart Using PostgreSQL
effessdev profile

Indexes: Quickstart Using PostgreSQL

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