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.
Understanding Recursive Queries in PostgreSQL: A Process Hierarchy Example

Understanding Recursive Queries in PostgreSQL: A Process Hierarchy Example

Comments
3 min read
PL/SQL Cursors

PL/SQL Cursors

5
Comments 2
4 min read
DbVisualizer 24.2: A Complete Review

DbVisualizer 24.2: A Complete Review

9
Comments
11 min read
PL/SQL Triggers

PL/SQL Triggers

1
Comments
3 min read
Deleting Duplicate Data from MySQL

Deleting Duplicate Data from MySQL

1
Comments
3 min read
Different ways of working with SQL Databases in Go

Different ways of working with SQL Databases in Go

2
Comments
9 min read
PLSQL Top 10 Interview Questions

PLSQL Top 10 Interview Questions

1
Comments
4 min read
How I used ChatGPT o1 and Claude for generating a SQL RBAC report and was surprised by the results

How I used ChatGPT o1 and Claude for generating a SQL RBAC report and was surprised by the results

2
Comments
9 min read
Deploy a lightweight BI solution with your first dashboard in 5 steps

Deploy a lightweight BI solution with your first dashboard in 5 steps

1
Comments
2 min read
NoSQL vs SQL Which one you should use ?

NoSQL vs SQL Which one you should use ?

6
Comments
3 min read
Database Dizaynda Kalitlar: Hamma Joyda Kalit! đź—ť

Database Dizaynda Kalitlar: Hamma Joyda Kalit! đź—ť

1
Comments
5 min read
Fundamentals of Transact-SQL (T-SQL) Queries

Fundamentals of Transact-SQL (T-SQL) Queries

Comments
2 min read
ERROR: index row size 3056 exceeds btree version 4 maximum 2704 for index

ERROR: index row size 3056 exceeds btree version 4 maximum 2704 for index

6
Comments
4 min read
7 SQL Concepts You Should Know as a Data Scientist?

7 SQL Concepts You Should Know as a Data Scientist?

4
Comments
3 min read
Essential Database Concepts Explained

Essential Database Concepts Explained

Comments
2 min read
How To Use The SQL Server ALTER Keyword To Modify Database Objects

How To Use The SQL Server ALTER Keyword To Modify Database Objects

Comments
9 min read
Chat2DB: Data Analysis Without Writing SQL Code

Chat2DB: Data Analysis Without Writing SQL Code

2
Comments
4 min read
🗄️🚀 SQL vs NoSQL: Viability and Comparison

🗄️🚀 SQL vs NoSQL: Viability and Comparison

9
Comments 4
2 min read
Comprehensive SQL Project: Mastering Database Manipulation

Comprehensive SQL Project: Mastering Database Manipulation

Comments
3 min read
Cleaning up personal expense data with SQL

Cleaning up personal expense data with SQL

1
Comments
19 min read
CURSOR in PLSQL | Best Explanation

CURSOR in PLSQL | Best Explanation

7
Comments 1
3 min read
Use Natural Language to Query Your Database with Chat2DB

Use Natural Language to Query Your Database with Chat2DB

4
Comments
5 min read
Configuring a Connection Pool

Configuring a Connection Pool

Comments
7 min read
Mastering Built-in Functions in Oracle SQL

Mastering Built-in Functions in Oracle SQL

Comments
3 min read
Comprehensive Analysis of Attack Events with SafeLine WAF

Comprehensive Analysis of Attack Events with SafeLine WAF

8
Comments
2 min read
SQL JOIN.

SQL JOIN.

Comments
5 min read
Java, fill each row having a null value in a csv file with values in the directly previous row #eg32

Java, fill each row having a null value in a csv file with values in the directly previous row #eg32

6
Comments
1 min read
To Index Data is To Sort Data

To Index Data is To Sort Data

8
Comments
5 min read
I deleted our database after 72 hours of no sleep.

I deleted our database after 72 hours of no sleep.

Comments
1 min read
AI Productivity Tips 1 - SQL Companion Bot with Gemini 1.5 Pro

AI Productivity Tips 1 - SQL Companion Bot with Gemini 1.5 Pro

Comments
2 min read
Understanding Your Data: The Essentials of Exploratory Data Analysis

