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.
How SQL Actually Works Under the Hood — A Deep Dive Into Snowflake and Redshift
maithreyan11 profile

How SQL Actually Works Under the Hood — A Deep Dive Into Snowflake and Redshift

#sql #dataengineering #snowflake #redshift
Comments
5 min read
DrawSQL Alternative: An Offline Desktop ERD Tool With No Table Limits
tbson87 profile

DrawSQL Alternative: An Offline Desktop ERD Tool With No Table Limits

#database #sql #tooling #programming
Comments
21 min read
PostgreSQL: A Beginner's Guide to Getting Started
adhi_sankar_45ccfb9350749 profile

PostgreSQL: A Beginner's Guide to Getting Started

#beginners #database #sql
1
Comments
2 min read
Reconstructing Wallet Journeys Across DEX Frontends, One Chain at a Time
andrewmaury profile

Reconstructing Wallet Journeys Across DEX Frontends, One Chain at a Time

#datascience #sql #blockchain #analytics
Comments
8 min read
SQL Is Surviving, Franklin: When Tables Start Talking
ms_njenga profile

SQL Is Surviving, Franklin: When Tables Start Talking

#beginners #database #sql #tutorial
3
Comments
6 min read
Why Senior Data Engineers Write SQL Differently
vfazal profile

Why Senior Data Engineers Write SQL Differently

#sql #database #dataengineering #data
1
Comments
8 min read
10 MySQL Performance Optimization Techniques Every PHP Developer Must Know
tapas_mahata profile

10 MySQL Performance Optimization Techniques Every PHP Developer Must Know

#php #mysql #webdev #sql
2
Comments
3 min read
How I Stopped Recalculating the Same MAX(date) Subquery on Redshift
maithreyan11 profile

How I Stopped Recalculating the Same MAX(date) Subquery on Redshift

#redshift #sql #dataengineering #aws
Comments
4 min read
SQL vs NoSQL for Node.js Applications: A Practical Guide
synfinity-dynamics-pvt-ltd profile

SQL vs NoSQL for Node.js Applications: A Practical Guide

#sql #node #database #nosql
5
Comments
7 min read
Understanding SQL joins.
steve_m profile

Understanding SQL joins.

#sql #database #tutorial
2
Comments 1
5 min read
Building a Visitor Data Platform with Digital Membership Cards
rixcyshah profile
rixcy

Building a Visitor Data Platform with Digital Membership Cards

#database #sql #api #analytics
Comments
2 min read
Building a Zero-Budget Eval Harness for LLM-Assisted SQL Generation
dataio_4921 profile

Building a Zero-Budget Eval Harness for LLM-Assisted SQL Generation

#dataengineering #ai #sql #testing
Comments
5 min read
'Column Must Appear in the GROUP BY Clause' — Why SQL Won't Let You Do That
systemcraftdev profile

'Column Must Appear in the GROUP BY Clause' — Why SQL Won't Let You Do That

#sql #database #beginners #tutorial
Comments
3 min read
The Text-to-SQL Accuracy Cliff: Why Deterministic Compilers Beat LLM Guessing
harshit_colrows profile

The Text-to-SQL Accuracy Cliff: Why Deterministic Compilers Beat LLM Guessing

#ai #sql #llm #database
Comments
2 min read
You Cannot Tell Which of Your ERD Files Are Under Version Control
tbson87 profile

You Cannot Tell Which of Your ERD Files Are Under Version Control

#database #git #sql #tooling
Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.