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.
Write-Audit-Publish: Never Promote a Bad Table Again

Write-Audit-Publish: Never Promote a Bad Table Again

Comments
2 min read
Your PostgreSQL Index Probably Doesn't Need Every Row

Your PostgreSQL Index Probably Doesn't Need Every Row

Comments 1
1 min read
My win rate was 33%, 57% and 67% at the same time

My win rate was 33%, 57% and 67% at the same time

Comments 1
6 min read
Technical Guide: Automating SQL CREATE TABLE and INSERT Generation from Excel

Technical Guide: Automating SQL CREATE TABLE and INSERT Generation from Excel

Comments
6 min read
Design a notification system: the system design interview walkthrough

Design a notification system: the system design interview walkthrough

Comments 1
15 min read
Design search autocomplete (typeahead): the system design interview walkthrough

Design search autocomplete (typeahead): the system design interview walkthrough

Comments 1
16 min read
Your Postgres ID columns will run out of numbers. Here's a 10-second check (and the trap that hides it)

Your Postgres ID columns will run out of numbers. Here's a 10-second check (and the trap that hides it)

Comments
4 min read
Blind SQL Injection (Oracle): Intruder ile Administrator Şifresini Karakter Karakter Çıkarmak

Blind SQL Injection (Oracle): Intruder ile Administrator Şifresini Karakter Karakter Çıkarmak

Comments
4 min read
Easy Model v2.1.0: Less Eloquent Boilerplate, More Control

Easy Model v2.1.0: Less Eloquent Boilerplate, More Control

Comments
2 min read
Session Budgets or Driver Caps: A Debate for Agent SQL Exploration

Session Budgets or Driver Caps: A Debate for Agent SQL Exploration

Comments
7 min read
Design a Rate Limiter: the system design interview walkthrough

Design a Rate Limiter: the system design interview walkthrough

Comments 1
14 min read
The refund arrived after the payout, so the fix was two nullable columns and no code

The refund arrived after the payout, so the fix was two nullable columns and no code

Comments
4 min read
DMS Database Design

DMS Database Design

Comments
2 min read
SQL: Find the Top 2 Orders for Every Customer Using Window Functions

SQL: Find the Top 2 Orders for Every Customer Using Window Functions

Comments
3 min read
How to Easily Convert JSON and Excel Files to SQL Insert Statements

How to Easily Convert JSON and Excel Files to SQL Insert Statements

Comments
1 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.