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.
SQL vs. NoSQL | Schema Design Differences Explained Visually
roxana_haidiner profile

SQL vs. NoSQL | Schema Design Differences Explained Visually

#sql #nosql #database #mysql
13
Comments 2
5 min read
PostgreSQL 🐘 Hosting Options in 2025: Pricing Comparison 💸⚖️
op3ratordec profile

PostgreSQL 🐘 Hosting Options in 2025: Pricing Comparison 💸⚖️

#postgres #sql #aws #azure
5
Comments
5 min read
Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22
judith677 profile

Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22

#programming #sql #database #esprocspl
6
Comments 1
2 min read
What should we do when SQL (and stored procedure) runs too slowly?
esproc_spl profile

What should we do when SQL (and stored procedure) runs too slowly?

#news #sql #programming #devops
13
Comments 6
13 min read
Aggregate according to Time Interval — From SQL to SPL #27
judith677 profile

Aggregate according to Time Interval — From SQL to SPL #27

#programming #database #sql #esprocspl
9
Comments 3
2 min read
Design Database Schemas Without Internet Connection
roxana_haidiner profile

Design Database Schemas Without Internet Connection

#database #design #diagram #sql
10
Comments 3
3 min read
Mastering SQL Joins: INNER, LEFT, RIGHT, FULL Explained
pythontutorial profile

Mastering SQL Joins: INNER, LEFT, RIGHT, FULL Explained

#sql #sqltutorial #sqlform #programming
2
Comments
3 min read
Statistics by Time Window — From SQL to SPL #31
judith677 profile

Statistics by Time Window — From SQL to SPL #31

#programming #database #sql #esprocspl
10
Comments 3
3 min read
Full Stack Development with Spring Boot (အခန်း ၈)
zawhtutwin profile

Full Stack Development with Spring Boot (အခန်း ၈)

#java #programming #softwaredevelopment #sql
Comments
1 min read
Oracle AI Database 26ai - Fast Ingest Enhancements
vahidusefzadeh profile

Oracle AI Database 26ai - Fast Ingest Enhancements

#linux #sql #database #devops
Comments
2 min read
SQL for Everyone: The Ultimate Starter Guide
_bhupeshk_ profile

SQL for Everyone: The Ultimate Starter Guide

#sql #programming #database #beginners
3
Comments 3
19 min read
Sparse & Dense Indexes in DBMS
prashanthm07 profile

Sparse & Dense Indexes in DBMS

#database #sql #systemdesign
1
Comments
3 min read
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
👋 Sign in for the ability to sort posts by relevant, latest, or top.