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.
MariaDB Enterprise Platform 2027 Adds AI Agent Capabilities
vpodk profile

MariaDB Enterprise Platform 2027 Adds AI Agent Capabilities

#mariadb #enterprisedatabases #ai #sql
3
Comments
5 min read
A trip to China is 311 trips, not 44,473 — and four of the six line items are constants
sinostay profile

A trip to China is 311 trips, not 44,473 — and four of the six line items are constants

#data #database #sql
Comments
3 min read
Navicat Data Modeler Alternative: Database Design Software Without the Enterprise Edition
tbson87 profile

Navicat Data Modeler Alternative: Database Design Software Without the Enterprise Edition

#database #sql #tooling #programming
Comments
12 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
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 1
5 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
👋 Sign in for the ability to sort posts by relevant, latest, or top.