consistency Archives

Tech Optimizer

July 24, 2026

How we pushed CDC into Postgres, and turned replication into clockwork

Making data from transactional databases accessible to analytical databases is essential in modern data architecture, but it faces challenges such as fragile tooling, high costs, and complex operations. Snowflake has developed a Postgres service that addresses these issues by reimagining Postgres replication. Postgres is a strong operational database, but its change data capture (CDC) capabilities need improvement. Many data pipelines are fragile due to complexities in managing continuous data flow, schema changes, snapshots, and failures. To enhance user experience with Snowflake Postgres, a complete reinvention of the replication process was necessary. A new feature called data mirroring is in public preview, allowing resilient data replication into Snowflake with low cost, minimal lag, and transactional consistency. This feature directly pushes changes from Postgres into Apache Iceberg™ tables in transactional batches, which are then automatically applied to Snowflake tables without extra infrastructure. Change data capture records changes from a transactional database for replay on another system, primarily using logical decoding in Postgres. This method decodes WAL records into logical operations, but the client bears the responsibility for subsequent steps like backfilling, managing schema changes, and handling failures. Built-in logical replication in Postgres only addresses some complexities. A limitation of logical decoding is that the external system does not recognize the state of Postgres, making it difficult to detect schema changes or correlate snapshots with changes. The solution is to push changes from Postgres into a data lake, specifically into Iceberg tables using compressed Parquet format, with object stores like Amazon S3 as the destination. The mirroring process uses a new Postgres extension called snowflake_cdc, which continuously pushes batches of changes into per-table change logs and a meta log. This extension understands the Postgres environment, coordinating schema changes and complex transactions while ensuring alignment between snapshots and changes.

Winsage

July 23, 2026

Microsoft accepts defeat on the Windows 11 Copilot key with a “Do nothing” switch, but PCs still ship with it

Windows 11 is testing a new feature that allows users to reassign the Copilot key to do nothing. The Copilot key has been present on newer Windows PCs since its introduction in 2024, and Microsoft considers a PC an AI PC only if it includes this key. Users can remap the Copilot key to preferred applications or restore it to its original function as the Right Ctrl key. An additional option, “Do nothing,” will make the Copilot key inactive. This feature is currently available in Windows Insider preview builds, with a public rollout expected soon. Microsoft acknowledged that the Copilot key has created challenges for users who rely on the Right Ctrl key or Context menu key, and it plans to allow customization of the Copilot key through Settings. Initially, only two remapping options were planned, but the “Do nothing” option was added in response to user feedback. Microsoft cautioned that remapping the Copilot key to the Right Ctrl key may cause inconsistencies with certain keyboard shortcuts.

AppWizard

July 23, 2026

Smoother scrolling: How we halved scroll jank in Chrome on Android

In Chrome's multi-process pipeline, delays can disrupt visual fluidity, leading to missed deadlines and stuttering scrolls. The complexity of the input-rendering pipeline makes it challenging to identify the causes of scroll jank. Comprehensive instrumentation has been implemented to analyze the pipeline from input generation to GPU buffer presentation. Perfetto trace events are used to visually analyze each stage during scroll updates to identify irregularities contributing to scroll jank, with the goal of enhancing performance and reliability for a seamless browsing experience.

Winsage

July 22, 2026

Microsoft is Modernizing Decades-Old Properties Window in File Explorer

Microsoft is updating the File Properties window in Windows 11's File Explorer to use the WinUI 3 framework, aiming to improve design consistency across the operating system. This change addresses longstanding user interface inconsistencies caused by a mix of legacy frameworks, including elements from Windows 7. The transition to a desktop-only WinUI 3 framework is intended to reduce application latency and enhance the user experience. All desktop elements are expected to operate on the WinUI 3 framework for the first time since Windows 11's launch in late 2021. Additionally, the classic Win32 Control Panel is being gradually integrated into the modern Settings app, with careful consideration to avoid disruptions.

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.

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 20, 2026

