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.
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
PostgreSQL INCLUDE indexes: what problem are they trying to solve?

Clarifies pre-v11 covering index capabilities
franckpachot profile

PostgreSQL INCLUDE indexes: what problem are they trying to solve?

#postgres #sql #database #index
14
Picked as gem Comments 7
10 min read
Connecting Power BI to SQL Databases
suzanne_orido profile

Connecting Power BI to SQL Databases

#database #postgres #sql
Comments
10 min read
Mastering SQL Joins and Window Functions: A Comprehensive Guide
suzanne_orido profile

Mastering SQL Joins and Window Functions: A Comprehensive Guide

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