production Archives

Tech Optimizer

July 23, 2026

Optimizing PostgreSQL on Azure directly in Visual Studio Code

Poor database performance can lead to missed SLAs, delayed releases, customer dissatisfaction, and lost revenue. Microsoft has enhanced PostgreSQL on Azure, transforming it into a fully managed platform that meets enterprise demands. Azure Database for PostgreSQL and the new Azure HorizonDB offer significant performance improvements, with HorizonDB being three times faster than self-managed PostgreSQL. The PostgreSQL extension for Visual Studio Code integrates performance management into development workflows, providing tools for managing PostgreSQL throughout its lifecycle. Key features include a server metrics dashboard that displays performance indicators, Azure Advisor recommendations for actionable insights, improved query plan visualization, and AI-assisted query analysis. The extension also enhances schema design and query formulation experiences, ensuring secure and governed interactions with PostgreSQL. Azure HorizonDB is in public preview, designed for AI-native workloads. These advancements aim to reduce friction, enhance clarity, and enable faster actions for enterprise teams managing PostgreSQL at scale.

AppWizard

July 23, 2026

Take Note, PlayStation: Xbox Brings Classic Games To PC

The gaming industry is experiencing a surge in demand for artificial intelligence, leading to increased hardware prices, such as the new Steam Machine exceeding ,000 despite its specifications. PlayStation plans to stop producing physical media for the PS5 by 2028, causing backlash from fans. Xbox has laid off 1,600 employees and anticipates more layoffs by the end of the 2027 fiscal year. Xbox has introduced backwards compatibility for PC, allowing access to four classic titles: Blinx: The Time Sweeper, Fuzion Frenzy, Crimson Skies: High Road to Revenge, and Conker: Live and Reloaded, with enhanced features like customizable upscaling and resolution options. There is a growing interest in preserving gaming history, particularly for classic titles from the PS1, PS2, and PS3 eras, as the industry shifts towards an all-digital future.

Tech Optimizer

July 23, 2026

Simplify AI agent orchestration with Lakebase Postgres

The auditing process has traditionally been labor-intensive, requiring extensive document reviews. CLA (CliftonLarsonAllen LLP) partnered with the Databricks Forward Deployed Engineering team to develop a document processing application that reduces extraction time from hours to minutes while maintaining quality. The application is built on the Databricks platform, utilizing technologies like Lakebase Postgres, Databricks Apps, Lakeflow Jobs, MLflow, and Unity Catalog Volumes. The application addresses challenges in document parsing, including unpredictable per-task latency, rate-limit-aware throttling, workload prioritization, cost attribution per task, and real-time progress visibility. It eliminates the need for multiple specialized systems by integrating components such as a web application for user interaction, Lakebase for state management, an orchestrator for task management, and AI agents for document processing. The task queue is supported by two Postgres tables in Lakebase, tracking task status and execution attempts. Concurrency safety is ensured through a locking mechanism, and crash recovery is facilitated by lease-based locking. The orchestrator implements rate-limit-aware throttling and idempotent webhook callbacks to manage task processing effectively. An operator dashboard provides real-time metrics on task status, agent performance, and workload costs, with live updates through Postgres LISTEN/NOTIFY events. Cost attribution is managed at the application level, allowing for detailed monitoring of expenditures. Lakebase enhances the orchestration process with features like autoscaling compute, OAuth-rotated authentication, Unity Catalog integration, and support for branching and snapshots.

AppWizard

July 22, 2026

Microsoft brings OG Xbox games to PC with backward compatibility

Microsoft is expanding its backward compatibility initiative to include original Xbox console games on PC, starting with four titles: Blinx: The Time Sweeper, Conker: Live and Reloaded, Crimson Skies, and Fusion Frenzy. These games are available for purchase and included in Xbox Game Pass, with licenses transferring seamlessly for those who already own them digitally on Xbox. New graphics settings have been introduced, allowing up to 4x resolution upscaling, VSync support, fullscreen and windowed modes, anisotropic filtering, and enhanced anti-aliasing. This launch is part of a larger effort to preserve Xbox's gaming legacy and integrate achievements into classic titles. The move comes amid discussions of game preservation in the industry, particularly with Sony ending physical disc production by 2028. The upcoming Xbox console, codenamed Project Helix, will support both Xbox and PC games, indicating a trend towards cross-platform integration.

Tech Optimizer

July 22, 2026

Migrating mission-critical payments at Nubank to Amazon Aurora PostgreSQL

Nubank, a digital banking platform with approximately 135 million customers in Brazil, Mexico, and Colombia, faced challenges with its payment infrastructure due to inefficiencies in managing 7.5 TB of self-hosted PostgreSQL databases. Queries took over 13 minutes to execute, and replication lags exceeded four minutes during peak times. To address these issues, Nubank evaluated database solutions based on developer productivity, operational efficiency, performance reliability, and scalability. They selected Amazon Aurora PostgreSQL-Compatible Edition for its compatibility, performance improvements, and automated features. The migration to Aurora was facilitated by AWS Database Migration Service (AWS DMS), which minimized downtime and allowed for efficient transition. Post-migration, query performance improved significantly, with some queries executing up to 1,900 times faster, and overall end-to-end service latency decreased, enhancing customer experience. The migration resulted in a 25 percent cost reduction and ensured compliance with regulatory requirements.

