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 PostgreSQL vs MySQL vs SQL Server: Enterprise Database Decision Guide

Philip McClarence

Mar 12

PostgreSQL vs MySQL vs SQL Server: Enterprise Database Decision Guide

#architecture #database #postgres #sql

11 min read

Cover image for SQL Basics: DDL, DML, Filtering & Data Transformation

Reinhard Bonnke

Apr 13

SQL Basics: DDL, DML, Filtering & Data Transformation

#learning #sql #sqlserver #datascience

3 min read

Mar 10

Databases: The Backbone of Modern Applications

#backend #beginners #database #sql

5 min read

Mar 10

DuckDB 1.5.0 Released: New Features and Tools Enhance Performance and Functionality

#duckdb #sql #variant #geometry

9 min read

Anderson Sinaluisa

Mar 10

Building an AI tool that generates SQL queries from natural language

#ai #database #productivity #sql

2 min read

Apr 13

SQL Indexes Explained: Write Queries That Don't Make Your Database Cry

#sql #database #performance #postgres

6 min read

Cover image for How I Learned SQL by Creating a Simple School Database

Apr 13

How I Learned SQL by Creating a Simple School Database

#beginners #database #sql #tutorial

5 min read

Cover image for TypeScript knows your SQL is broken before your tests even run

Vitali Haradkou

Apr 13

TypeScript knows your SQL is broken before your tests even run

#typescript #playwright #testing #sql

3 min read

HK Lee

Mar 10

PostgreSQL Query Performance: The Complete EXPLAIN ANALYZE Guide for Developers Who've Had Enough

#postgres #database #performance #sql

14 min read

Cover image for SQL Joins and Window Functions

Mar 10

SQL Joins and Window Functions

#sql #database #datascience

6 min read

Cover image for Getting Started with SQL subqueries. A complete beginner guide with examples.

Mar 10

Getting Started with SQL subqueries. A complete beginner guide with examples.

#sql #beginners #database

9 min read

Cover image for [EP.04] SQL Injection — How 77 Million Sony PSN Accounts Were Exposed

CAISD

Apr 13

[EP.04] SQL Injection — How 77 Million Sony PSN Accounts Were Exposed

#bug #hunter #sql #caisd

3 min read

Apr 13

SQL fundamentals: DDL, DML, filtering, and CASE WHEN

#beginners #database #sql #tutorial

3 min read

Philip McClarence

Mar 11

Monitoring TimescaleDB in Production: A Complete Checklist

#database #monitoring #postgres #sql

4 min read

Cover image for Connecting Power BI to SQL database.

Apr 13

Connecting Power BI to SQL database.

#analytics #database #microsoft #sql

4 min read

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