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.
Five SQL Bugs That Never Threw an Error
kiplangat_brian profile

Five SQL Bugs That Never Threw an Error

#sql #postgres #dataengineering #analytics
Comments
5 min read
A Generated SQL Query Got Faster by Returning Fewer Rows. Test That Before You Merge It
codepy_1473 profile

A Generated SQL Query Got Faster by Returning Fewer Rows. Test That Before You Merge It

#sql #testing #ai #database
Comments
5 min read
Directus Basics Part 2 — Understanding Relationships (M2O, O2M, M2M)
wadethomastt profile

Directus Basics Part 2 — Understanding Relationships (M2O, O2M, M2M)

#directus #sql #webdev #headlesscms
Comments
3 min read
Your Database Is Making 4 Promises. Here's What ACID Means.
aditya_d_sharma profile

Your Database Is Making 4 Promises. Here's What ACID Means.

#backend #database #softwareengineering #sql
1
Comments
10 min read
Database Development Without ORM: A Pragmatic Approach to SQL-First Workflows
raiyanu profile

Database Development Without ORM: A Pragmatic Approach to SQL-First Workflows

#sql #kysely #database #typescript
Comments
2 min read
Webtabellen Converteren naar SQL INSERT-Statements
circobit profile

Webtabellen Converteren naar SQL INSERT-Statements

#javascript #sql #webdev #database
Comments
5 min read
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
Demystifying Vector Distance in PostgreSQL
rpi1337 profile

Demystifying Vector Distance in PostgreSQL

#algorithms #database #postgres #sql
1
Comments
2 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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.