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.
Como Conectar ao DuckDB com C++

Como Conectar ao DuckDB com C++

2
Comments
4 min read
How to Connect to DuckDB with C++

How to Connect to DuckDB with C++

1
Comments
3 min read
DBMS MAKAUT MCQs

DBMS MAKAUT MCQs

2
Comments
20 min read
My Journey with ASP.NET Core & SQL Server: Lessons Learned

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

Comments
1 min read
Database Management Systems: A Visual Guide

Database Management Systems: A Visual Guide

3
Comments
12 min read
Building a RAG System with Firebase Functions, OpenAI, and Pinecone

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

3
Comments
3 min read
How to install Maven (Apache Maven) on Windows 11?

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

5
Comments
2 min read
SQL vs. NoSQL | Schema Design Differences Explained Visually

SQL vs. NoSQL | Schema Design Differences Explained Visually

13
Comments 2
5 min read
PostgreSQL 🐘 Hosting Options in 2025: Pricing Comparison 💸⚖️

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

5
Comments
5 min read
Summarize Row Counts by Dynamic Columns into JSON — From SQL to SPL #22

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

6
Comments 1
2 min read
What should we do when SQL (and stored procedure) runs too slowly?

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

13
Comments 6
13 min read
Aggregate according to Time Interval — From SQL to SPL #27

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

9
Comments 3
2 min read
Design Database Schemas Without Internet Connection

Design Database Schemas Without Internet Connection

10
Comments 3
3 min read
Mastering SQL Joins: INNER, LEFT, RIGHT, FULL Explained

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

2
Comments
3 min read
Statistics by Time Window — From SQL to SPL #31

Statistics by Time Window — From SQL to SPL #31

10
Comments 3
3 min read
👋 Sign in for the ability to sort posts by relevant, latest, or top.