Skip to content

Haki Benita personal blog

Some SQL Tricks of an Application DBA

hakibenita.com published 2020-07-27

Non-trivial tips for database development

Read on hakibenita.com → Discuss on HN (68) Archived copy

Points: 327
HN comments: 68
Submissions: 1
Cited by: 0 commenters

Databases & Data Software Engineering 2020

On Hacker News

Submitted	Title on HN	Points	Comments
Jul 29, 2020	Some SQL Tricks of an Application DBA by samokhvalov	327	68

More from Haki Benita

All 11 posts →

Lesser-known Postgres features

2021702 points180 comments Databases & Data details

Practical SQL for Data Analysis

2021602 points191 comments Databases & Data details

Simple Anomaly Detection Using Plain SQL

2021512 points47 comments Databases & Data details

Unconventional PostgreSQL Optimizations

2026431 points69 comments Databases & Data details

An unexpected find that freed 20GB of unused index space in PostgreSQL

2021375 points140 comments Databases & Data details

Fast Way to Load Data into PostgreSQL Using Python

2019246 points29 comments Databases & Data details

Related posts from the same era

Hosting SQLite databases on GitHub Pages or any static file hoster

phiresky20211,812 points314 commentscited by 26 details

Personal and social information of 1.2B people discovered in data leak

Data Viper Blog20191,439 points419 comments details

AWS announces forks of Elasticsearch and Kibana

AWS Blog20211,314 points935 comments details

CRDTs are the future

Joseph Gentle20201,181 points357 commentscited by 12 details

Things I wished more developers knew about databases

Jaana Dogan20201,011 points445 comments details

SQLite is not a toy database

Anton Zhiyanov2021986 points484 comments details