9 docs tagged with "database"

A Cost-Effective & Scalable Approach

The Timeline of a Backend Dev Who Grew Up in SQL

Learn how to deploy PostgreSQL on Amazon RDS and connect it to Go applications. This guide covers creating an RDS PostgreSQL instance, configuring security groups, connecting with Go using database/sql, and best practices for performance, security, and scalability.

Coming from an MS SQL (BI/DE) background, I instinctively default to...

An Example of Composability Through Shell Scripts

Quick Reference Guide

Discover various SQL tricks to enhance query efficiency, including using '1=1' in WHERE clauses and techniques for identifying duplicates.

What It Actually Means in Practice

Explains how fsync underpins the 'D' in ACID, why databases rely on it for WAL persistence, and the latency vs. safety trade-offs when tuning durability settings.