PostgreSQL Connection Pool Tuning Guide for Go Production Systems

·1 views

The author details practical PostgreSQL connection pool configurations for Go applications using pgxpool. They recommend calculating MaxConns as (2 × CPU cores) + 4 per API instance to prevent database overload. Key settings include low MinConns values, MaxConnLifetime of one hour, and regular HealthCheckPeriod intervals to manage stale connections. The guidance emphasizes sizing the pool from the database's overall connection budget divided by client instances.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Veilus desktop app built with Rust and Tauri for browser profile management

Veilus is a desktop application that manages multiple browser profiles, each with unique fingerprints and proxies. The app's interface and core logic are built using Tauri 2 and Rust, leveraging the operating system's native webview. It runs a separately downloaded, patched version of Chromium as its browser engine for each profile. The developers chose Rust for its memory safety and concurrency features, which help secure sensitive profile data. The Tauri framework allows web technologies for the interface while keeping core functionality in Rust.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

TrailScout AI app suggests Toronto outdoor spots based on user's mood

TrailScout AI is a new app designed to help users find outdoor locations in the Toronto area. It translates a user's descriptive request, like seeking a peaceful walk, into a tailored list of places using semantic search technology. The tool provides filters for time, difficulty, and distance, and offers explanations for its suggestions based on a pre-authored catalogue. It was created as a project for the Hacktoberfest 2026 hackathon and is currently a working prototype available on GitHub.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Kolkata developers create shade-first walking map for tropical city heat

A team has developed Chhaya, a navigation tool designed for Kolkata's intense tropical climate. The open-source application calculates real-time building shadows using solar positioning and urban mapping. It routes pedestrians through shaded paths instead of prioritizing only the shortest distance. The platform aims to reduce heat exposure for walkers, offering features like group hiking coordination and voice-guided directions.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Ariane 5 maiden flight failed due to unchecked software conversion from Ariane 4.

Europe's Ariane 5 rocket self-destructed 40 seconds after its inaugural launch on June 4, 1996. An inquiry board found the failure originated in the inertial system's software, which was reused from the Ariane 4 rocket. A specific data value, related to horizontal velocity, overflowed during a conversion to a 16-bit integer. Engineers had left this conversion unprotected based on assumptions valid for Ariane 4's flight profile. However, Ariane 5's faster acceleration caused the value to exceed its limits, triggering a fatal error.

0 comments Read more at DEV Community