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.

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

De' Clerke

Jun 2

SQL Interview Problems for Data Engineers: 30 Patterns That Actually Get Asked

#sql #dataengineering #career #interview

15 min read

De' Clerke

Jun 2

The Data Engineering Take-Home Assessment: How to Turn a 4-Hour Test Into a Job Offer

#dataengineering #career #sql #beginners

14 min read

De' Clerke

Jun 2

PostgreSQL for Data Engineers: Indexes, Bulk Loads, and the Patterns That Actually Matter

#postgres #database #sql #psycopg2

13 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

Mikhail Shytsko

Jun 1

Your Test Data Is Type-Correct and Still Invalid: 6 Postgres Schema Features Generators Skip

#postgres #database #supabase #sql

9 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

soy

May 18

DuckDB EC2 Optimization, Postgres FDW Pushdown, SQLite NetBeans Connectivity

#database #sql #sqlite

4 min read

ManyOffer Career

May 18

Data Analyst Interviews in 2026: How to Clear SQL, Case Studies, and Behavioral in the Same Loop

#career #interview #dataanalysis #sql

4 min read

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