Data Infrastructure for AI Systems: Object Storage, Databases, Search & AI Data Architecture
Production AI systems depend on far more than models and prompts.
PostgreSQL
Self-Hosting Immich: Private Photo Cloud
Your photos on self-hosted AI-powered backup
Immich is a revolutionary open-source, self-hosted photo and video management solution that gives you complete control over your memories. With features rivaling Google Photos - including AI-powered facial recognition, smart search, and automatic mobile backup - all while keeping your data private and secure on your own server.
PostgreSQL Cheatsheet: A Developer’s Quick Reference
Quick reference to postgresql
A quick reference for day‑to‑day PostgreSQL work: connections, SQL syntax, psql meta-commands, performance, JSON, window functions, and more.
SQL Cheatsheet - most useful SQL commands
Essential SQL commands and operations
Here’s a concise SQL cheatsheet covering the most essential commands and operations: