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.
Oracle 21c Enhancements for TTS Export/Import

Oracle 21c Enhancements for TTS Export/Import

Comments
2 min read
IoT monitoring with Kafka and Tinybird
Cover image for IoT monitoring with Kafka and Tinybird

IoT monitoring with Kafka and Tinybird

1
Comments
9 min read
The Best Tools to Design Database Schemas Visually in 2025
Cover image for The Best Tools to Design Database Schemas Visually in 2025

The Best Tools to Design Database Schemas Visually in 2025

10
Comments 3
7 min read
MySQL vs MongoDB - Visual Design with Real Data Models
Cover image for MySQL vs MongoDB - Visual Design with Real Data Models

MySQL vs MongoDB - Visual Design with Real Data Models

11
Comments 2
5 min read
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
Can ADO.NET Be Used in Modern Web Applications?

Can ADO.NET Be Used in Modern Web Applications?

Comments
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
EF Query vs SQL View in Entity Framework – Which One Would You Choose?

EF Query vs SQL View in Entity Framework – Which One Would You Choose?

Comments 1
3 min read
I built a blazing-fast AI-Powered SQL editor ⚡️
Cover image for I built a blazing-fast AI-Powered SQL editor ⚡️

I built a blazing-fast AI-Powered SQL editor ⚡️

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

Is This a Refreshing Way to Understand Association?

6
Comments 1
7 min read
Understanding Database Indexes: A Library Analogy
Cover image for Understanding Database Indexes: A Library Analogy

Understanding Database Indexes: A Library Analogy

Comments
4 min read
Oracle AI Database 26ai — Applying Grid Infrastructure Patches via GUI(Zero-Downtime)

Oracle AI Database 26ai — Applying Grid Infrastructure Patches via GUI(Zero-Downtime)

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