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.
We Ran One SQL Query… And Broke Production
cicd_samurai profile

We Ran One SQL Query… And Broke Production

#devops #database #sql #security
Comments
3 min read
How to Optimize BigQuery Costs (Real Techniques That Work)
amaranarun profile

How to Optimize BigQuery Costs (Real Techniques That Work)

#bigquery #dataengineering #googlecloud #sql
Comments
9 min read
SQLite Internals & PostgreSQL Multi-Master Replication Updates
soytuber profile
soy

SQLite Internals & PostgreSQL Multi-Master Replication Updates

#database #sql #sqlite
Comments
3 min read
SQL for Python Developers — Everything You Actually Need to Know
learnwithprashik profile

SQL for Python Developers — Everything You Actually Need to Know

#python #programming #beginners #sql
1
Comments
7 min read
PostgreSQL Query Anti-Patterns and Common Mistakes
philip_mcclarence_2ef9475 profile

PostgreSQL Query Anti-Patterns and Common Mistakes

#database #performance #postgres #sql
Comments 1
7 min read
SQL Subqueries vs CTEs
venuskennedy profile

SQL Subqueries vs CTEs

#beginners #database #sql #tutorial
Comments
3 min read
PostgreSQL AI Memory, Perf Tuning; Data Pipeline Orchestration Comparison
soytuber profile
soy

PostgreSQL AI Memory, Perf Tuning; Data Pipeline Orchestration Comparison

#database #sql #sqlite
Comments 1
3 min read
How I was introduced to SQL window function
dhairya_pandya profile

How I was introduced to SQL window function

#analytics #database #postgres #sql
Comments
2 min read
SQL Date & Time Functions: A Practical Guide for Real-World Queries
vivekdraxlr profile

SQL Date & Time Functions: A Practical Guide for Real-World Queries

#sql #database #postgres #mysql
Comments
7 min read
Understanding Logic, Reusability and Integrity On SQL ; Procedures, Functions and Transactions.
braeson_nyahera profile

Understanding Logic, Reusability and Integrity On SQL ; Procedures, Functions and Transactions.

#sql #postgres #data #analytics
1
Comments
2 min read
PostgreSQL Query Rewriting Techniques
philip_mcclarence_2ef9475 profile

PostgreSQL Query Rewriting Techniques

#database #performance #postgres #sql
Comments 1
9 min read
Subqueries vs. CTEs in SQL: What They Are and When to Use Each.
samkaruri profile

Subqueries vs. CTEs in SQL: What They Are and When to Use Each.

#subqueries #ctes #database #sql
Comments
7 min read
Codd's Connection Trap and Oracle's JOIN TO ONE
franckpachot profile

Codd's Connection Trap and Oracle's JOIN TO ONE

#sql #relational #database #oracle
Comments
8 min read
The bug your Typescript compiler and SQL migration both miss
equality_modehouse_9897e profile

The bug your Typescript compiler and SQL migration both miss

#typescript #sql #database #webdev
Comments
1 min read
How Databricks Genie Turns Plain English Into SQL Code
lucy1 profile
Lucy

How Databricks Genie Turns Plain English Into SQL Code

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