AppWizard

July 22, 2026

Coming to XBOX Game Pass: Halo: Campaign Evolved, Beast of Reincarnation, and More

- Available Today: - The Planet Crafter (July 21) - Terraform a planet in solo or co-op mode. - Coming Soon: - Shift at Midnight (July 22) - Online co-op detective horror game. - Hell is Us (July 23) - Explore a nation in civil war with supernatural elements. - Halo: Campaign Evolved (July 28) - Reimagined Halo: Combat Evolved with HD visuals and new content. - Mistfall Hunter (July 30) - Dark fantasy ARPG with combat challenges. - Corsair Cove (July 31) - City-builder focused on pirate life. - Heretic + Hexen (August 4) - Re-release of classic spell-casting shooters. - Beast of Reincarnation (August 4) - Action RPG set in post-apocalyptic Japan. - In Case You Missed It: - Buckshot Roulette (July 8) - Tabletop horror game. - Denshattack! (July 15) - Fast-paced adventure in a Japanese dystopia. - In-Game Benefits: - Zenless Zone Zero (July 29) - New game featuring a first-gen Void Hunter. - Leaving July 31: - Titles departing from Game Pass include Back to the Dawn, Celeste, Crusader Kings 3, Mount & Blade 2: Bannerlord, My Friendly Neighborhood, Rain World, Sniper Elite Resistance, and Whiskerwood.

AppWizard

July 22, 2026

The Witcher 3’s expansion reveal is scheduled for next month

CD Projekt Red announced a new expansion for The Witcher 3 titled Songs of the Past, set to release in 2027. The expansion is co-developed with Fool's Theory and aims to provide a substantial experience similar to the Blood and Wine expansion. A reveal will take place on August 25 during Gamescom's Opening Night Live event. CDPR co-CEO Michał Nowakowski mentioned that the expansion will cater to various playstyles and that the decision to delay the release from 2026 to 2027 allows for a more polished product. Additionally, there will be 80 new beard styles for Geralt.

Tech Optimizer

July 22, 2026

Google boosts AlloyDB vector search with HNSW preview

Google has introduced a preview of its columnar engine-accelerated HNSW feature for AlloyDB, enhancing vector search throughput by up to four times for users of the pgvector extension in PostgreSQL. This improvement is aimed at approximate nearest neighbor searches using HNSW across large datasets. AlloyDB utilizes a columnar engine that allows HNSW indexes to reside in memory, improving throughput and recall metrics. In benchmark tests on the GloVe 100 Angular dataset, queries per second increased by approximately 4.2x to 4.9x, with recall improving from about 0.78 to over 0.94 at a throughput of around 350 queries per second. The columnar engine's design bypasses traditional PostgreSQL buffer management bottlenecks, enhancing efficiency during graph traversal. The memory architecture is distinct from basic caching techniques, and the feature requires no changes to application code. Users must enable the columnar engine and index caching flags to utilize this feature. Benchmarks were conducted on an AlloyDB C4A machine with 16 virtual CPUs.

Tech Optimizer

July 21, 2026

I Built My Second ETL Pipeline. This Time, I Started Thinking Like a Data Engineer

The author transitioned from a data analyst role to a data engineer, creating a 12-month self-study roadmap focused on learning by building projects. The first project was a GitHub ETL pipeline, which evolved from a simple Python script to a more complex system using SQLite and GitHub Actions for automation. The author realized that the challenges of data engineering lay in system design and orchestration rather than just writing ETL logic. For the second project, the author built an automated RSS ingestion pipeline to explore engineering decisions in creating a reliable data pipeline. The project emphasized the importance of separating application responsibilities from orchestration tasks, leading to the use of Docker for consistent execution environments and Kestra for orchestration. The author validated each component of the project incrementally: first the Python ETL, then PostgreSQL, followed by Docker, and finally Kestra. This approach ensured that each layer functioned correctly before adding complexity. The final architecture included distinct responsibilities for each component: Python for data processing, PostgreSQL for data storage, Docker for execution, and Kestra for orchestration. The author learned that effective engineering involves considering system reliability, error handling, and observability, shifting the focus from merely writing code to designing entire systems. The experience transformed the author's mindset, emphasizing the importance of incremental building and the separation of execution and orchestration responsibilities.

AppWizard

July 21, 2026

Hasbro takes $56 million hit over multiple game cancellations, but it’s still talking about how Baldur’s Gate 3 is key to its future success

Hasbro reported a million non-cash impairment in its second-quarter financial disclosure due to the cancellation of several anticipated video games originally planned for release in 2028 and beyond. The impairment reflects a decline in asset value rather than a direct financial loss. Two years ago, Hasbro's gaming division, led by Dan Ayoub, had ambitious plans for over a billion in game development. However, challenges have arisen, including issues with a GI Joe game and the cancellation of a Dungeons & Dragons title. CEO Chris Cocks mentioned that the company is reviewing its portfolio, leading to project cancellations and a financial write-down. Hasbro plans to focus on trading card games and role-playing games, leveraging successes like Magic: The Gathering and Baldur's Gate 3, which has been highly acclaimed. The company aims for 2026 to be a peak year for digital investment while planning to reduce overall digital spending by at least 25% annually by 2028 through cost-effective development strategies.