select * from SQL Page 13 - DEV Community

Skip to content

DEV Community

Allowed

Posts about learning SQL
Posts about tips, tricks, problems, and answers
Posts about news or commentary of the field
Posts about specific tooling or frameworks

Think what would someone wanting to learn more about SQL want to see.

Not Allowed

Articles that mention SQL in passing
Articles that break the terms of use

SQL is the language of data, has been for nearly 50 years now!

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

Oct 22

To SQL or to Python; there is another problem

#dataengineering #python #sql

6 min read

Oct 22

BETWEEN can double-count a fact at an SCD2 version boundary

#sql #dataengineering #sqlite #testing

4 min read

Oct 22

An old event timestamp can still leak future information into training data

#dataengineering #sql #machinelearning #python

4 min read

Andrey Karazhev

Oct 26

Stripe reconciliation: carrying September into October

#dataengineering #sql #fintech #stripe

4 min read

BioseqDB

Oct 22

PAM, BLOSUM and scoring matrices from 1,000 human mitochondrial genomes

#postgres #sql #bioinformatics #tutorial

46 min read

Oct 22

GROUP BY In PostgreSQL

#postgres #postgressql #sql #database

3 min read

Judy

Oct 22

Convert Time Columns into Rows and Pivot into a New Cross Table

#ai #programming #devops #sql

7 min read

Oct 22

SQL Concepts Using Hospital Data

#data #database #sql #tutorial

15 min read

Prashant Kumar Dey

Oct 22

5 SQL Window-Function Exercises Taken From Real Business Problems

#sql #database #beginners #career

3 min read

Lamka Joy

Oct 22

Writing SQL in Go Without Losing Type Safety: An Introduction to sqlc

#backend #database #go #sql

2 min read

Elvin Aghalarov

Oct 22

Your average response time is lying to you (use p95 and p99)

#performance #webdev #monitoring #sql

3 min read

Son Tran

Oct 22

How to Auto-Update an updated_at Column: MySQL ON UPDATE vs a Database Trigger vs the ORM

#mysql #postgres #database #sql

10 min read

Oct 22

A Single SQL Constraint Can Save Your Database From Bad Data — Do You Know Which One?

#sql #database #tutorial #beginners

5 min read

Prasenjit Mahato

Oct 22

Automatic maintenance tasks controls the automatic optimizer statistics

#database #performance #sql

4 min read

frank chu

Oct 21

DuckDB 2.0 shipped today. I ran its headline features — triggers work, VARIANT has a silent-NULL trap

#cli #database #python #sql

5 min read

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