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.
Google BigQuery Cost Optimization: 7 Proven Strategies to Slash Your 2026 Cloud Bill
tech_croc_f32fbb6ea8ed4 profile

Google BigQuery Cost Optimization: 7 Proven Strategies to Slash Your 2026 Cloud Bill

#bigquery #programming #sql #mariadb
5
Comments
3 min read
The Object-Relational Impedance Mismatch: Why Your Java Objects and Database Tables Don't Play Nice
phouchens profile

The Object-Relational Impedance Mismatch: Why Your Java Objects and Database Tables Don't Play Nice

#java #hibernate #sql #springboot
Comments
4 min read
Solving the N+1 Query Problem: A Developer's Guide to Database Performance
vasughanta09 profile

Solving the N+1 Query Problem: A Developer's Guide to Database Performance

#webdev #sql #postgres #productivity
1
Comments
7 min read
Stop hand-writing INSERTs: JSON SQL with dialect-aware output(Postgres/MySQL/SQLite)
jsontotable profile

Stop hand-writing INSERTs: JSON SQL with dialect-aware output(Postgres/MySQL/SQLite)

#json #sql #postgres #mysql
Comments
4 min read
Fix CORS, SQL Injection & MySQL Pooling in React + Node.js
vasughanta09 profile

Fix CORS, SQL Injection & MySQL Pooling in React + Node.js

#react #node #sql #webdev
2
Comments 2
7 min read
Tu Nube como una Base de Datos: Guía Práctica de Steampipe para AWS
kevinl profile

Tu Nube como una Base de Datos: Guía Práctica de Steampipe para AWS

#aws #security #sql
Comments
4 min read
2026's First AI SQL Dataset: Ending the 'SELECT Only' Era
rebooter_s profile

2026's First AI SQL Dataset: Ending the 'SELECT Only' Era

#ai #database #llm #sql
Comments
4 min read
AbeMon MS SQL Tool v1.0.0 Monitor and Debug
abeamar profile

AbeMon MS SQL Tool v1.0.0 Monitor and Debug

#sql #sqlserver #database #tooling
1
Comments
3 min read
đź‘» The Silent Ghost: How a Single Enum Broke Our Distributed Transaction
dipankar_sethi_35cc168b29 profile

đź‘» The Silent Ghost: How a Single Enum Broke Our Distributed Transaction

#java #distributedsystems #sql #backend
Comments
2 min read
Lost Updates, Dirty Reads, and Phantom Rows: A Simple Guide to SQL Transaction Problems
hinlocaesar profile

Lost Updates, Dirty Reads, and Phantom Rows: A Simple Guide to SQL Transaction Problems

#sql #database #transactions #beginners
Comments
4 min read
Understanding SQL ACID Properties: The Foundation of Database Reliability
hinlocaesar profile

Understanding SQL ACID Properties: The Foundation of Database Reliability

#sql #database #programming #tutorial
Comments
5 min read
How Real Databases Work Internally ?
farhadrahimiklie profile

How Real Databases Work Internally ?

#database #data #sql #nosql
1
Comments
3 min read
Moving Data from SQL Server to Postgres with NiFi
kelson_v_f7c45489ea4931ea profile

Moving Data from SQL Server to Postgres with NiFi

#dataengineering #docker #apachenifi #sql
Comments
2 min read
Database Management System (DBMS) Architecture Explained
quame_jnr1 profile

Database Management System (DBMS) Architecture Explained

#architecture #computerscience #database #sql
Comments
3 min read
Normalization and Denormalization in Databases: Why They Matter
suruliraajan profile

Normalization and Denormalization in Databases: Why They Matter

#database #sql #softwareengineering #databasedesign
Comments
4 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.