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.
Everyone Uses Postgres… But Why?

Everyone Uses Postgres… But Why?

1
Comments
9 min read
SQL - table assistant

SQL - table assistant

1
Comments
2 min read
JOINs (not just JSONs) can help

JOINs (not just JSONs) can help

Comments
2 min read
Navigating Databases: From SQL to NoSQL

Navigating Databases: From SQL to NoSQL

Comments
4 min read
ACID Properties in Databases - Part 2: Your Shield Against Transactional Chaos

ACID Properties in Databases - Part 2: Your Shield Against Transactional Chaos

8
Comments
5 min read
How to Monitor SQL Performance in Spring Boot

How to Monitor SQL Performance in Spring Boot

4
Comments
7 min read
🔧 Embed SQL Editor ✍️ in Your Internal Web Portal 💻

🔧 Embed SQL Editor ✍️ in Your Internal Web Portal 💻

12
Comments
5 min read
Mental Health WebApp

Mental Health WebApp

10
Comments 1
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
SQL Admin Scripts: A Practical Toolkit for Managing Servers and Databases

SQL Admin Scripts: A Practical Toolkit for Managing Servers and Databases

11
Comments
9 min read
Mastering SQLMap Tamper Scripts: The Ultimate Guide to Evading WAFs Like a Pro [Must Read Article]

Mastering SQLMap Tamper Scripts: The Ultimate Guide to Evading WAFs Like a Pro [Must Read Article]

5
Comments
3 min read
Transforming Nested JSON into Usable Data with SQL CROSS APPLY

Transforming Nested JSON into Usable Data with SQL CROSS APPLY

Comments
3 min read
How Sequences used in Oracle SQL without AUTO_INCREMENT Keyword

How Sequences used in Oracle SQL without AUTO_INCREMENT Keyword

Comments 1
1 min read
PostgreSQL CSV Import and Export Guide

PostgreSQL CSV Import and Export Guide

1
Comments
1 min read
Understanding Transaction Isolation Levels in PostgreSQL

Understanding Transaction Isolation Levels in PostgreSQL

1
Comments
2 min read
Selecting the Right Database for the Job

Selecting the Right Database for the Job

8
Comments 1
6 min read
Aurora DSQL: Create a Serverless Cluster and Connect with PostgreSQL Client

Aurora DSQL: Create a Serverless Cluster and Connect with PostgreSQL Client

12
Comments
5 min read
Mastering SQL: A Comprehensive Roadmap for Beginners (Part I)

Mastering SQL: A Comprehensive Roadmap for Beginners (Part I)

7
Comments 2
3 min read
Oracle Database Fragmentation - How to reorg Tables / Indexes

Oracle Database Fragmentation - How to reorg Tables / Indexes

16
Comments
3 min read
How to Manage Your SQL Server Database Effectively

How to Manage Your SQL Server Database Effectively

6
Comments 1
3 min read
Exploring Aurora DSQL with TypeScript, Drizzle, Lambda, and AWS CDK

Exploring Aurora DSQL with TypeScript, Drizzle, Lambda, and AWS CDK

8
Comments
5 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
Proximity Search: A Complete Guide for Developers

Proximity Search: A Complete Guide for Developers

7
Comments
3 min read
SQL: ROW_NUMBER, RANK and DENSE_RANK

SQL: ROW_NUMBER, RANK and DENSE_RANK

7
Comments
2 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
ChatWithSQL — Secure, Schema-Validated Text-to-SQL Python Library, Eliminating Arbitrary Query Risks from LLMs

ChatWithSQL — Secure, Schema-Validated Text-to-SQL Python Library, Eliminating Arbitrary Query Risks from LLMs

5
Comments
3 min read
Understanding and Using Window Functions in SQL

Understanding and Using Window Functions in SQL

Comments
1 min read
Linking Data in PostgreSQL Without Explicit Keys: A Practical Guide

Linking Data in PostgreSQL Without Explicit Keys: A Practical Guide

10
Comments
3 min read
SQL: A Guide to Create a Relational Database with SQLite (and Export to Excel)

SQL: A Guide to Create a Relational Database with SQLite (and Export to Excel)

6
Comments
4 min read
SQL: Perform statistics at different granularities based on the time span of the data #85

SQL: Perform statistics at different granularities based on the time span of the data #85

7
Comments
2 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

2
Comments
5 min read
PostgreSQL - lowCalAlt_update2

PostgreSQL - lowCalAlt_update2

Comments
1 min read
Run a Local 💻 MySQL 🐬 Instance

Run a Local 💻 MySQL 🐬 Instance

10
Comments
1 min read
SQL,Classify time-close events into a group and assign them a number #eg84

SQL,Classify time-close events into a group and assign them a number #eg84

7
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
Day 3 of SQL Series || Basic Commands

Day 3 of SQL Series || Basic Commands

5
Comments
3 min read
Improve Your PostgreSQL Database Design and Management with a GUI Tool.

Improve Your PostgreSQL Database Design and Management with a GUI Tool.

5
Comments 1
6 min read
End Of Series: SQL Injection Detect & Defend

End Of Series: SQL Injection Detect & Defend

5
Comments 1
1 min read
Just-in-Time Database Access

Just-in-Time Database Access

5
Comments
2 min read
Part 9: SQL Injection Series - Building Honeypots for Real-Time Detection

Part 9: SQL Injection Series - Building Honeypots for Real-Time Detection

5
Comments
3 min read
Part 6: SQL Injection Series: Case Studies and Lessons Learned

Part 6: SQL Injection Series: Case Studies and Lessons Learned

6
Comments
4 min read
Part 5: SQL Injection Series: Future Trends and Emerging Challenges

Part 5: SQL Injection Series: Future Trends and Emerging Challenges

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
Part 4: SQL Injection Series: Real-World Scenarios Deep Dive

Part 4: SQL Injection Series: Real-World Scenarios Deep Dive

5
Comments
4 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
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
SQL Indexes

SQL Indexes

Comments
3 min read
Split a Huge CSV File into Multiple Smaller CSV Files #eg69

Split a Huge CSV File into Multiple Smaller CSV Files #eg69

6
Comments 1
1 min read
INSTEAD OF Trigger | Oracle SQL

INSTEAD OF Trigger | Oracle SQL

8
Comments
3 min read
Introduction to DBMS

Introduction to DBMS

Comments
4 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]

6
Comments
4 min read
SQL "SELECT INTO" vs "INSERT INTO SELECT" statements.

SQL "SELECT INTO" vs "INSERT INTO SELECT" statements.

Comments
1 min read
How Pipe Syntax Fix SQL Design Problems

How Pipe Syntax Fix SQL Design Problems

Comments
5 min read
TrailBase: Fast & Open FireBase Alternative

TrailBase: Fast & Open FireBase Alternative

Comments
6 min read
loading...