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.
How to Detect and Defend Against SQL Injection Attacks - Part 3[Must Read]

How to Detect and Defend Against SQL Injection Attacks - Part 3[Must Read]

5
Comments
4 min read
INSTEAD OF Trigger | Oracle SQL

INSTEAD OF Trigger | Oracle SQL

5
Comments
3 min read
How to Detect and Defend Against SQL Injection Attacks - Part 2

How to Detect and Defend Against SQL Injection Attacks - Part 2

5
Comments
4 min read
Advancing Data Access with Text to SQL Technology

Advancing Data Access with Text to SQL Technology

Comments
5 min read
TrailBase: Fast & Open FireBase Alternative

TrailBase: Fast & Open FireBase Alternative

Comments
6 min read
LIBRARY MANAGEMENT SYSTEM USING JAVA AND SQL

LIBRARY MANAGEMENT SYSTEM USING JAVA AND SQL

Comments
1 min read
Working with PostgreSQL Date and Time Functions

Working with PostgreSQL Date and Time Functions

Comments
3 min read
Things Platform Engineers Lack When Dealing With Databases

Things Platform Engineers Lack When Dealing With Databases

Comments
3 min read
SUBSTR function in Oracle

SUBSTR function in Oracle

5
Comments
1 min read
Packages in Oracle SQL | Package specification | Package body

Packages in Oracle SQL | Package specification | Package body

Comments
1 min read
17 Practical Examples of the CREATE TABLE Statement

17 Practical Examples of the CREATE TABLE Statement

2
Comments
1 min read
Crossing the Line before the Finish Line. Also the line before that.

Crossing the Line before the Finish Line. Also the line before that.

Comments
2 min read
🗂️ Master SQL Review with GUI 🎛️, GitOps 🖇️ and API 🔌

🗂️ Master SQL Review with GUI 🎛️, GitOps 🖇️ and API 🔌

5
Comments
6 min read
The Amazing SQL Recursive Queries

The Amazing SQL Recursive Queries

Comments
3 min read
How to Detect and Defend Against SQL Injection Attacks(Part-1)[Must Read]

How to Detect and Defend Against SQL Injection Attacks(Part-1)[Must Read]

5
Comments
4 min read
AI-Driven SQL Query Optimization and Big Data Integration

AI-Driven SQL Query Optimization and Big Data Integration

Comments
3 min read
The Power of OUTER APPLY: A SQL Weapon to Expand Legacy Database

The Power of OUTER APPLY: A SQL Weapon to Expand Legacy Database

6
Comments 1
6 min read
A Comparison of Top Private and Browser Based SQL on CSV Tools

A Comparison of Top Private and Browser Based SQL on CSV Tools

Comments
3 min read
🇩🇪 Datenmanipulation und Abfragen mit SQL

🇩🇪 Datenmanipulation und Abfragen mit SQL

Comments
8 min read
Online SQL Editors: Exploring Window Functions in MySQL and Their Practical Applications

Online SQL Editors: Exploring Window Functions in MySQL and Their Practical Applications

Comments
4 min read
ACID Properties in Databases: What Happens Without Them?

ACID Properties in Databases: What Happens Without Them?

5
Comments
6 min read
SQL: Multi field mixed deduplication followed by numbering #eg81

SQL: Multi field mixed deduplication followed by numbering #eg81

6
Comments
2 min read
What is SQL, and Why is it Essential in Modern Computing?

What is SQL, and Why is it Essential in Modern Computing?

Comments
1 min read
Best Practices for Using GROUP BY in MySQL for Converting Vertical Data to JSON

Best Practices for Using GROUP BY in MySQL for Converting Vertical Data to JSON

Comments
5 min read
Automating API endpoint testing with Spin

Automating API endpoint testing with Spin

Comments
5 min read
3 Hot Trends In Database Reliability

3 Hot Trends In Database Reliability

Comments
4 min read
Entity Relationship Diagram[ERD]

Entity Relationship Diagram[ERD]

Comments
2 min read
Beyond LIKE: Advanced Text Search and Keyword Matching in Postgres using Full Text Search

Beyond LIKE: Advanced Text Search and Keyword Matching in Postgres using Full Text Search

2
Comments
4 min read
PostgreSQL Connection Pooling vs No Pooling: Benchmark Analysis

