35 | Knowledge Hub

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

Morgan Li

Oct 11

Grant Matrices or Query Rewrites: A Debate for Agent SQL Least Privilege

#postgres #sql #database #ai

8 min read

Joshua Olajide

Sep 18

What if your Python database code didn't care which database you used?

#backend #database #python #sql

2 min read

晖莫

Sep 18

SELECT * and INSERT ... SELECT Broke Production at 3am

#sql #migrations #ci #postgres

3 min read

Morgan Li

Sep 18

Query Fingerprints or Literal Text Diffs: A Debate for Agent SQL Regression

#sql #postgres #ai #testing

7 min read

Qasim Lak

Sep 22

Why "Check Then Write" Booking Logic Breaks Under Real Traffic (And How to Fix It in PostgreSQL)

#architecture #backend #database #sql

2 min read

özkan pakdil

Sep 24

From MySQL to PostgreSQL: a much lighter server

#backend #database #postgres #sql

2 min read

Cyrille37

Sep 18

Database index on generated column to speed up selection on date (for daily stats)

#database #performance #sql

1 min read

晖莫

Sep 17

Read Replicas Do Not Fix a Bad Query Plan

#postgres #database #performance #sql

4 min read

Rahman

Sep 17

Why I Put PostgreSQL in WebAssembly to Fix SQL Interview Prep

#postgres #sql #webassembly #webdev

5 min read

Neha Christina

Oct 10

SQL Indexes Explained (For People Who Just Got Yelled At By a Slow Dashboard)

#sql #database #dataengineering #beginners

4 min read

zgl-20053779

Sep 17

Open-source tool: Cross-database universal "field-level" data lineage analysis and visualization (Part 2 of 3)

#sql #database #datalineage #bigdata

4 min read

DataAnalyst_Bunny

Sep 17

From Messy CSV to Business Insight: A Small Python + SQL Analytics Pipeline

#python #sql #dataengineering #beginners

4 min read

Grace Anyango

Sep 17

Introduction to SQL :DDL,DML & Data Quering

#tutorial #beginners #sql

4 min read

Aniket Abhishek Soni

Oct 10

Is Your Text-to-SQL Agent Just a Fancy Way to Drop Your Production Tables?

#sql #llm #governance #data

5 min read

zoro ma

Sep 16

Inside Army's MySQL Dialect: When SQL Dialects Are First-Class Citizens

#backend #database #java #sql

15 min read

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

DEV Community

select * from SQL

Grant Matrices or Query Rewrites: A Debate for Agent SQL Least Privilege

What if your Python database code didn't care which database you used?

SELECT * and INSERT ... SELECT Broke Production at 3am

Query Fingerprints or Literal Text Diffs: A Debate for Agent SQL Regression

Why "Check Then Write" Booking Logic Breaks Under Real Traffic (And How to Fix It in PostgreSQL)

From MySQL to PostgreSQL: a much lighter server

Database index on generated column to speed up selection on date (for daily stats)

Read Replicas Do Not Fix a Bad Query Plan

Why I Put PostgreSQL in WebAssembly to Fix SQL Interview Prep

SQL Indexes Explained (For People Who Just Got Yelled At By a Slow Dashboard)

Open-source tool: Cross-database universal "field-level" data lineage analysis and visualization (Part 2 of 3)

From Messy CSV to Business Insight: A Small Python + SQL Analytics Pipeline

Introduction to SQL :DDL,DML & Data Quering

Is Your Text-to-SQL Agent Just a Fancy Way to Drop Your Production Tables?

Inside Army's MySQL Dialect: When SQL Dialects Are First-Class Citizens