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.
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
SQL Joins Explained.
josephine_mackylah_d6b31f profile

SQL Joins Explained.

#sql #beginners #basic
3
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
Database Indexing Explained: How Indexes Make SQL Queries Faster
siddhu_kumar_fd7a80402b7e profile

Database Indexing Explained: How Indexes Make SQL Queries Faster

#backend #database #performance #sql
2
Comments
7 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
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
Database Index: Why Queries Become Slow as Data Grows
lukman-ss profile

Database Index: Why Queries Become Slow as Data Grows

#database #postgres #sql #backend
5
Comments
3 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
Cleaning and Structuring Excel Data for Reliable SQL INSERTs
maazulhaq profile

Cleaning and Structuring Excel Data for Reliable SQL INSERTs

#excel #sql #datacleaning #datapreparation
1
Comments
7 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
For Structured Data, Retrieval Accuracy Isn't a Model Problem
melih_birim_8363f43966da2 profile

For Structured Data, Retrieval Accuracy Isn't a Model Problem

#ai #sql #csv #agents
Comments 2
3 min read
Detecting SQLite Full Table Scans in Node.js
edysilva profile

Detecting SQLite Full Table Scans in Node.js

#node #sqlite #performance #sql
Comments
3 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.