17 | Knowledge Hub

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Emily Woods

Oct 30

Salesforce Interview Question: The Customer Paid. Why Isn’t Their Coffee Being Made?

#architecture #distributedsystems #sql #programming

10 min read

SPG Medisafe

Oct 16

Modelling Medical Device Size Variants as SKUs: A Ureteral Stent Example

#python #sql #healthcare #ecommerce

2 min read

Weather Clock Dash

Oct 16

SQL for Web Developers: JOINs, Indexes, CTEs, Window Functions, and N+1 Queries

#sql #database #webdev #backend

4 min read

Furqan Khalid

Oct 16

Tracking Traffic From ChatGPT, Perplexity and Gemini in GA4 and BigQuery

#analytics #sql #webdev #ai

5 min read

Venkatesh Polisetti

Oct 16

5 Things to Check Before Trusting AI-Generated SQL

#sql #ai #beginners #learning

1 min read

Gabriel Anhaia

Oct 15

VACUUM FULL Locks Your Table the Whole Time. Postgres 19's REPACK CONCURRENTLY Doesn't

#postgres #database #sql #devops

9 min read

LogicWiz Admin

Oct 16

An AI explained SQL GROUP BY in four lines. One of them is wrong.

#sql #database #ai #beginners

1 min read

Morgan Li

Oct 16

Hosted Free Models or a Free Server: Where an Agent's SQL Drafting Loop Should Run

#agents #ai #llm #sql

7 min read

Nishant Gaurav

Oct 15

Constraints in PostgreSQL

#postgressql #sql #mysql #database

5 min read

Aman Verma

Oct 16

SQL_Sheet

#ai #sql #java #productivity

3 min read

Libme

Oct 16

Postgres "deadlock detected": Fix the Lock Order First, Then Add a Retry

#postgres #database #sql #backend

6 min read

Ariftly

Oct 20

Oracle to Snowflake migration validation: a six-gate acceptance framework

#database #sql #testing #data

4 min read

Mira Lund

Oct 29

The dbt test that would have caught our duplicate orders

#dbt #data #sql

1 min read

Sayonil Mitra

Oct 15

The 4 kinds of ALTER TABLE that cause production incidents (and a 5-minute review for each)

#postgres #sql #database #devops

4 min read

Real Dev

Oct 15

SQL Joins Explained with One Tiny Dataset (Plus 5 Interview Questions)

#sql #database #beginners #interview

5 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.

DEV Community

select * from SQL

Salesforce Interview Question: The Customer Paid. Why Isn’t Their Coffee Being Made?

Modelling Medical Device Size Variants as SKUs: A Ureteral Stent Example

SQL for Web Developers: JOINs, Indexes, CTEs, Window Functions, and N+1 Queries

Tracking Traffic From ChatGPT, Perplexity and Gemini in GA4 and BigQuery

5 Things to Check Before Trusting AI-Generated SQL

VACUUM FULL Locks Your Table the Whole Time. Postgres 19's REPACK CONCURRENTLY Doesn't

An AI explained SQL GROUP BY in four lines. One of them is wrong.

Hosted Free Models or a Free Server: Where an Agent's SQL Drafting Loop Should Run

Constraints in PostgreSQL

SQL_Sheet

Postgres "deadlock detected": Fix the Lock Order First, Then Add a Retry

Oracle to Snowflake migration validation: a six-gate acceptance framework

The dbt test that would have caught our duplicate orders

The 4 kinds of ALTER TABLE that cause production incidents (and a 5-minute review for each)

SQL Joins Explained with One Tiny Dataset (Plus 5 Interview Questions)