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.
Segmented Accumulation by Condition — From SQL to SPL #30

Segmented Accumulation by Condition — From SQL to SPL #30

6
Comments 1
1 min read
Memelang: Hybrid graph-relational query language for RAG

Memelang: Hybrid graph-relational query language for RAG

Comments
4 min read
Spark Augmented Reality (AR) Filter Engagement Metrics

Spark Augmented Reality (AR) Filter Engagement Metrics

1
Comments
3 min read
PawSQL Community Edition: A Free & Self-Hosted Enterprise-Grade SQL Optimizer, Now Available to Individual Developers

PawSQL Community Edition: A Free & Self-Hosted Enterprise-Grade SQL Optimizer, Now Available to Individual Developers

2
Comments
3 min read
MySQL — Removendo Full Only Group By no MacOS X

MySQL — Removendo Full Only Group By no MacOS X

Comments 1
1 min read
🔷 Top 20+ .NET & OOPs Interview Questions (Easy Guide for Freshers)

🔷 Top 20+ .NET & OOPs Interview Questions (Easy Guide for Freshers)

4
Comments
3 min read
Query YAML Like a Database — Why I Built YamlQL (And How It Works)

Query YAML Like a Database — Why I Built YamlQL (And How It Works)

3
Comments
4 min read
What is SQL and Why Does It Matter

What is SQL and Why Does It Matter

Comments
2 min read
Row to Column Conversion Involving Uncertain Columns — From SQL to SPL #41

Row to Column Conversion Involving Uncertain Columns — From SQL to SPL #41

10
Comments 3
2 min read
Query Optimization Isn’t Optional—It’s Profit

Query Optimization Isn’t Optional—It’s Profit

Comments
3 min read
Types of SQL statements

Types of SQL statements

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

Comments 1
2 min read
Rove : Straight up PostgreSQL migration.

Rove : Straight up PostgreSQL migration.

1
Comments
2 min read
Oracle PL/SQL - Basic Terms

Oracle PL/SQL - Basic Terms

Comments
1 min read
Best Oracle Database Design Tools in 2025

Best Oracle Database Design Tools in 2025

13
Comments 8
7 min read
How to Document a PostgreSQL Schema in 2025

How to Document a PostgreSQL Schema in 2025

13
Comments 1
4 min read
Why is Your MyBatis Slow? One Line of Config Can Double Its Performance!

Why is Your MyBatis Slow? One Line of Config Can Double Its Performance!

1
Comments
5 min read
Introducing gq-to-sql: Convert Graph-Style URL Queries into SQL

Introducing gq-to-sql: Convert Graph-Style URL Queries into SQL

4
Comments 3
1 min read
Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40

Search for Records Containing a Specified String Group in Multi Fields — From SQL to SPL #40

11
Comments 3
2 min read
The LIMIT offset, count Trap: Why Large Offsets Slow Down MySQL?

The LIMIT offset, count Trap: Why Large Offsets Slow Down MySQL?

Comments
5 min read
Find Consecutive Alphabetical Characters in String — From SQL to SPL #28

Find Consecutive Alphabetical Characters in String — From SQL to SPL #28

8
Comments 1
2 min read
How to Create a New MySQL User and Grant All Permissions

How to Create a New MySQL User and Grant All Permissions

Comments
2 min read
Where to Learn SQL for Free: Best Platforms and Resources

Where to Learn SQL for Free: Best Platforms and Resources

Comments
5 min read
Web Scraping to SQL: How to Effectively Store and Analyze Your Scraped Data

Web Scraping to SQL: How to Effectively Store and Analyze Your Scraped Data

Comments
5 min read
Smarter Databases with SQL Views and Triggers

Smarter Databases with SQL Views and Triggers

Comments
5 min read
loading...