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.
SQL DDL Commands Explained: Structuring Your Database

SQL DDL Commands Explained: Structuring Your Database

Comments
2 min read
Beginner's Guide to ADO.NET: Connection, Command & Dataset Explained

Beginner's Guide to ADO.NET: Connection, Command & Dataset Explained

Comments
1 min read
Hands-On WrenAI Review: Text-to-SQL Powered by RAG

Hands-On WrenAI Review: Text-to-SQL Powered by RAG

Comments
3 min read
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
How to install Maven (Apache Maven) on Windows 11?

How to install Maven (Apache Maven) on Windows 11?

2
Comments
2 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
What is SQL and Why You Should Learn It

What is SQL and Why You Should Learn It

Comments
1 min read
Sparse & Dense Indexes in DBMS

Sparse & Dense Indexes in DBMS

1
Comments
3 min read
SQL for Everyone: The Ultimate Starter Guide

SQL for Everyone: The Ultimate Starter Guide

3
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
loading...