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.
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
Six Tables Out of 260
ashish_sinha_5241c7673d93 profile

Six Tables Out of 260

#ai #sql #python #database
Comments
3 min read
ACID - How Databases Keep Your Data Reliable
srdevgui profile

ACID - How Databases Keep Your Data Reliable

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