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.
Enterprise Software Vendors: Drive Compliance & Customer Insights with MindsDB Knowledge Bases + Hybrid Search
mindsdbteam profile

Enterprise Software Vendors: Drive Compliance & Customer Insights with MindsDB Knowledge Bases + Hybrid Search

#ai #sql #knowledgebase #tutorial
Comments
12 min read
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
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.