Community Picks·1yOnline SQL Playground for MySQL, PostgreSQL, and SQL Server
RunSQL is an online SQL playground designed for learning, testing, and sharing SQL queries for MySQL, PostgreSQL, and SQL Server. Users can easily create and manipulate database schemas using DBML, collaborate on SQL projects, conduct interviews, and create web-based database documentation without needing local database setup. It provides a shared environment tailored for developers and data analysts.
Architecture Weekly·1yPostgreSQL JSONB - Powerful Storage for Semi-Structured Data
PostgreSQL JSONB offers a powerful method for storing and querying semi-structured data. JSONB stores data in a binary format, allowing for efficient indexing and querying without the need for repeated parsing. The article discusses the internal structure of JSONB, performance benefits, and various indexing strategies like GIN and B-Tree to optimize JSONB queries. It also covers practical applications, such as using JSONB for managing heterogeneous data models and ensuring query performance. Although JSONB provides flexibility, it's essential to understand its performance implications for large datasets.
YouTube·1yFastAPI Python Tutorial: Build an Analytics API from Scratch
Learn how to build an analytics API service using FastAPI, Python, and TimescaleDB. The tutorial covers creating a microservice to ingest and store time series data, deploying the application using Docker, and ensuring it runs in a containerized cloud environment with Railway. The step-by-step guide helps in setting up the development environment, writing code for the API, working with Postgres optimized for time series, and finally deploying the setup for production.
Lobsters·1ypgdogdev/pgdog: Horizontal scaling for PostgreSQL with automatic sharding.
PgDog is a fast, secure transaction pooler and logical replication manager for PostgreSQL that supports automatic sharding. Written in Rust, it can manage hundreds of databases and thousands of connections, offering features like cross-shard queries, health checks, and failover. It includes tools for Docker and Helm deployment, PostgreSQL client compatibility, and detailed configuration files. PgDog is open source and licensed under AGPL v3.
Lobsters·1yJust Throw It Into Postgres
Exploring the flexibility of Postgres for handling various types of data, including unstructured and unexpected formats. Examples include using Postgres for compiling Java code references, storing Chinese character outlines, and logging room temperature data. Highlights the advantages of leveranging relational databases without strict adherence to traditional schemas.
Awesome Go·1yFinly — Building a Real-Time Notification System in Go with PostgreSQL
Learn to implement real-time notifications in Go using PostgreSQL's PGNotify for efficient Pub/Sub messaging. The setup ensures instant updates and toast alerts in Finly's notification center. The guide covers database triggers, PGX for listening to notifications, exposing subscriptions via GraphQL, and frontend integration with Apollo Client for seamless user updates.
Neon·1yMake Yourself at Home with Neon Local
Neon Local simplifies the creation of ephemeral environments for database branches using Docker. It provides a local interface to Neon cloud databases, automatically handling the creation and deletion of database branches. By leveraging instant branching, it offers a fast and safe approach to spinning up isolated environments that mimic production, improving reliability and reproducibility for development and testing. Various configurations, including Docker compose and Docker run, allow integration with Postgres clients and customization options.
Supabase·1yDeclarative Schemas for Simpler Database Management
Declarative schemas simplify the management and maintenance of complex database schemas by allowing the definition of database structures in clear, centralized, and version-controlled .sql files. This approach reduces redundancy, ensures consistent schema updates across environments, and facilitates concise code reviews. Unlike traditional migrations, declarative schemas provide a single pane of glass to see the entire database schema, making it easier to handle complex and frequently updated schemas. By using tools like `migra` for schema diff, developers can significantly speed up their development process.
PostgreSQL·1yPostgreSQL: pgmoneta 0.16
pgmoneta version 0.16.0 is now available, offering new features such as incremental backup support for PostgreSQL 17+, advanced filtering for pgmoneta-walinfo, Prometheus/HTTPS support, Docker/podman images, and various enhancements and bug fixes. pgmoneta provides comprehensive backup and restore solutions, including full and incremental backups, compression options, AES encryption, symlink support, WAL shipping, hot standby, remote management, offline mode, TLS v1.2+ support, daemon mode, and user vault.
System Design Newsletter·1yHow Figma Scaled to 4M Users—Without Fancy Databases 🔥
Discover how Figma scaled its Postgres database to accommodate 4 million users by employing techniques such as vertical scaling, database replication, federation, connection pooling, vertical partitioning, and horizontal partitioning. This approach enabled them to manage large traffic volumes, optimize performance, and ensure data consistency without switching to more complex database solutions.
Hostman·1yHow to Deploy PostgreSQL on Kubernetes: A Step-by-Step Guide
Deploying PostgreSQL on Kubernetes involves using StatefulSets and PersistentVolumes for scalable and cloud-native database setups. The guide provides options for setting up using Helm or manual YAML, managing secrets securely, and ensuring high availability. It also covers basic networking, backup strategies, and offers troubleshooting tips.