Forem

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.
New Tech Talk Proposal 😎 Just Dropped
Cover image for New Tech Talk Proposal 😎 Just Dropped

New Tech Talk Proposal 😎 Just Dropped

3
Comments 1
2 min read
Getting the Available Ranges from Two Tables — From SQL to SPL #34
Cover image for Getting the Available Ranges from Two Tables — From SQL to SPL #34

Getting the Available Ranges from Two Tables — From SQL to SPL #34

9
Comments 3
3 min read
MongoDB vs PostgreSQL JSONB: A Deep Dive into Performance and Use Cases

MongoDB vs PostgreSQL JSONB: A Deep Dive into Performance and Use Cases

1
Comments 1
2 min read
How Snowflake Copilot Inline Transformed My SQL Analysis Experience

How Snowflake Copilot Inline Transformed My SQL Analysis Experience

6
Comments 2
5 min read
🛡️ Understanding and Exploiting Blind SQL Injection
Cover image for 🛡️ Understanding and Exploiting Blind SQL Injection

🛡️ Understanding and Exploiting Blind SQL Injection

Comments 1
3 min read
Is This a Refreshing Way to Understand Association?

Is This a Refreshing Way to Understand Association?

6
Comments 1
7 min read
Your PostgreSQL Command Cheat Sheet (But Way More Useful!)

Your PostgreSQL Command Cheat Sheet (But Way More Useful!)

3
Comments
6 min read
PlanetScale vs. ⚔ Neon: the Continued Saga between MySQL 🐬 and PostgreSQL 🐘
Cover image for PlanetScale vs. ⚔ Neon: the Continued Saga between MySQL 🐬 and PostgreSQL 🐘

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

6
Comments
9 min read
MySQL Timeout 🐬⏰ Explained
Cover image for MySQL Timeout 🐬⏰ Explained

MySQL Timeout 🐬⏰ Explained

5
Comments
5 min read
Count Date Ranges per Year — From SQL to SPL #23
Cover image for Count Date Ranges per Year — From SQL to SPL #23

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

8
Comments 1
2 min read
Using SQL for data analysis seems to be a false proposition

Using SQL for data analysis seems to be a false proposition

9
Comments 7
6 min read
Como Conectar ao DuckDB com C++
Cover image for Como Conectar ao DuckDB com C++

Como Conectar ao DuckDB com C++

2
Comments
4 min read
How to Connect to DuckDB with C++
Cover image for 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
Cover image for My Journey with ASP.NET Core & SQL Server: Lessons Learned

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

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