Skip to content

DEV Community

select * from SQL

Posts on tips and tricks, using and learning about SQL for database development and analysis.

👋 Sign in for the ability to sort posts by relevant, latest, or top.

Jan 13

SQL vs MongoDB(noSQL)! How to decide between databases

#sql #nosql #mongodb #mongoose

4 min read

Jan 13

SQL - Basics

#programming #sql #database #week1

2 min read

Jan 12

SQL vs NoSQL: The Ultimate Interview Guide to Choosing the Right Database (Simple Checklist Included)

#interview #sql #nosql #programming

4 min read

Faizan Firdousi

Jan 11

Database Design Best Practice: Store Categorical Data as IDs, Not Strings

#database #backend #sql #architecture

2 min read

Marko

Jan 10

Stop Re-running Everything: A Local Incremental Pipeline in DuckDB

#python #dataengineering #sql #duckdb

4 min read

Feb 1

SQL Stored Procedures: From Hard‑Coded Logic to Reusable SQL

#database #postgres #sql #beginners

3 min read

fosres

Jan 11

Week 4 SQL Injection Audit Challenge

#security #python #tutorial #sql

27 min read

Rodrino Adolfo Kupessala

Jan 11

SQL INJECTION

#beginners #sql #security #webdev

1 min read

Jan 4

XML External Entity (XXE) Injection: A Complete Guide for Developers

#xmlexternalentity #sql #xxe #programming

18 min read

Rebooter.S

Jan 20

SQL Optimization Unlocked: Achieve 80% Calculation Reduction with CROSS APPLY

#sql #mysql

5 min read

Blackwatch

Jan 4

QUICK SQL REVISION

#sql #database #webdev #programming

14 min read

Amar Abaz

Jan 4

Track Blocking and Deadlocks in MSSQL with my custom script

#sqlserver #sql #database #deadlock

4 min read

Dan Shalev

Jan 5

Text2SQL on xxxx's of tables?

#sql #falkordb #opensource

1 min read

Jan 4

Wait, what? PK is not needed for HABTM?

#database #rails #ruby #sql

2 min read

Juan Rueda

Jan 6

Simple vs Complex: When to Level Up Your Solutions

#architecture #complexity #engineering #sql

5 min read

👋 Sign in for the ability to sort posts by relevant, latest, or top.