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.
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
Navigating MariaDB on HTB’s ‘Sequel’ Box to Retrieve the Flag

Navigating MariaDB on HTB’s ‘Sequel’ Box to Retrieve the Flag

Comments
1 min read
Why T-SQL’s Most Misunderstood Keyword Is Actually It's Safest

Why T-SQL’s Most Misunderstood Keyword Is Actually It's Safest

Comments 2
27 min read
I am Learning SQL(mysql) in 2025.

I am Learning SQL(mysql) in 2025.

4
Comments 2
1 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
SQL Server for NoSQL

SQL Server for NoSQL

Comments
1 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
Full Stack Development with Spring Boot (အခန်း ၈)

Full Stack Development with Spring Boot (အခန်း ၈)

Comments
1 min read
Oracle Database 23ai Fast Ingest Enhancements

Oracle Database 23ai Fast Ingest Enhancements

Comments
2 min read
SQL for Everyone: The Ultimate Starter Guide

SQL for Everyone: The Ultimate Starter Guide

7
Comments 3
19 min read
What's New 🆕🤯 in PostgreSQL 18 🐘 - a DBA's Perspective

What's New 🆕🤯 in PostgreSQL 18 🐘 - a DBA's Perspective

5
Comments
5 min read
Serverless Is a Lie (Unless You’re Using SQLite)

Serverless Is a Lie (Unless You’re Using SQLite)

11
Comments 1
4 min read
AI-Driven SQL Dataset Optimization: Best Practices & Updates for Modern Applications

AI-Driven SQL Dataset Optimization: Best Practices & Updates for Modern Applications

Comments
8 min read
Database Systems Question Bank

Database Systems Question Bank

7
Comments
31 min read
The Death of SQL? The Silent Rise of NewSQL

The Death of SQL? The Silent Rise of NewSQL

Comments
3 min read
Introduction to SQL for data science

Introduction to SQL for data science

1
Comments
2 min read
Find the Superset from the Relationship Table — From SQL to SPL #19

Find the Superset from the Relationship Table — From SQL to SPL #19

1
Comments 1
1 min read
How to Set Up PostgreSQL Database with a Django Application

How to Set Up PostgreSQL Database with a Django Application

2
Comments
2 min read
TiDB’s Chat2Query: Instant Business Insights, No SQL Required

TiDB’s Chat2Query: Instant Business Insights, No SQL Required

Comments
4 min read
loading...