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.
I Thought MSSQL and MySQL Were the Same. I Was Wrong.
satyamgupta1495 profile

I Thought MSSQL and MySQL Were the Same. I Was Wrong.

#mysql #sql #database #programming
Comments
20 min read
Closing the Tax Gap with a Data Model: Invoice Traceability in SQL
ricardo_demelo_2a17a8dd9 profile

Closing the Tax Gap with a Data Model: Invoice Traceability in SQL

#sql #database #datamodeling #fintech
Comments
4 min read
Speed Up Your Queries: A Plain-English Guide to Database Indexing
saurav_tb_pandey profile

Speed Up Your Queries: A Plain-English Guide to Database Indexing

#databaseindexing #database #sql #performance
Comments
3 min read
Export a Database Data Dictionary: HTML, Markdown and Excel from Your ERD
tbson87 profile

Export a Database Data Dictionary: HTML, Markdown and Excel from Your ERD

#database #documentation #sql #postgres
Comments
7 min read
DIA 0 -> Começando a documentar minha jornada DEV.
theusmpm profile

DIA 0 -> Começando a documentar minha jornada DEV.

#sql #database #php #github
Comments
1 min read
Read-Only by Design: Letting AI Explore Your Database Without the Risk of Writes
vivekdraxlr profile

Read-Only by Design: Letting AI Explore Your Database Without the Risk of Writes

#sql #database #ai #postgres
Comments 1
6 min read
How to Turn Plain-English Requirements into SQL You Can Actually Trust
craftloop profile

How to Turn Plain-English Requirements into SQL You Can Actually Trust

#sql #database #ai #productivity
Comments
2 min read
I Reverse-Engineered a Restaurant ERP With No Documentation. Here's What It Taught Me About Being a Self-Taught Developer.
luishrqvf profile

I Reverse-Engineered a Restaurant ERP With No Documentation. Here's What It Taught Me About Being a Self-Taught Developer.

#reverseengineering #database #career #sql
Comments
4 min read
SQL Functions — A Friendly Guide With Real Examples
mwatela_nazi_d1d2cd301ba1 profile

SQL Functions — A Friendly Guide With Real Examples

#sql #database #webdev #beginners
1
Comments
5 min read
Your acquisitions table needs a status field, not a boolean
corpdigest profile

Your acquisitions table needs a status field, not a boolean

#database #sql #datascience
Comments
2 min read
Idempotent APIs Without Idempotency Tokens
kharesam profile

Idempotent APIs Without Idempotency Tokens

#java #database #api #sql
1
Comments 3
8 min read
Schema Linting vs Migration Linting: Which Database Problems Each One Can See
tbson87 profile

Schema Linting vs Migration Linting: Which Database Problems Each One Can See

#database #sql #postgres #architecture
Comments
11 min read
A Free-Server Regression Job for LLM-Generated SQL
dataio_4921 profile

A Free-Server Regression Job for LLM-Generated SQL

#sql #testing #ai #devops
Comments
6 min read
"Money we gave back to shoppers" matches no table name. Four searches find it anyway.
ashish_sinha_5241c7673d93 profile

"Money we gave back to shoppers" matches no table name. Four searches find it anyway.

#sql #ai #database #python
Comments
4 min read
Learn PostgreSQL extensibility through a gloriously bad idea: MM/DD/YYYY native datatype and GiST index
franckpachot profile

Learn PostgreSQL extensibility through a gloriously bad idea: MM/DD/YYYY native datatype and GiST index

#postgres #sql #database #extensions
2
Comments
16 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.