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
How to optimize a database, one step at a time
tarangnagda profile

How to optimize a database, one step at a time

#database #sql #beginners #systemdesign
Comments 1
4 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
Stored Procedures
rhuturaj_takle profile

Stored Procedures

#dotnet #sql #programming #learning
Comments 1
16 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
[query-inspector] A Claude Code skill for extracting and tuning SQL/ORM queries
jogakdal profile

[query-inspector] A Claude Code skill for extracting and tuning SQL/ORM queries

#claudecode #sql #java #performance
Comments
4 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
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
WINDOW FUNCTIONS VS AGGREGATE FUNCTIONS
emkoki profile

WINDOW FUNCTIONS VS AGGREGATE FUNCTIONS

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