PostgreSQL Connection Pooling vs No Pooling: Benchmark Analysis

Comments
3 min read
ROLLUP

ROLLUP

Comments
2 min read
SQL Window functions: Understanding PARTITION BY

SQL Window functions: Understanding PARTITION BY

1
Comments
5 min read
Validatorian

Validatorian

Comments
4 min read
Improve Your MySQL Database Design and Management with DbSchema

Improve Your MySQL Database Design and Management with DbSchema

3
Comments 1
6 min read
Avoid SELECT *, even on a single-column tables

Avoid SELECT *, even on a single-column tables

1
Comments
4 min read
Preventing SQL Injection (SQLi) in React.js Apps

Preventing SQL Injection (SQLi) in React.js Apps

Comments
3 min read
Entendo a ordem de execução de uma query SQL

Entendo a ordem de execução de uma query SQL

Comments
2 min read
Preventing SQL Injection (SQLi) Attacks in Drupal

Preventing SQL Injection (SQLi) Attacks in Drupal

Comments
3 min read
GrowthBook Version 3.3

GrowthBook Version 3.3

Comments
2 min read
How to use variables in SQL raiserror

How to use variables in SQL raiserror

Comments
1 min read
Database Sharding: Simplifying Data Scalability

Database Sharding: Simplifying Data Scalability

Comments
7 min read
Oracle SQL Script Browser Online

Oracle SQL Script Browser Online

2
Comments
1 min read
# 揭秘Proof of SQL:让数据验证变得高效又安全

# 揭秘Proof of SQL:让数据验证变得高效又安全

Comments
1 min read
How to remove duplicates in Postgres SQL

How to remove duplicates in Postgres SQL

Comments
4 min read
Database Normalization

Database Normalization

2
Comments
4 min read
Ensuring Data Integrity in Financial Transactions: The PostgreSQL Transaction Solution

Ensuring Data Integrity in Financial Transactions: The PostgreSQL Transaction Solution

5
Comments
4 min read
Statement Level Trigger vs Row Level Trigger

Statement Level Trigger vs Row Level Trigger

5
Comments
2 min read
How to Install PostgreSQL on Ubuntu 22.04 LTS

How to Install PostgreSQL on Ubuntu 22.04 LTS

3
Comments
10 min read
Understanding SQL Subqueries and Common Table Expressions (CTEs)

Understanding SQL Subqueries and Common Table Expressions (CTEs)

2
Comments
4 min read
Something Would Free Data Scientists from Heavy Coding Work

Something Would Free Data Scientists from Heavy Coding Work

6
Comments
9 min read
Understanding and Using Window Functions in SQL

Understanding and Using Window Functions in SQL

Comments
1 min read
Understanding Sequelize's 'escape' function and why ideally we should avoid using it manually

Understanding Sequelize's 'escape' function and why ideally we should avoid using it manually

Comments 2
6 min read
SQL Server Execution Plans

SQL Server Execution Plans

6
Comments
5 min read
PostgreSQL - lowCalAlt_update2

PostgreSQL - lowCalAlt_update2

Comments
1 min read
How indexes power your database

How indexes power your database

3
Comments
4 min read
Top 🐘👀 Postgres Monitoring Tools 🧰 and Best Practices in 2024 🔝

Top 🐘👀 Postgres Monitoring Tools 🧰 and Best Practices in 2024 🔝

5
Comments
4 min read
These 10+ comparisons cover entire SQL concepts, Is it?

These 10+ comparisons cover entire SQL concepts, Is it?

Comments
6 min read
Advanced Paradigms in Data Ingestion: Integrating Big Data Ecosystems with Linux, SQL

Advanced Paradigms in Data Ingestion: Integrating Big Data Ecosystems with Linux, SQL

Comments
3 min read
SQL Server: Usare l'Istruzione LIKE all'Interno di una WHERE

SQL Server: Usare l'Istruzione LIKE all'Interno di una WHERE

Comments
3 min read
How We Built 🔧🦾 the SQL Autocomplete Framework ⚙️🧱 with ANTLR4

How We Built 🔧🦾 the SQL Autocomplete Framework ⚙️🧱 with ANTLR4

10
Comments
10 min read
SQL Indexes

SQL Indexes

Comments
3 min read
loading...