Anonymous View

Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Jun 12

Designing an Expiring-Points System on an RDBMS (with Benchmarks)

#postgres #database #sql #systemdesign

9 min read

admin pb

May 21

How I built a fallback loop to save my recommendation engine

#showdev #webdev #php #sql

2 min read

soy

May 21

DuckDB Lance Lakehouse Integration for Vector Search; SQLite Journaling; pgrls RLS Linter

#database #sql #sqlite

3 min read

Mohamed Hussain S

Jun 13

ClickHouse Duplicates: Clean Your Results vs. Clean Your Storage

#clickhouse #database #dataengineering #sql

3 min read

Srinaadd Pemmasani

May 21

HOW DO YOU FEEL??

#discuss #sql

2 min read

Lex Mulier

May 20

Preventing double-bookings with PostgreSQL exclusion constraints

#postgres #sql #supabase #database

6 min read

soy

May 20

SQLite Journaling on SMB, TypeGraph for SQL Graphs, Cross-Engine Migrations

#database #sql #sqlite

3 min read

Michael Ozersky

May 20

I built a tool that lets you query websites using SQL

#ai #webdev #programming #sql

1 min read

May 20

Learning SQL As If You Built It Yourself

#learning #database #sql

12 min read

Lam Bùi

Jun 2

T-SQL on Microsoft Fabric - Episode 1: Mastering Data Retrieval with SELECT, WHERE, and ORDER BY

#microsoft #sql #fabric #dataengineering

3 min read

May 19

Can ClickHouse DELETE Data? A 2026 PR-by-PR Analysis

#database #sql #dataengineering #data

31 min read

soy

May 19

PostgreSQL: New Time-Series Extension & Replication Monitor; DuckDB in Production

#database #sql #sqlite

3 min read

minnogit

May 19

Come estrarre una singola tabella da un file dump MySQL

#mysql #sql

1 min read

May 18

Cleaning Messy Phone Numbers in PostgreSQL Using REGEXP_REPLACE

#sql #postgres #beginners

6 min read

May 18

Eight window-function tricks beyond LAG and ROW_NUMBER

#sql #analytics #frauddetection #database

6 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.