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.
A CSV Can Be Valid and Still Corrupt Your Import
silvio_greco profile

A CSV Can Be Valid and Still Corrupt Your Import

#dataengineering #sql #database #csv
Comments
2 min read
What if your Python database code didn't care which database you used?
joshtom profile

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

#backend #database #python #sql
Comments
2 min read
SELECT * and INSERT ... SELECT Broke Production at 3am
_66d02d0cc1ece7d1137c5f profile

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

#sql #migrations #ci #postgres
Comments
3 min read
Query Fingerprints or Literal Text Diffs: A Debate for Agent SQL Regression
dataio_4921 profile

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

#sql #postgres #ai #testing
Comments
7 min read
Why "Check Then Write" Booking Logic Breaks Under Real Traffic (And How to Fix It in PostgreSQL)
qasimlak profile

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

#architecture #backend #database #sql
Comments
2 min read
The Same Row Twice: Four Things Keyset Pagination Needs
hidetzu profile

The Same Row Twice: Four Things Keyset Pagination Needs

#postgres #sql #api #database
Comments
6 min read
Database index on generated column to speed up selection on date (for daily stats)
cyrille37 profile

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

#database #performance #sql
Comments
1 min read
What is dbt and Why is it in Every Data Engineering Job Listing?
neha_christina_1ac8651819 profile

What is dbt and Why is it in Every Data Engineering Job Listing?

#dataengineering #sql #beginners #dbt
Comments
3 min read
SQL Joins Explained.
josephine_mackylah_d6b31f profile

SQL Joins Explained.

#sql #beginners #basic
2
Comments
2 min read
Read Replicas Do Not Fix a Bad Query Plan
_66d02d0cc1ece7d1137c5f profile

Read Replicas Do Not Fix a Bad Query Plan

#postgres #database #performance #sql
Comments
4 min read
Cleaning and Structuring Excel Data for Reliable SQL INSERTs
maazulhaq profile

Cleaning and Structuring Excel Data for Reliable SQL INSERTs

#excel #sql #datacleaning #datapreparation
Comments
7 min read
Why I Put PostgreSQL in WebAssembly to Fix SQL Interview Prep
rahmanfrr profile

Why I Put PostgreSQL in WebAssembly to Fix SQL Interview Prep

#postgres #sql #webassembly #webdev
Comments
5 min read
Open-source tool: Cross-database universal "field-level" data lineage analysis and visualization (Part 2 of 3)
zgl20053779 profile

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

#sql #database #datalineage #bigdata
Comments
4 min read
Introduction to SQL :DDL,DML & Data Quering
anyangiii profile

Introduction to SQL :DDL,DML & Data Quering

#tutorial #beginners #sql
Comments
4 min read
From Messy CSV to Business Insight: A Small Python + SQL Analytics Pipeline
data_analyst_bunny profile

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

#python #sql #dataengineering #beginners
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.