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.

Mar 1

Real world considerations: MS-SQL vs PostgreSQL vs MySQL

#sql #mysql #postgres

12 min read

Matty Stratton for Tiger Data (Creators of TimescaleDB)

Mar 18

How Do PostgreSQL Indices Work, Anyways?

#postgres #database #performance #sql

6 min read

Apr 3

left join an effective satellite without duplicating rows (use a cte)

#datavault #sql #effectivesatellite #leftjoin

3 min read

Mar 21

Building a SQL Tokenizer and Formatter From Scratch — Supporting 6 Dialects

#sql #webdev #typescript #javascript

5 min read

Mar 13

Connecting power bi to SQL databases locally and through cloud service.

#sql #database #productivity #beginners

5 min read

Mar 23

SQL Query Optimization Guide

#database #sql #postgres #performance

5 min read

Mar 23

Data Modeling Patterns

#database #sql #postgres #performance

4 min read

Feb 17

Zero-Downtime Schema Changes in SQL Server: The Reality Behind “Just Run the Migration”

#database #performance #sql #sre

6 min read

Mar 23

Data Analyst Career Guide

#datascience #sql #python #analytics

3 min read

Mar 23

MySQL Admin Scripts

#database #sql #postgres #performance

4 min read

Mar 2

Adding NOT NULL Constraints to Existing PostgreSQL Columns Safely

#postgres #database #sql #backend

5 min read

Santhoshi Mary A

Mar 22

Number Guessing Game

#database #python #sql #tutorial

2 min read

Abdelrahman Adnan

Feb 16

# Module 4 Summary - Analytics Engineering with dbt

#analytics #dataengineering #sql #tutorial

2 min read

Abdelrahman Adnan

Feb 16

Part 3: Testing, Documentation & Deployment 🚀

#analytics #dataengineering #sql #tutorial

5 min read

Philip McClarence

Mar 2

PostgreSQL vs MongoDB in 2026: When to Choose SQL Over NoSQL

#database #mongodb #postgres #sql

12 min read

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