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.
MariaDB to MySQL Migration: Which Schema Features Break, and How to Find Them First
tbson87 profile

MariaDB to MySQL Migration: Which Schema Features Break, and How to Find Them First

#mariadb #mysql #database #sql
Comments 2
12 min read
Your priority account count is not your A-grade count
dataspryva profile

Your priority account count is not your A-grade count

#datascience #python #analytics #sql
Comments
7 min read
I built a MySQL practice lab on SQLite in the browser. Here is where the two disagree
ghosh_srimanta profile

I built a MySQL practice lab on SQLite in the browser. Here is where the two disagree

#sql #sqlite #webassembly #javascript
Comments
3 min read
Claude for business: testing three Claude models as SQL agents on a CRM
kimolsen profile

Claude for business: testing three Claude models as SQL agents on a CRM

#claude #ai #sql #python
2
Comments 1
7 min read
INNER JOIN vs LEFT JOIN: Which Rows Survive?
systemcraftdev profile

INNER JOIN vs LEFT JOIN: Which Rows Survive?

#sql #database #beginners #tutorial
Comments
4 min read
Designing Fault-Tolerant API Through Idempotency
chocoscoding profile

Designing Fault-Tolerant API Through Idempotency

#mongodb #sql #api #webdev
13
Comments 2
4 min read
Extract Email Domains Using INSTR() and SUBSTR() in Oracle SQL
kailas_warade_d2a15d1ef8a profile

Extract Email Domains Using INSTR() and SUBSTR() in Oracle SQL

#datascience #tutorial #sql #oracle
Comments
2 min read
JSONB vs columns in PostgreSQL, measured on 2 million rows
importstatic profile

JSONB vs columns in PostgreSQL, measured on 2 million rows

#database #postgres #sql
1
Comments
7 min read
Best Bank Statement Converter: How to Test a Parser With Tie-Outs
damin_mutti_e213ac1a11bf4 profile

Best Bank Statement Converter: How to Test a Parser With Tie-Outs

#python #sql #testing
Comments 1
9 min read
10 SQL Interview Questions for Data Engineers (2027), with Answers
atsdatalabs profile

10 SQL Interview Questions for Data Engineers (2027), with Answers

#sql #dataengineering #interview #career
Comments
7 min read
Como aprendi Apache Spark — Parte 18: Performance Tuning avançado
renanpyd profile

Como aprendi Apache Spark — Parte 18: Performance Tuning avançado

#python #sql #apache #spark
Comments
17 min read
My "latest 20 issues" query read 200,000 rows, even with an index on project_id
muhammad_adnan_61b78b9816 profile

My "latest 20 issues" query read 200,000 rows, even with an index on project_id

#postgres #performance #sql #backend
Comments
3 min read
SQL WHERE vs HAVING: Differences, Execution Order and When to Use Each (Tested Examples)
mfaysaldev profile

SQL WHERE vs HAVING: Differences, Execution Order and When to Use Each (Tested Examples)

#sql #mysql #postgres #beginners
Comments
11 min read
Free Endpoint First or Self-Hosted First? Deciding Where an Agent Drafts SQL
dataio_4921 profile

Free Endpoint First or Self-Hosted First? Deciding Where an Agent Drafts SQL

#ai #agents #sql #testing
Comments
5 min read
Catch an order-total mismatch with one SQL query
incodelabs_global profile

Catch an order-total mismatch with one SQL query

#sql
Comments
1 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.