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.
Oracle Database Fragmentation - How to reorg Tables / Indexes

Oracle Database Fragmentation - How to reorg Tables / Indexes

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

12
Comments
5 min read
Day 4 of SQL Series || SELECT Statement Use cases

Day 4 of SQL Series || SELECT Statement Use cases

7
Comments
3 min read
Proximity Search: A Complete Guide for Developers

Proximity Search: A Complete Guide for Developers

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

SQL PATTERNS: ROW_NUMBER, RANK and DENSE_RANK

8
Comments
2 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
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
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
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
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
Improve Your PostgreSQL Database Design and Management with a GUI Tool.

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

9
Comments 2
6 min read
Day 3 of SQL Series || Basic Commands

Day 3 of SQL Series || Basic Commands

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

End Of Series: SQL Injection Detect & Defend

5
Comments 1
1 min read
SQL: Recursive calculation of tree like hierarchical structure #eg83

SQL: Recursive calculation of tree like hierarchical structure #eg83

6
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
Just-in-Time Database Access

Just-in-Time Database Access

5
Comments
2 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
Part 6: SQL Injection Series: Case Studies and Lessons Learned

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

9
Comments
4 min read
SQL 101 | Summary of Most Used SQL Syntax for Data Analysis

SQL 101 | Summary of Most Used SQL Syntax for Data Analysis

1
Comments
2 min read
Part 8: SQL Injection Series - Advanced Prevention Techniques and Real-World Applications

Part 8: SQL Injection Series - Advanced Prevention Techniques and Real-World Applications

6
Comments
2 min read
The Justin Beiber database problem!

The Justin Beiber database problem!

2
Comments
1 min read
loading...