Understanding Your Data: The Essentials of Exploratory Data Analysis

Comments
3 min read
Dynamic SQL Best Practices (or "How to Avoid Both SQL Injection Vulnerabilities and Spaghetti Code")

Dynamic SQL Best Practices (or "How to Avoid Both SQL Injection Vulnerabilities and Spaghetti Code")

1
Comments
11 min read
Navigating Open Source Software: All Your Questions Answered

Navigating Open Source Software: All Your Questions Answered

Comments
7 min read
Securing PHP Applications Against SQL Injection Attacks

Securing PHP Applications Against SQL Injection Attacks

Comments 4
3 min read
Libraries for writing raw SQL safely

Libraries for writing raw SQL safely

1
Comments
8 min read
Clear duplicate lines and lines having missing values from a csv file #eg24

Clear duplicate lines and lines having missing values from a csv file #eg24

7
Comments 1
1 min read
Introducing Qiu!

Introducing Qiu!

6
Comments
2 min read
PL/SQL scripts, stored procedures, and triggers

PL/SQL scripts, stored procedures, and triggers

Comments
3 min read
Enhancing Laravel Models with a Case-Insensitive Searchable Trait

Enhancing Laravel Models with a Case-Insensitive Searchable Trait

1
Comments
3 min read
🗂️ Understanding SQL Relationships: A Beginner's Guide

🗂️ Understanding SQL Relationships: A Beginner's Guide

1
Comments
3 min read
đź“ť SQL Cheat Sheet for Developers

đź“ť SQL Cheat Sheet for Developers

1
Comments 1
3 min read
18 Key Points You Must Know When Creating Tables in MySQL

18 Key Points You Must Know When Creating Tables in MySQL

6
Comments
11 min read
Exploring WAFs: How SafeLine Defends Against Web Attacks

Exploring WAFs: How SafeLine Defends Against Web Attacks

6
Comments
3 min read
Déployer une solution de BI légère avec son premier dashboard en 5 étapes

Déployer une solution de BI légère avec son premier dashboard en 5 étapes

1
Comments
3 min read
Debugging Low Cache Hit Ratio

Debugging Low Cache Hit Ratio

1
Comments 1
14 min read
Mastering SQL: Best Practices for Developers

Mastering SQL: Best Practices for Developers

Comments
1 min read
Calling SQL Developers for assist

Calling SQL Developers for assist

Comments
1 min read
Top 8 Managed Postgres Providers

Top 8 Managed Postgres Providers

2
Comments
8 min read
Essential PSQL 50 Selected Practice Questions with Answers

Essential PSQL 50 Selected Practice Questions with Answers

Comments
14 min read
The Ultimate SQL JOIN Cheat Sheet

The Ultimate SQL JOIN Cheat Sheet

2
Comments
4 min read
Schema + Data migration in Prisma (adding a new mandatory field)

Schema + Data migration in Prisma (adding a new mandatory field)

Comments
2 min read
# 🚀 SQL Automation Testing: A Beginner's Guide

# 🚀 SQL Automation Testing: A Beginner's Guide

4
Comments
3 min read
Compare two csv files #eg34

Compare two csv files #eg34

7
Comments 1
1 min read
Essential MtSQL 50 Selected Practice Questions with Answers

Essential MtSQL 50 Selected Practice Questions with Answers

Comments
13 min read
SQL Query Logical Order

SQL Query Logical Order

6
Comments
2 min read
ACID Properties in Database

ACID Properties in Database

2
Comments
2 min read
How to Set Up a PostgreSQL Database on a VPS and Access It Remotely

How to Set Up a PostgreSQL Database on a VPS and Access It Remotely

8
Comments
2 min read
How to check the MySQL version on Windows, so easy that even a five-year-old can learn it

How to check the MySQL version on Windows, so easy that even a five-year-old can learn it

Comments
4 min read
Exploratory Data Analysis Using SQL.

Exploratory Data Analysis Using SQL.

Comments
3 min read
Understanding GROUP BY vs. PARTITION BY in SQL

Understanding GROUP BY vs. PARTITION BY in SQL

2
Comments
4 min read
loading...