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
maheshwari9980 profile

Star Schema vs Snowflake Schema: Which to Use and When

#dataengineering #database #sql #datascience
Comments
4 min read
Fine-Tuning Local Database Engines: How to Optimize my.ini for High-Performance MySQL Stacks
im_parzavilly_9fc83da282 profile

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

#database #performance #sql #tutorial
Comments
2 min read
READ COMMITTED isn't as safe as you think
dip_032d2fe1959e1990ddbb1 profile

READ COMMITTED isn't as safe as you think

#backend #database #postgres #sql
Comments 2
6 min read
A 1000x Speedup From One Index — and Why It Sometimes Does Nothing
danewu profile

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

#rails #database #sql #performance
Comments
7 min read
When AI-Generated SQL Becomes Untrustworthy: How to Restore Confidence in Our Data
serina_8340 profile

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

#ai #database #llm #sql
5
Comments
8 min read
Day 1 of My Microsoft Fabric Learning Journey – Exploring Lakehouses
arunkarthick_kandasamy profile

Day 1 of My Microsoft Fabric Learning Journey – Exploring Lakehouses

#dataengineering #learning #microsoft #sql
Comments
1 min read
Building My First Real Database: What a Weekend SQL Assignment Taught Me About Postgres (and Git)
joy_mbugua_f9c6ecc05289ef profile

Building My First Real Database: What a Weekend SQL Assignment Taught Me About Postgres (and Git)

#sql #postgres #database #github
2
Comments
3 min read
Optimizing an 18 TB Azure SQL Hyperscale Database — Part 1: Context & Principles
kostyabartashevich profile

Optimizing an 18 TB Azure SQL Hyperscale Database — Part 1: Context & Principles

#azure #database #sql #architecture
Comments
5 min read
How to Convert Plain Text into JavaScript Arrays, Python Lists, JSON, and SQL IN Clauses
zubair_iftikhar profile

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

#javascript #productivity #python #sql
2
Comments
8 min read
The Fastest Way to Add Reporting to Your Internal Tool
vivekdraxlr profile

The Fastest Way to Add Reporting to Your Internal Tool

#sql #database #webdev #productivity
1
Comments
6 min read
Top N per group is the query `LIMIT` can't write
omer_hochman profile

Top N per group is the query `LIMIT` can't write

#sql #database #webdev
Comments
3 min read
Український лематизатор тепер вбудовано в Manticore Search
sanikolaev profile

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

#news #database #nlp #sql
Comments
1 min read
Building an Analytics Layer on Top of Your Existing Database
vivekdraxlr profile

Building an Analytics Layer on Top of Your Existing Database

#sql #database #analytics #webdev
Comments
5 min read
Stop Pasting Your Database Schema Into Every AI Prompt
siddharth_pandey_27 profile

Stop Pasting Your Database Schema Into Every AI Prompt

#opensource #typescript #ai #sql
1
Comments 2
5 min read
Why I Built a Free SSMS Extension to Stop Destructive Queries
manuelenzo profile

Why I Built a Free SSMS Extension to Stop Destructive Queries

#database #security #sql #tools
Comments 2
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.