Minecraft 26.3 Snapshot 4 is a big update hiding under the hood

Minecraft's Snapshot 26.3 update transitions the Java Edition from GLFW to SDL3, improving window management, input handling, and platform support. It uses SDL scancodes for key positions and SDL keycodes for text shortcuts, enhancing control responsiveness. The Raw Input mouse option has been removed, and players can switch between Borderless and Exclusive Fullscreen modes without restarting the game. However, Exclusive fullscreen mode may cause crashes on Windows and is not supported on macOS. Players in Spectator mode can now interact with Nether portals, End portals, and End gateways. The debug overlay has been improved, and the creative inventory has been reorganized. Armadillos will no longer roll up while submerged. New item components for cooking and brewing fuels have been introduced, allowing data pack creators to define parameters like burn duration and cooking speed. Sign behavior has been adjusted to prevent click events by default. There are extensive format changes to world generation, loot tables, predicates, number providers, and advancement triggers, updated to Data Pack version 111.0 and Resource Pack version 92.0. Snapshot 4 addresses various bugs, but players are advised to back up their worlds before using the snapshot to avoid potential damage to saved games.

Winsage

July 20, 2026

Windows 11 trades noisy Bing ads for the clean Search experience it always needed

Microsoft has announced a comprehensive upgrade to the Search feature in Windows 11, eliminating ads and promotional materials to enhance user experience. The July 2026 Patch Tuesday update introduces new features, including Point-in-time Restore and addresses 570 vulnerabilities, with AI aiding in vulnerability discovery. The rollout of the KB5101650 update faced challenges for Dell users, leading Microsoft to pause it for affected devices. Additionally, Microsoft is testing a slightly larger search box to improve design consistency.

Winsage

July 19, 2026

Windows 11’s big 2026 update is almost here, and these 10 things you need to know before upgrading could save you time and frustration

Microsoft is set to launch the 2026 Update for Windows 11, known as version 26H2, later this year. This will be the fifth feature update for the operating system. The upgrade from version 25H2 to 26H2 will utilize an Enablement Package (eKB), allowing for a transition similar to a standard monthly cumulative update without requiring a full reinstallation. Users can also upgrade from Windows 10 using an ISO file or Microsoft installation media, which ensures files, applications, and settings remain intact. Upgrading to version 26H2 extends the support lifecycle of devices by an additional year, with Microsoft providing 24 months of support for Home and Pro editions and 36 months for Enterprise and Education editions. Version 25H2 will continue to receive support until October 2027, and users are advised to plan upgrades before this support ends. Windows 11 version 26H2 has the same hardware requirements as version 25H2, which include a 1GHz processor with at least two cores, 4GB of RAM, 64GB of storage, UEFI firmware with Secure Boot, TPM version 2.0, DirectX 12 compatible graphics, and a high-definition display. The rollout of the update will be gradual, following a Controlled Feature Rollout (CFR) strategy, meaning not all devices will receive the update immediately.

TrendTechie

July 18, 2026

Что такое троттлинг и как понять, что провайдер намеренно замедляет ваш трафик

Throttling is the intentional limitation of speed for specific types of traffic, services, protocols, devices, or users. It can occur due to various reasons, such as exceeding data caps, prioritization of certain services, load management during peak hours, or technical policies in networks. Users may experience speed drops that are selective to specific traffic types, indicating potential throttling, while universal slowdowns suggest network overload or outages. Speed tests measure connectivity to specific servers and may not reflect actual download speeds across different paths. Signs of potential throttling include isolated speed drops, consistent slowdowns at specific times, and discrepancies between speed tests and real-world performance. Initial checks should rule out home network issues, and practical diagnostics can help identify throttling by comparing speeds across different servers, types of downloads, and times of day. If throttling is confirmed and support does not resolve the issue, exploring alternative ISPs may be necessary.