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.
Sagas vs ACID Transactions: Ensuring Reliability in Distributed Architectures

Sagas vs ACID Transactions: Ensuring Reliability in Distributed Architectures

1
Comments
11 min read
OWOX Data Marts - Free Open-Source Self-Service Analytics Platform

OWOX Data Marts - Free Open-Source Self-Service Analytics Platform

Comments
1 min read
Zero Downtime Migrations: Shadow Table Strategy Explained

Zero Downtime Migrations: Shadow Table Strategy Explained

1
Comments
9 min read
Why Are Firewalls Necessary for Your Website

Why Are Firewalls Necessary for Your Website

7
Comments
2 min read
Optimized Transaction and Resource Management for Provisioning Rules in SailPoint IdentityIQ with Java

Optimized Transaction and Resource Management for Provisioning Rules in SailPoint IdentityIQ with Java

Comments
4 min read
Stored Procedures: Organization and Code Quality in SQL

Stored Procedures: Organization and Code Quality in SQL

Comments
2 min read
SQL HAVING Explained: Filter Grouped Data With Ease

SQL HAVING Explained: Filter Grouped Data With Ease

Comments
2 min read
SQL Server Paging: Which Method is Fastest?

SQL Server Paging: Which Method is Fastest?

Comments
4 min read
Why Use SQL Databases for AI Agent Memory

Why Use SQL Databases for AI Agent Memory

12
Comments 1
6 min read
Stop Writing SQL by Hand: Building My MVP to Chat With Databases

Stop Writing SQL by Hand: Building My MVP to Chat With Databases

Comments
2 min read
Capture Slowly Changing Attributes in SQL - SCD Type 2

Capture Slowly Changing Attributes in SQL - SCD Type 2

Comments
8 min read
ACID, Isolation Levels, and MVCC: Architecture and Execution in Relational Databases

ACID, Isolation Levels, and MVCC: Architecture and Execution in Relational Databases

2
Comments
10 min read
SQLite: Randomly order rows

SQLite: Randomly order rows

Comments
1 min read
The Backbone of Database Reliability:

The Backbone of Database Reliability:

Comments 1
3 min read
DummyDatabase.com: DATA GENERATION MADE SIMPLE

DummyDatabase.com: DATA GENERATION MADE SIMPLE

Comments
2 min read
Understanding the ACID Concept with PostgreSQL

Understanding the ACID Concept with PostgreSQL

Comments 1
5 min read
Subqueries vs. CTEs vs. Stored Procedures: What’s the Real Difference?

Subqueries vs. CTEs vs. Stored Procedures: What’s the Real Difference?

5
Comments
3 min read
Design your Laravel database schema for optimal query performance.

Design your Laravel database schema for optimal query performance.

Comments
4 min read
Exploring the Similarities Between SQL Stored Procedures and Python Functions

Exploring the Similarities Between SQL Stored Procedures and Python Functions

10
Comments
2 min read
🚀 SQL Stored Procedures vs. Python Functions: Two Worlds, Same Idea

🚀 SQL Stored Procedures vs. Python Functions: Two Worlds, Same Idea

Comments 1
2 min read
Database Optimization: Techniques, Benefits, and Best Practices

Database Optimization: Techniques, Benefits, and Best Practices

2
Comments
15 min read
Three (3) Tips for efficient SQL Queries

Three (3) Tips for efficient SQL Queries

Comments
1 min read
Write Clean SQL: Tools That Format Your Queries for You

Write Clean SQL: Tools That Format Your Queries for You

Comments
1 min read
Hibernate Performance: Boost High-Volume Queries with Read-Only Sessions

Hibernate Performance: Boost High-Volume Queries with Read-Only Sessions

Comments
2 min read
History of NoSQL: The Data Management Revolution

History of NoSQL: The Data Management Revolution

5
Comments
4 min read
loading...