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.
Same question, same database, two callers
ashish_sinha_5241c7673d93 profile

Same question, same database, two callers

#ai #database #llm #sql
1
Comments
2 min read
38% of an analyst's questions get "no records found" when the data is right there
ashish_sinha_5241c7673d93 profile

38% of an analyst's questions get "no records found" when the data is right there

#sql #ai #database #security
Comments
5 min read
Window Functions vs. Aggregate Functions in SQL (With Examples)
ericmwaimiri profile

Window Functions vs. Aggregate Functions in SQL (With Examples)

#database #programming #sql #tutorial
Comments
3 min read
Why "Check Then Write" Booking Logic Breaks Under Real Traffic (And How to Fix It in PostgreSQL)
qasimlak profile

Why "Check Then Write" Booking Logic Breaks Under Real Traffic (And How to Fix It in PostgreSQL)

#architecture #backend #database #sql
Comments
2 min read
Our product search only returns rows the scanner can actually answer for
daniel_pertu profile

Our product search only returns rows the scanner can actually answer for

#postgres #sql #database #webdev
Comments
5 min read
Star, Snowflake, or Galaxy? A Practical Guide to Data Warehouse Modeling
ephantus_macharia_ profile

Star, Snowflake, or Galaxy? A Practical Guide to Data Warehouse Modeling

#database #sql #ai #data
Comments
10 min read
Grading a wrong answer by how wrong it is: ICD-10 proximity scoring in Postgres
thiagolongom profile

Grading a wrong answer by how wrong it is: ICD-10 proximity scoring in Postgres

#postgres #sql #healthcare #supabase
Comments
4 min read
Subqueries and CTEs: Asking a Question Inside a Question
david_mwandairo_777f888b4 profile

Subqueries and CTEs: Asking a Question Inside a Question

#sql #database #tutorial #ctes
Comments
8 min read
SQL Joins Explained: A Beekeeping Co-op in Six Queries
david_mwandairo_777f888b4 profile

SQL Joins Explained: A Beekeeping Co-op in Six Queries

#sql #tutorial #database
Comments
7 min read
Understanding SQL Window Functions
raphael_njeri_7f67f81f527 profile

Understanding SQL Window Functions

#datascience #sql #analytics
Comments
5 min read
A New Take on Raw SQL in Python
doekman profile

A New Take on Raw SQL in Python

#python #sql #opensource
Comments
3 min read
Cost Estimates or Timed Canaries: A Debate for Promoting Agent SQL
dataio_4921 profile

Cost Estimates or Timed Canaries: A Debate for Promoting Agent SQL

#sql #postgres #testing #ai
Comments
9 min read
SQL Interview Question: Find App Store Power Purchasers with Two-Level GROUP BY
rahmanfrr profile

SQL Interview Question: Find App Store Power Purchasers with Two-Level GROUP BY

#sql #database #interview #beginners
Comments
5 min read
IQueryable vs IEnumerable: The Line Between C# and SQL
homolibere profile
Nick

IQueryable vs IEnumerable: The Line Between C# and SQL

#csharp #dotnet #performance #sql
Comments
2 min read
When the Dialect IS the API: Reading Army and jOOQ Side by Side, Through PostgreSQL Source
zoro7 profile

When the Dialect IS the API: Reading Army and jOOQ Side by Side, Through PostgreSQL Source

#backend #database #java #sql
Comments
26 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.