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.
PlanetScale vs. ⚔ Neon: the Continued Saga between MySQL 🐬 and PostgreSQL 🐘
op3ratordec profile

PlanetScale vs. ⚔ Neon: the Continued Saga between MySQL 🐬 and PostgreSQL 🐘

#sql #mysql #postgres #database
6
Comments
9 min read
MySQL Timeout 🐬⏰ Explained
op3ratordec profile

MySQL Timeout 🐬⏰ Explained

#mysql #database #sql #learning
5
Comments
5 min read
Count Date Ranges per Year — From SQL to SPL #23
judith677 profile

Count Date Ranges per Year — From SQL to SPL #23

#programming #database #sql #esprocspl
8
Comments 1
2 min read
Using SQL for data analysis seems to be a false proposition
esproc_spl profile

Using SQL for data analysis seems to be a false proposition

#sql #programming #devops #esproc
9
Comments 7
6 min read
Como Conectar ao DuckDB com C++
marcosplusplus profile

Como Conectar ao DuckDB com C++

#cpp #duckdb #sql
2
Comments
4 min read
How to Connect to DuckDB with C++
marcosplusplus profile

How to Connect to DuckDB with C++

#cpp #sql #duckdb
1
Comments
3 min read
DBMS MAKAUT MCQs
ha3k profile

DBMS MAKAUT MCQs

#beginners #database #sql #datascience
2
Comments
20 min read
My Journey with ASP.NET Core & SQL Server: Lessons Learned
yasser_alsousi profile

My Journey with ASP.NET Core & SQL Server: Lessons Learned

#dotnet #csharp #webdev #sql
Comments
1 min read
Database Management Systems: A Visual Guide
ha3k profile

Database Management Systems: A Visual Guide

#database #dbms #programming #sql
2
Comments
12 min read
Building a RAG System with Firebase Functions, OpenAI, and Pinecone
neetigyachahar profile

Building a RAG System with Firebase Functions, OpenAI, and Pinecone

#firebase #ai #rag #sql
3
Comments
3 min read
How to install Maven (Apache Maven) on Windows 11?
yofreor profile

How to install Maven (Apache Maven) on Windows 11?

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