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.
377 SQL checks on 4.6 million generated rows: what they caught
grd_dev profile

377 SQL checks on 4.6 million generated rows: what they caught

#sql #database #testing #datascience
Comments
5 min read
Cost-First or Sample-First: A Debate Over How Agent SQL Loops Handle Unknown Table Sizes
dataio_4921 profile

Cost-First or Sample-First: A Debate Over How Agent SQL Loops Handle Unknown Table Sizes

#sql #database #ai #testing
Comments
7 min read
Del ZIP al dashboard público: 1,89 millones de viajes con DuckDB y dbt
mariela_estefanyramoslo profile

Del ZIP al dashboard público: 1,89 millones de viajes con DuckDB y dbt

#analytics #database #python #sql
Comments
2 min read
SQL, Python & Statistics: What They Teach You in Class vs. What You Actually Do at Work
melody_mulei profile

SQL, Python & Statistics: What They Teach You in Class vs. What You Actually Do at Work

#sql #ai #career #workplace
Comments
5 min read
We Build a Compiler So You Don’t Have to Gamble on AI Getting It Right
esproc_spl profile
Judy

We Build a Compiler So You Don’t Have to Gamble on AI Getting It Right

#ai #programming #devops #sql
5
Comments
6 min read
Cloudflare D1’s 50 MB Cap Exposes a Trap in Paginated Search
keith_azodeh profile

Cloudflare D1’s 50 MB Cap Exposes a Trap in Paginated Search

#cloudflare #sql #webdev
1
Comments
3 min read
Why SQL Server Deadlocks Happen : 5 Production Patterns and Their Fixes
vikram_sah_69ef4fc3faed68 profile

Why SQL Server Deadlocks Happen : 5 Production Patterns and Their Fixes

#sql #database #backend #performance
Comments
5 min read
A shared registered agent is not a shared company owner
dataspryva profile

A shared registered agent is not a shared company owner

#datascience #python #analytics #sql
Comments
6 min read
SQL INNER JOIN vs LEFT JOIN vs RIGHT JOIN vs FULL OUTER JOIN: Differences With Examples (Tested in MySQL 8.4 and SQLite)
mfaysaldev profile

SQL INNER JOIN vs LEFT JOIN vs RIGHT JOIN vs FULL OUTER JOIN: Differences With Examples (Tested in MySQL 8.4 and SQLite)

#sql #mysql #database #beginners
Comments
12 min read
PostgreSQL Indexing Cheat Sheet for Busy Developers
adnan_hassan_e2a0866b45ca profile

PostgreSQL Indexing Cheat Sheet for Busy Developers

#database #performance #postgres #sql
Comments
1 min read
Confirm a missing index with EXPLAIN ANALYZE and index inspection
chriserodriguez profile

Confirm a missing index with EXPLAIN ANALYZE and index inspection

#database #performance #postgres #sql
Comments
4 min read
SQL Window Functions Clicked When I Stopped Collapsing Rows
shadowdevil07 profile

SQL Window Functions Clicked When I Stopped Collapsing Rows

#sql #beginners #database #dataengineering
Comments 1
8 min read
🗺️Mapping ER Model to Relational Model day 2
muhammad_hassanobaid_908 profile

🗺️Mapping ER Model to Relational Model day 2

#architecture #beginners #database #sql
Comments
33 min read
Review AI-generated SQL before you trust the number: a checklist with a runnable fixture
prachitparikh profile

Review AI-generated SQL before you trust the number: a checklist with a runnable fixture

#sql #ai #database #dataengineering
Comments
19 min read
Postgres and Iceberg: pg_lake, pg_duckdb and the Postgres lakehouse
mohammed_arshadansari_f2 profile

Postgres and Iceberg: pg_lake, pg_duckdb and the Postgres lakehouse

#dataengineering #database #sql #opensource
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.