Skip to content

Forem

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.

Cover image for How Do PostgreSQL Indices Work, Anyways?

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

Feb 17

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

#database #performance #sql #sre

6 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

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

Philip McClarence

Mar 2

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

#database #mongodb #postgres #sql

12 min read

Feb 16

Solving MSSQL's 2100 Parameter Limit: From IN Clause to Cursor-Based Pagination

#backend #database #sql #typescript

4 min read

Cover image for Beyond the Basics: 5 Game-Changing Secrets of SQL Joins and Window Functions

Mar 2

Beyond the Basics: 5 Game-Changing Secrets of SQL Joins and Window Functions

#sql #dataanalytics #database #programming

5 min read

Cover image for Normalização de Banco de Dados: Das Origens às 5 Formas Normais (+ BCNF) com Exemplos Práticos

Mar 1

Normalização de Banco de Dados: Das Origens às 5 Formas Normais (+ BCNF) com Exemplos Práticos

#database #sql

13 min read

catatsuy

Mar 15

Why I, as Someone Who Likes MySQL, Now Want to Recommend PostgreSQL

#mysql #postgres #database #sql

13 min read

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