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.
What's New 🆕🤯 in PostgreSQL 18 🐘 - a DBA's Perspective
op3ratordec profile

What's New 🆕🤯 in PostgreSQL 18 🐘 - a DBA's Perspective

#sql #postgres #database #productivity
5
Comments
5 min read
Serverless Is a Lie (Unless You’re Using SQLite)
shayy profile

Serverless Is a Lie (Unless You’re Using SQLite)

#webdev #programming #javascript #sql
11
Comments 1
4 min read
SQL Server String Aggregation: FOR XML PATH vs. STRING_AGG Performance Comparison and Optimization
rebooter_s profile

SQL Server String Aggregation: FOR XML PATH vs. STRING_AGG Performance Comparison and Optimization

#sqlserver #sql #xml #agg
Comments
4 min read
AI-Driven SQL Dataset Optimization: Best Practices & Updates for Modern Applications
rebooter_s profile

AI-Driven SQL Dataset Optimization: Best Practices & Updates for Modern Applications

#database #ai #sql
Comments
8 min read
The Death of SQL? The Silent Rise of NewSQL
abhishekshakya profile

The Death of SQL? The Silent Rise of NewSQL

#sql #programming #ai #tutorial
Comments
3 min read
Introduction to SQL for data science
mungaime25 profile

Introduction to SQL for data science

#sql #database #luxdev #datascience
1
Comments
2 min read
Find the Superset from the Relationship Table — From SQL to SPL #19
judith677 profile

Find the Superset from the Relationship Table — From SQL to SPL #19

#dataengineering #sql #esprocspl #programming
1
Comments 1
1 min read
How to Set Up PostgreSQL Database with a Django Application
msnmongare profile

How to Set Up PostgreSQL Database with a Django Application

#django #python #postgres #sql
4
Comments
2 min read
Where 1 = 1 in SQL
bdavidxyz profile

Where 1 = 1 in SQL

#sql
Comments 2
1 min read
Doris: Breaking Down the Barriers of SQL Dialects and Building a Unified Data Query Ecosystem
darren_xu profile

Doris: Breaking Down the Barriers of SQL Dialects and Building a Unified Data Query Ecosystem

#sql #doris #programming #opensource
2
Comments
4 min read
Oracle Object List - Demo 00:58
abhilash8 profile

Oracle Object List - Demo

#oracle #oci #plsql #sql
Comments 1
1 min read
SQL Subqueries: Power Up Your Data Retrieval
jing_li profile

SQL Subqueries: Power Up Your Data Retrieval

#mysql #database #sql #programming
Comments
7 min read
Consultas SQL reales para un restaurante: mi primer reto en anĂĄlisis de datos
jhonny_oso profile

Consultas SQL reales para un restaurante: mi primer reto en anĂĄlisis de datos

#datascience #learning #sql #database
Comments
6 min read
SQL Optimization Techniques for Better Performance
jing_li profile

SQL Optimization Techniques for Better Performance

#database #sql #programming #beginners
Comments
13 min read
Rediscovering ACID – The Foundation of Reliable Databases
mandarg13 profile

Rediscovering ACID – The Foundation of Reliable Databases

#sql #database #postgres #mysql
Comments
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.