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.
Relational Databases vs. NoSQL

Relational Databases vs. NoSQL

Comments
2 min read
Configuring a Connection Pool

Configuring a Connection Pool

Comments
7 min read
5 Essential SQL Skills Learned from a Decade of Experience

5 Essential SQL Skills Learned from a Decade of Experience

52
Comments 29
4 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.

2
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
The Journey from Edgar F. Codd to Modern SQL: How Relational Databases Changed the World

The Journey from Edgar F. Codd to Modern SQL: How Relational Databases Changed the World

5
Comments 1
5 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
50x Faster Window Functions? PawSQL's Index Magic Revealed

50x Faster Window Functions? PawSQL's Index Magic Revealed

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