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.
Oracle SQL: Read-Only Tables
sandeep-dos profile

Oracle SQL: Read-Only Tables

#oracle #oraclesql #sql #plsql
Comments
3 min read
Turn any SQL schema into an interactive ER diagram
patu profile
Patu

Turn any SQL schema into an interactive ER diagram

#sql #database #postgres #tools
Comments
2 min read
How Express Actually Talks to a Database: From HTTP Request to SQL Query
surajsrggupta profile

How Express Actually Talks to a Database: From HTTP Request to SQL Query

#sql #dbms #database #express
Comments
12 min read
Can I veto the agent's DDL before it hits main?
erdonline profile

Can I veto the agent's DDL before it hits main?

#database #devops #sql
Comments
7 min read
Funnel Conversion in SQL, and the Step That Shows 100%
michaelnocito profile

Funnel Conversion in SQL, and the Step That Shows 100%

#sql #database #tutorial #beginners
Comments
14 min read
Cohort Retention Analysis in SQL, Step by Step
michaelnocito profile

Cohort Retention Analysis in SQL, Step by Step

#sql #database #tutorial #beginners
Comments
14 min read
When to Index a Table: A Practical Guide for Analysts
michaelnocito profile

When to Index a Table: A Practical Guide for Analysts

#sql #database #tutorial #beginners
Comments
15 min read
SQL Injection thời AI: Cách phòng thủ tối ưu
phantam38 profile

SQL Injection thời AI: Cách phòng thủ tối ưu

#ai #cybersecurity #security #sql
Comments
4 min read
Build a Knowledge Layer for SQL Agents with OKF (Part 2)
lakhan_malviya_09d3c6dbcb profile

Build a Knowledge Layer for SQL Agents with OKF (Part 2)

#ai #llm #sql #documentation
1
Comments
16 min read
SQL Transactions
rhuturaj_takle profile

SQL Transactions

#dotnet #sql #programming #learning
Comments 1
20 min read
Postgres Internals in Simple Words: One Example to Understand Tables, Pages, Tuples, and Indexes
pakeezakhalid profile

Postgres Internals in Simple Words: One Example to Understand Tables, Pages, Tuples, and Indexes

#postgres #database #beginners #sql
Comments 1
4 min read
How to Set Up DuckDB (Run SQL on a CSV With No Import Step)
michaelnocito profile

How to Set Up DuckDB (Run SQL on a CSV With No Import Step)

#sql #database #tutorial #beginners
Comments
10 min read
Optimistic vs Pessimistic Locking: Handling Race Conditions in High-Contention Databases
devanshu_patil profile

Optimistic vs Pessimistic Locking: Handling Race Conditions in High-Contention Databases

#database #sql #architecture #backend
Comments
2 min read
Subqueries vs CTEs: Query Optimizer Internals & Memory Spooling Explained
arpitmbangre profile

Subqueries vs CTEs: Query Optimizer Internals & Memory Spooling Explained

#database #sql #dataengineering #performance
Comments
2 min read
What AI Coding Assistants Need Next: Context, Model Choice and Human Review
databaseinsights profile

What AI Coding Assistants Need Next: Context, Model Choice and Human Review

#ai #sql #database #productivity
3
Comments
5 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.