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.
Handle Large PostgreSQL Schemas with a GUI Tool
roxana_haidiner profile

Handle Large PostgreSQL Schemas with a GUI Tool

#postgres #postgressql #database #sql
6
Comments
3 min read
Combine Two JSON Collections with Nested Arrays: MongoDB and PostgreSQL Aggregations
franckpachot profile

Combine Two JSON Collections with Nested Arrays: MongoDB and PostgreSQL Aggregations

#mongodb #postgres #sql #json
Comments
8 min read
Filtering and Retrieving in SQL
koustav profile

Filtering and Retrieving in SQL

#sql #mysql #database #tutorial
1
Comments 2
3 min read
SQL Rewriting vs. Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains
rebooter_s profile

SQL Rewriting vs. Indexing: How AI-Powered Structural Optimization Achieves 20x Scalability Gains

#sql #mysql #performance #ai
1
Comments 1
14 min read
Ditch REST: How React + SQL + WebSockets Can Power Real-Time Apps Without the Overhead
ekwoster profile

Ditch REST: How React + SQL + WebSockets Can Power Real-Time Apps Without the Overhead

#react #sql #webdev #realtime
Comments
3 min read
Oracle SQL Plan Management - 23ai features backported to 19.22
abhilash8 profile

Oracle SQL Plan Management - 23ai features backported to 19.22

#sql #oracle #tuning #oci
Comments
4 min read
Simplifying SQL Date Data Types with Practical Tips
dbvismarketing profile

Simplifying SQL Date Data Types with Practical Tips

#sql #mysql #oracle #postgressql
Comments
1 min read
Sagas vs ACID Transactions: Ensuring Reliability in Distributed Architectures
andrey_s profile

Sagas vs ACID Transactions: Ensuring Reliability in Distributed Architectures

#sql #dataengineering #database #analytics
1
Comments
11 min read
Zero Downtime Migrations: Shadow Table Strategy Explained
zeedu_dev profile

Zero Downtime Migrations: Shadow Table Strategy Explained

#database #backend #sql
1
Comments
9 min read
Stored Procedures: Organization and Code Quality in SQL
lulucasalves profile

Stored Procedures: Organization and Code Quality in SQL

#sql #database #mysql #postgres
Comments
2 min read
Why Use SQL Databases for AI Agent Memory
bobur profile

Why Use SQL Databases for AI Agent Memory

#programming #sql #database #ai
12
Comments 1
6 min read
Understanding the ACID Concept with PostgreSQL
coder7475 profile

Understanding the ACID Concept with PostgreSQL

#databse #postgres #sql #acid
2
Comments 1
5 min read
SQLite functions: unistr and unistr quote
mr_destructive profile

SQLite functions: unistr and unistr quote

#sqlite #sql #database #backend
1
Comments
2 min read
Stop Writing SQL by Hand: Building My MVP to Chat With Databases
arseniydev profile

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

#database #ai #sql #saas
Comments
2 min read
ACID, Isolation Levels, and MVCC: Architecture and Execution in Relational Databases
andrey_s profile

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

#sql #dataengineering #analytics #bigdata
2
Comments
10 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.