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

New Tech Talk Proposal 😎 Just Dropped

2
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
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 ⚡️

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

Comments
2 min read
SQL Injection: All Concepts, All Payloads, All In One

SQL Injection: All Concepts, All Payloads, All In One

7
Comments 3
8 min read
How to Install and Use SQLmap on Android Termux

How to Install and Use SQLmap on Android Termux

Comments
6 min read
SQL Tutorial for Beginners: Learn the Basics Step-by-Step

SQL Tutorial for Beginners: Learn the Basics Step-by-Step

2
Comments 1
4 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

Understanding Database Indexes: A Library Analogy

Comments
4 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
The SQL Courtroom: DELETE vs TRUNCATE vs DROP (A Comic for Learners)

The SQL Courtroom: DELETE vs TRUNCATE vs DROP (A Comic for Learners)

Comments
1 min read
Perbedaan Antara SOQL dan SOSL di Salesforce

Perbedaan Antara SOQL dan SOSL di Salesforce

Comments
1 min read
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
Postgresql soft-delete strategies: balancing data retention

Postgresql soft-delete strategies: balancing data retention

Comments
3 min read
MySQL Timeout 🐬⏰ Explained

MySQL Timeout 🐬⏰ Explained

5
Comments
5 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
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
Python is a very powerful tool for Data Analysts.

Python is a very powerful tool for Data Analysts.

5
Comments
1 min read
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
🗃️ What Is SQL Manipulation? (And Why It’s Like Talking to a Super-Organized Assistant)

🗃️ What Is SQL Manipulation? (And Why It’s Like Talking to a Super-Organized Assistant)

Comments 1
3 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
Parallel Query Processing - (System-wide and Query-based)

Parallel Query Processing - (System-wide and Query-based)

Comments
6 min read
Database Management Systems: A Visual Guide

Database Management Systems: A Visual Guide

1
Comments
12 min read
Database Normalization Summary

Database Normalization Summary

Comments
1 min read
loading...