stores 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.

AppWizard

July 23, 2026

Active Exploitation Alert: Fake Bahrain Alert App Deploys Advanced Android Surveillance Malware Targeting Gulf Region Users

A cyber-espionage campaign has been identified involving a counterfeit Bahrain Alert Android application designed to surveil individuals in Bahrain and the Gulf region. The app masquerades as an official civil defense tool and employs social engineering tactics to compromise Android devices, extract sensitive data, and maintain remote access. It targets high-value individuals such as activists and journalists, particularly during civil unrest and missile alerts, leveraging trusted government branding to increase infection rates. The malware features a complex, multi-stage architecture with advanced evasion techniques and is distributed through phishing links and malicious websites. It initiates a four-stage infection process, ultimately installing a remote access trojan (RAT) that enables covert surveillance and encrypted communications. The malware can monitor device activity, capture credentials, and intercept communications, while also employing mechanisms to avoid detection and maintain persistence. The campaign primarily targets Bahraini citizens, exploiting fear during crises to encourage app installation. Although there are indications of Russian-speaking developers involved, there is no definitive attribution to a specific nation-state or APT group. Mitigation strategies include monitoring for suspicious app installations, user education on verifying app authenticity, and blocking known malicious domains.

AppWizard

July 22, 2026

Google is this close to bringing third-party app stores to the Play Store

Google is testing new features in the Play Store, including Play Labs, which allows users to experiment with new functionalities. The company is also exploring the integration of third-party app stores, allowing users to install alternative app stores directly from the Play Store, although this feature is not yet available to the general public. Users have reported limited access to these experimental features through adjustments in the latest Play Store version. Additionally, Google has confirmed the rollout of a revamped search experience, featuring a new two-row search bar for longer queries and a prompt labeled “Ask Store” to enhance search capabilities. These updates aim to improve user experience and accessibility in the Play Store.

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.

AppWizard

July 22, 2026

What ‘long tail’ should you expect for your PC game in 2026?

GameDiscoverCo hosted the 'Scrappy Saves The Animals' game jam in collaboration with the Oakland Ballers on Itch.io, with the top game being Scrappy’s Rescue Run, which will be showcased at an upcoming event. GDCO Pro reported on trending unreleased Steam games, with Dear Passengers leading in wishlists, followed by Paper Shredder and Guildrun. An analysis revealed that AI-flagged games achieve around 3,000 sales, which is 55% of the rate of non-AI titles. The Binding Of Isaac Complete Bundle sold nearly 4 million additional units after a 90% off sale during the Steam Summer Sale. A developer was arrested for injecting malware into Steam games, affecting around 8,000 users and stealing approximately 0,000 in cryptocurrency. Roblox announced a UGC-centric Build feature, raising concerns about predatory offers to creators. Xbox Game Pass added titles like Halo: Campaign Evolved and Beast of Reincarnation. Valve updated SteamVR with a more VR-native interface. Epic Games and Google withdrew a lawsuit settlement attempt that could impact Android app stores. GameDiscoverCo Pro introduced automated graph annotations for Steam demo launches. An analysis of games released between July 2023 and July 2025 showed cumulative sales increases over time, with higher-priced titles having better long-term sales. Multiplayer and co-op games are experiencing promising sales trajectories. The GameDiscover Show has returned, discussing trends in game discovery and insights from GDCo’s AI survey.

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.

BetaBeacon

July 19, 2026

Google Play and third-party app stores can now connect; Google announces withdrawal of its appeal against ruling in lawsuit with Epic Games.

Starting July 22, 2026, Google will allow third-party app stores to connect to Google Play, subjecting apps downloaded from these stores to the same conditions and pricing as Google Play.

Winsage

July 18, 2026

Windows 11 Secure Boot certificates have expired, and Microsoft says what to do next

Microsoft held its OEM Secure Boot Office Hours event on July 15, where engineers collaborated with OEM representatives from companies like Acer, Asus, Cisco, Dell, and HP. IT administrators were able to ask live questions about the Secure Boot 2023 rollout. The discussion thread became a detailed technical record, especially following the expiration of the first certificates three weeks prior. Concerns raised by IT admins included BitLocker recovery loops, stuck confidence ratings, and unhelpful Intune error codes. Key facts include: - Devices offline for long periods will still receive the 2023 certificates upon reconnecting to Windows Update. - Devices with existing 2023 certificates in firmware will switch to the new boot manager after the latest Windows patches are installed. - A new script, Detect-SecureBootCertUpdateStatus.ps1, is available in Windows for checking certificate status. - BIOS updates may reset a device’s confidence rating to unrated, which is normal and does not indicate certificate failure. - Admins should edit the AvailableUpdates registry key, not the AvailableUpdatesPolicy, which is managed by Intune and Group Policy. - A licensing bug affecting AvailableUpdatesPolicy on devices upgraded from Pro to Enterprise was resolved by Microsoft in 2026. - BitLocker recovery is not typically linked to the certificate update process but may relate to firmware or PCR issues. - Dell and HP provided guidance on which BIOS versions include the 2023 certificates for their newer models. - Older HP EliteBook 840 G5 units require a manual update package for the new certificates. - Eligible devices can still receive the 2023 certificates in the future, and Surface devices released from 2024 onward come pre-equipped with them. - Microsoft confirmed that devices running 2011 certificates will not lose the ability to receive the 2023 chain. - The Microsoft Corporation KEK CA 2011 and Microsoft UEFI CA 2011 certificates have expired, with the Microsoft Windows Production PCA 2011 set to expire on October 19, 2026.

AppWizard

July 17, 2026

Google and Epic Abandon Settlement, Clearing the Way for Rival Android App Stores

Google and Epic Games have withdrawn their joint motion to modify a court injunction that requires Google to support third-party app stores within the Google Play ecosystem. A permanent injunction issued in October 2024 mandates Google to facilitate alternative app stores on Android devices, with support set to begin on July 22. Google plans to implement a ,000 annual access fee for these alternative marketplaces, while apps downloaded through these stores will still use the Google Play system for transactions. The agreement between Google and Epic includes provisions for reduced fees and alternative payment methods, separate from the injunction. The legal situation regarding third-party app stores does not directly affect Apple, but it may influence Apple's ongoing legal challenges with Epic Games and regulatory developments. Apple is currently appealing a ruling that requires it to allow link-outs and alternative payment options, with oral arguments expected in late 2026 or early 2027.

AppWizard

July 17, 2026

Epic & Google Withdraw Settlement: Other Stores Coming to Android

Epic Games and Google have withdrawn their proposed settlement regarding app distribution on Android, which included a program for registered app stores. This decision allows Google to permit third-party app stores on its platform. The legal dispute began when Epic accused Google of monopolizing Android app distribution. Despite multiple victories for Epic, the companies attempted a settlement that included new billing options and reduced fees, but concerns about sideloading apps led to its abandonment. Google plans to invite other app stores starting July 22 in the United States.