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.

Franz

Dec 21 '25

Uniface 10.4 + Informix: Simple Guide to DSQL Support 🧩

#database #sql #tutorial

3 min read

Jan 3

SQLNet is A social network that looks like Twitter, but you write SQL to do anything

#sql #programming #database #socialmedia

7 min read

Vardan Matevosian

Jan 13

The second-highest salary: Why the simplest SQL query is often the smartest

#sql #leetcode #database #programming

4 min read

Khandare Shubham

Dec 19 '25

“How I Built an End-to-End ETL Pipeline Using Databricks & Delta Lake”

#databricks #sql #pyspark #etl

2 min read

Jan 10

How One Can Start Their Journey in Data Engineering

#programming #dataengineering #sql #beginners

4 min read

Jan 9

TIL: Blazing-fast correlated exists queries

#rails #performance #sql

1 min read

Wolfgang Rathgeb

Dec 15 '25

How SQLite Replaced PostgreSQL as My First Choice

#sql #database #programming

4 min read

Akanle Tolulope

Dec 15 '25

From CSV to Insights: Analysing Walmart Sales with Python & PostgreSQL

#database #python #sql #beginners

2 min read

Prabhu

Dec 17 '25

Why Your Fast PostgreSQL Query Suddenly Became Slow: A Deep Dive into MVCC and Index Bloat

#database #performance #postgres #sql

5 min read

Yukti Sahu

Dec 14 '25

5 Surprising Truths About Your SQL SELECT Query (And Why They Matter)

#tutorial #beginners #sql #database

4 min read

Prashant Sharma

Dec 11 '25

DuckDB: how to fine tune parameters?

#database #performance #tutorial #sql

2 min read

SGTSanjay

Dec 11 '25

How I Reduced a 53-Minute MySQL Job to 15 Minutes on MySQL 5.7 (Without Changing Hardware)

#database #performance #sql

1 min read

Hui

Dec 15 '25

The One Thing You Can't Refactor: How to Architect Bulletproof Database Schemas with AI

#database #sql #architecture #systemdesign

5 min read

Dec 11 '25

sql9

#help #database #sql

2 min read

Dec 11 '25

sql2

#cli #sql #tooling

1 min read

Dec 11 '25

Tutorial SQL Injection: Panduan Lengkap untuk Pemula

#cybersecurity #sql #beginners #tutorial

11 min read

Lucas Wade

Dec 9 '25

SQL vs NoSQL for SaaS Platforms Which One to Choose

#saas #database #sql #architecture

4 min read

Erlan Akbaraliev

Dec 10 '25

БД5 Практ (View)

#database #sql #tutorial

1 min read

Luca Liu

Dec 9 '25

Data Security in SQL: Encryption, Roles, and Permissions

#database #tutorial #sql #data

2 min read

Dec 9 '25

map

#database #dataengineering #sql

1 min read

Dec 8 '25

SQL 을 조금 더 알아보자

#database #sql #tutorial

1 min read

Vahid Yousefzadeh

Dec 8 '25

Mandatory Profile in Oracle Database

#oracle #linux #database #sql

3 min read

Amar Abaz

Jan 11

MSSQL Encryptions, Certificates, A-Symmetric Keys and more (Vol 1)

#sqlserver #database #encryption #sql

5 min read

Jan 9

I Built a PostgreSQL User Analytics System — Here’s What I Learned About Real SQL

#postgres #beginners #database #sql

3 min read

Cooper D

Dec 7 '25

The Deterministic Problem with Probabilistic AI Analytics

#ai #sql #deterministic #nlp

7 min read

loading...