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.
Text-to-SQL in Practice: When to Trust AI Output and When to Gate It
databaseinsights profile

Text-to-SQL in Practice: When to Trust AI Output and When to Gate It

#sql #ai #database #devops
Comments 1
4 min read
Oracle SQL: JSON Functions
sandeep-oracle profile

Oracle SQL: JSON Functions

#oracle #oraclesql #sql
Comments
2 min read
Cursor Pagination vs Offset Pagination: Which One Should You Use?
omeiza_ahmed profile

Cursor Pagination vs Offset Pagination: Which One Should You Use?

#backend #database #performance #sql
Comments
3 min read
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
Reverse-Engineering Messy Databases: My End-to-End Data Audits Across 17,000+ Relational Schema Logs
hafsa_motiwala profile

Reverse-Engineering Messy Databases: My End-to-End Data Audits Across 17,000+ Relational Schema Logs

#showdev #datascience #database #sql
Comments
4 min read
Oracle SQL: Pseudo-Columns
sandeep-oracle profile

Oracle SQL: Pseudo-Columns

#oracle #oraclesql #sql #plsql
Comments
4 min read
Oracle SQL: Read-Only Tables
sandeep-oracle profile

Oracle SQL: Read-Only Tables

#oracle #oraclesql #sql #plsql
Comments
3 min read
Oracle SQL: Unused Columns & Virtual Columns
sandeep-oracle profile

Oracle SQL: Unused Columns & Virtual Columns

#oracle #oraclesql #sql #plsql
Comments
3 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
Online enabling checksums in PG ̶1̶9̶ 20 (was 19 beta but reverted)
franckpachot profile

Online enabling checksums in PG ̶1̶9̶ 20 (was 19 beta but reverted)

#postgres #sql #database #online
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
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.