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.
What Happens If a Bank Transfer Fails Halfway? Understanding ACID Properties in SQL
darshan_dev profile

What Happens If a Bank Transfer Fails Halfway? Understanding ACID Properties in SQL

#sql #database #programming #beginners
1
Comments
6 min read
SQL Patterns Hidden Inside Social Networks
meroline_lizlent profile

SQL Patterns Hidden Inside Social Networks

#architecture #backend #database #sql
1
Comments
4 min read
Your agent's memory is a vector store. Ask it "how many" and watch it fall over.
omer_hochman profile

Your agent's memory is a vector store. Ask it "how many" and watch it fall over.

#ai #database #postgres #sql
Comments 1
2 min read
SSMS Database Diagrams: Your ERD Is Trapped Inside the Database It Documents
tbson87 profile

SSMS Database Diagrams: Your ERD Is Trapped Inside the Database It Documents

#database #sqlserver #sql #documentation
Comments
6 min read
Database Views in Your ERD: Read-Only Entities, Not Fake Tables
tbson87 profile

Database Views in Your ERD: Read-Only Entities, Not Fake Tables

#database #sql #postgres #architecture
Comments 1
5 min read
How Do SQL Database Engines Work?
ishimwe_charles_9a4461252 profile

How Do SQL Database Engines Work?

#sql #database
Comments
6 min read
Supabase Schema Diagram: Get an ERD You Can Keep, Not a Dashboard View
tbson87 profile

Supabase Schema Diagram: Get an ERD You Can Keep, Not a Dashboard View

#database #postgres #supabase #sql
Comments
6 min read
MongoDB vs SQL: Which Database Should You Choose?
synfinity-dynamics-pvt-ltd profile

MongoDB vs SQL: Which Database Should You Choose?

#mongodb #database #sql #programming
5
Comments
7 min read
I Built a Chrome Extension - Sidekick
sheyahi_4bb10b5d profile

I Built a Chrome Extension - Sidekick

#ai #developer #sql #software
1
Comments
2 min read
Data Migration, Conversion, and ETL — What I Actually Did, Across Two Eras
sangeetha_kalia_cb89c90aa profile

Data Migration, Conversion, and ETL — What I Actually Did, Across Two Eras

#architecture #database #postgres #sql
Comments
17 min read
Manticore Search 28.6.6: UUID document IDs, ordered GROUP_CONCAT(), and 16 fixes
sanikolaev profile

Manticore Search 28.6.6: UUID document IDs, ordered GROUP_CONCAT(), and 16 fixes

#backend #database #search #sql
Comments
3 min read
Choose the Reporting Grain Before You Choose the Chart
datplan profile

Choose the Reporting Grain Before You Choose the Chart

#accounting #dataengineering #businessintelligence #sql
Comments 1
3 min read
Pg-Java v1.0 Debuts as New PostgreSQL Driver — Plus SQLite Fix & DuckCon #7
soytuber profile
soy

Pg-Java v1.0 Debuts as New PostgreSQL Driver — Plus SQLite Fix & DuckCon #7

#database #sql #sqlite #opensource
Comments
4 min read
How to write a cohort retention query in SQL (that actually runs)
sofrito profile

How to write a cohort retention query in SQL (that actually runs)

#sql #analytics #database #datascience
Comments
3 min read
Correlated Subqueries Explained: From Confusing to Intuitive
saamiabbaskhan profile

Correlated Subqueries Explained: From Confusing to Intuitive

#sql #database #mysql #leetcode
6
Comments
12 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.