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.
Using dbt to Transform OpenSky Flight Data
data_with_jelimo profile

Using dbt to Transform OpenSky Flight Data

#data #dbt #sql
Comments
4 min read
UUID in Manticore: A Practical Guide
sanikolaev profile

UUID in Manticore: A Practical Guide

#database #search #sql #tutorial
Comments
9 min read
Your text-to-SQL accuracy is measured on schemas your users will never build
omer_hochman profile

Your text-to-SQL accuracy is measured on schemas your users will never build

#sql #llm #ai
Comments 1
3 min read
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
Understanding and Solving the N+1 Problem in Spring Data JPA / Hibernate
programming_coyote profile

Understanding and Solving the N+1 Problem in Spring Data JPA / Hibernate

#sql #softwaredevelopment #database #java
Comments 2
4 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
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
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
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.