DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

Posts

👋 Sign in for the ability to sort posts by relevant, latest, or top.
Star Schema vs Snowflake Schema: Which to Use and When

Star Schema vs Snowflake Schema: Which to Use and When

Comments
4 min read
Fine-Tuning Local Database Engines: How to Optimize my.ini for High-Performance MySQL Stacks

Fine-Tuning Local Database Engines: How to Optimize my.ini for High-Performance MySQL Stacks

Comments
2 min read
A 1000x Speedup From One Index — and Why It Sometimes Does Nothing

A 1000x Speedup From One Index — and Why It Sometimes Does Nothing

Comments
7 min read
When AI-Generated SQL Becomes Untrustworthy: How to Restore Confidence in Our Data

When AI-Generated SQL Becomes Untrustworthy: How to Restore Confidence in Our Data

5
Comments
8 min read
Day 1 of My Microsoft Fabric Learning Journey – Exploring Lakehouses

Day 1 of My Microsoft Fabric Learning Journey – Exploring Lakehouses

Comments
1 min read
How to Convert Plain Text into JavaScript Arrays, Python Lists, JSON, and SQL IN Clauses

How to Convert Plain Text into JavaScript Arrays, Python Lists, JSON, and SQL IN Clauses

2
Comments
8 min read
The Fastest Way to Add Reporting to Your Internal Tool

The Fastest Way to Add Reporting to Your Internal Tool

1
Comments
6 min read
Український лематизатор тепер вбудовано в Manticore Search

Український лематизатор тепер вбудовано в Manticore Search

Comments
1 min read
Building an Analytics Layer on Top of Your Existing Database

Building an Analytics Layer on Top of Your Existing Database

Comments
5 min read
Stop Pasting Your Database Schema Into Every AI Prompt

Stop Pasting Your Database Schema Into Every AI Prompt

1
Comments 2
5 min read
DuckDB 1.5.2, PostgreSQL Internal Stats, and SQLite Virtual Table xUpdate Deep Dive

DuckDB 1.5.2, PostgreSQL Internal Stats, and SQLite Virtual Table xUpdate Deep Dive

Comments
3 min read
Session 4 summary

Session 4 summary

Comments
2 min read
Product Analytics with SQL: Tracking What Actually Matters

Product Analytics with SQL: Tracking What Actually Matters

Comments
6 min read
From 8s to 1s: Truly Understanding Rails N+1 by Opening Up ActiveRecord

From 8s to 1s: Truly Understanding Rails N+1 by Opening Up ActiveRecord

2
Comments
10 min read
Modelling, Joins, Relationships and different Schemas

Modelling, Joins, Relationships and different Schemas

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