data access Archives

AppWizard

March 16, 2026

Advanced Protection Mode in Android 17 prevents apps from misusing Accessibility Services

Android 17 has introduced Advanced Protection Mode (AAPM) to enhance user security by preventing non-accessibility applications from using the Accessibility API, which has been exploited by malware. AAPM allows only verified accessibility tools to utilize the API and implements stricter security settings, including blocking installations from unknown sources, limiting USB data access, and mandating Google Play Protect scans. Applications must declare themselves as accessibility tools with the attribute isAccessibilityTool="true" to use the Accessibility Services API. Additionally, Android 17 features a new contacts picker that allows applications to request access to specific contact fields instead of the entire address book, enhancing user privacy.

AppWizard

March 16, 2026

Android 17 Blocks Non-Accessibility Apps from Accessibility API to Prevent Malware Abuse

Google is piloting a security enhancement in its Android Advanced Protection Mode (AAPM) that restricts certain applications from using the accessibility services API. This update is part of Android 17 Beta 2. AAPM, introduced in Android 16, enhances device security by blocking app installations from unknown sources, restricting USB data signaling, and mandating Google Play Protect scanning. Developers can integrate with AAPM through the AdvancedProtectionManager API to adapt their apps based on the security mode's status. The new restriction prevents non-accessibility apps from accessing the accessibility services API, allowing only verified accessibility tools like screen readers and voice-based input tools. Non-accessibility apps, including antivirus software and password managers, will have their access revoked when AAPM is activated, and users cannot grant permissions to these apps unless AAPM is disabled. Additionally, Android 17 introduces a new contacts picker feature that allows developers to specify which fields to access from a user's contact list, providing more granular control over data access.

Winsage

March 11, 2026

New Windows-native NVMe driver benchmarks reveal transformative performance gains, up to 64.89% — lightning-fast random reads and breakthrough CPU efficiency

Microsoft's native NVMe driver, initially released for Windows Server 2025, is now available for Windows 11, enhancing SSD performance. Users can achieve performance gains through registry tweaks. Benchmark tests showed significant improvements in random read bandwidth and input/output operations per second (IOPS). In a test with AMD EPYC 9754 processors and Solidigm P5316 SSDs, the following results were observed: - 4K Random Read: Non-Native Driver 6.1 GiB/s, Native Driver 10.058 GiB/s (+64.89%) - 64K Random Read: Non-Native Driver 74.291 GiB/s, Native Driver 91.165 GiB/s (+22.71%) - 64K Sequential Read: Non-Native Driver 35.596 GiB/s, Native Driver 35.623 GiB/s (+0.08%) - 128K Sequential Read: Non-Native Driver 86.791 GiB/s, Native Driver 92.562 GiB/s (+6.65%) - 64K Sequential Write: Non-Native Driver 44.67 GiB/s, Native Driver 50.087 GiB/s (+12.13%) - 128K Sequential Write: Non-Native Driver 50.477 GiB/s, Native Driver 50.079 GiB/s (-0.79%) Random read latency decreased significantly, with 4K and 64K read times dropping by 38.46% and 13.39%, respectively. However, 64K sequential write latency increased by 39.85%, while 128K sequential write latency rose by 12.43%. The NVMe driver also showed favorable CPU usage results during sequential read and write operations. It is not enabled by default in Windows 11, requiring users to make registry changes to activate it.

Tech Optimizer

March 11, 2026

Netflix Automates RDS PostgreSQL to Aurora PostgreSQL Migration Across 400 Production Clusters

Netflix has developed an internal automation platform to migrate Amazon RDS for PostgreSQL databases to Amazon Aurora PostgreSQL, reducing operational risks and downtime for nearly 400 production clusters. The platform allows service teams to perform migrations through a self-service workflow while ensuring processes like replication validation and rollback safeguards are maintained. Database access is managed through a platform-managed layer using Envoy, which standardizes mutual TLS and abstracts database endpoints, enhancing security and efficiency. The migration process starts with creating an Aurora PostgreSQL cluster as a read replica of the source RDS instance, initialized from a storage snapshot and continuously replaying write-ahead log (WAL) records. Validation checks are performed to ensure the replica can handle peak write throughput before cutover. For change data capture workloads, the system coordinates the state of replication slots and pauses CDC consumers to prevent excessive WAL retention. The Enablement Applications team at Netflix successfully migrated databases for device certification and partner billing workflows, addressing issues like elevated replication lag due to inactive logical replication slots. As replication lag decreases, the system enters a controlled quiescence phase, adjusts security rules, and reboots the source RDS instance. Once all transactions are processed and the Aurora replica is ready, it is promoted to a writable cluster, and traffic is rerouted. Rollback capabilities are prioritized, allowing redirection back to the original RDS instance if validation checks fail or anomalies are detected post-promotion. This setup enables seamless restoration without redeployment, and CDC consumers can resume from recorded slot positions if needed.

AppWizard

March 6, 2026

Building realistic Minecraft worlds with Open Data on AWS: How Arnis uses elevation datasets at scale

Arnis is an open-source tool that transforms real-world locations into Minecraft experiences using geospatial data from Amazon Web Services (AWS). It recently migrated to Terrain Tiles, a global elevation dataset, which has reduced data retrieval costs and improved accessibility for nearly 300,000 users. Users can select geographic regions and customize parameters to generate locations in Minecraft, with the conversion process occurring locally on their machines. The integration of elevation data was a key feature, achieved through a processing pipeline designed by contributors after consulting GIS specialists. This pipeline allows accurate terrain rendering globally, even in areas with significant elevation variations. The transition to Terrain Tiles eliminated the need for a commercial provider, simplifying the codebase and removing account-bound authentication for data access. Previously, users made around 2,000,000 elevation tile requests over three months, incurring substantial costs. Now, users benefit from free access to the Terrain Tiles dataset, enhancing the elevation feature's reliability and accessibility. The Arnis processing pipeline operates on the client’s machine without backend services or API keys, involving steps such as calculating tile coordinates, fetching terrain tiles from AWS, decoding them, applying smoothing, and voxelizing the map data. A local cache is used to minimize redundant reads, and the system defaults to flat terrain if the endpoint is temporarily unavailable. Future developments include a public Minecraft server for exploring generated worlds without downloading the application, automatic region selection for optimized data retrieval, expanded landform detection for better representations, and a terrain-only mode for custom city planning and adventure map creation.

AppWizard

February 26, 2026

How to Add Android Apps to Your Car’s Factory Screen

Modern vehicles often have high-resolution touchscreens but are limited in app selection and customization. The Ottocast OttoAI Box P3 Pro offers an independent operating system, utilizing Android 13, allowing direct app installations without relying on a smartphone. It features a Snapdragon 6225 processor, 8GB of RAM, and 128GB of storage, enabling quick boot times and efficient multitasking. The P3 Pro supports alternative navigation apps, streaming services like Netflix and YouTube while parked, and multitasking with split-screen support. It includes built-in AI voice support and can be set up easily with factory wired Apple CarPlay or Android Auto. Connectivity options include CloudSIM, a physical SIM card, phone hotspot, and local Wi-Fi. Switching between CarPlay or Android Auto and the P3 Android OS is simple. The device is priced at 9, with a special offer of a 10% discount available.

Winsage

February 20, 2026

Copilot Arrives In Windows 11 File Explorer And Taskbar

Microsoft is integrating its AI assistant, Copilot, into the Windows 11 ecosystem, allowing users to access AI capabilities directly through familiar interfaces. Users can invoke Copilot agents by pressing the @ key in the taskbar search, enabling tasks like document summarization and research initiation without switching contexts. A "Researcher" agent can handle inquiries and provide comprehensive reports, enhancing productivity for knowledge workers. In File Explorer, a new Copilot icon allows users to summarize documents and extract insights without opening applications, improving efficiency with common file formats like Word and PDF. These features are available to Windows 11 users with Microsoft 365 Work or School accounts who have been granted access by their organizations. Copilot+ PC owners will benefit from additional functionalities such as voice transcription and contextual screenshotting, enabled by the Neural Processing Unit (NPU) in newer AI PC designs. Microsoft aims to position Copilot where work naturally occurs, but adoption remains low, with only 3.3% of users subscribing to premium tiers. The integration raises governance and privacy considerations for IT leaders, as it must comply with existing frameworks like Microsoft Purview. Best practices suggest piloting Copilot features with select users and implementing data loss prevention rules. Overall, the integration of Copilot into Windows 11 is designed to save users time and enhance productivity while maintaining organizational security.

Tech Optimizer

February 12, 2026

pg_lake comes to Snowflake Postgres: What it means for open standards

The pg_lake extension has been integrated into Snowflake Postgres, enabling users to utilize PostgreSQL as a data lakehouse with support for Apache Iceberg tables. This integration allows for unified analytical and transactional workloads, facilitating direct access to PostgreSQL within the Snowflake environment. Snowflake has also expanded its Snowflake Horizon Catalog to enhance data discovery and governance, now managing data accessed through external query systems like Apache Spark. New features include integration with Microsoft One Lake for secure, bi-directional data access between Snowflake and Microsoft Fabric. pg_lake includes functionalities for version management, data type and format conversions, and caching to optimize performance. Snowflake's capabilities for managing Iceberg tables have been enhanced, allowing external query engines to read and write to these tables while extending access controls for data governance. Additionally, Snowflake's open data sharing features now include Delta Lake and Iceberg tables, enabling users to access data without duplication or movement across clouds. The expansion of open standards supports interoperability, simplifying developers' work with various tools and formats.

Tech Optimizer

February 12, 2026

Build a custom solution to migrate SQL Server HierarchyID to PostgreSQL LTREE with AWS DMS

Data migration from SQL Server to Amazon RDS for PostgreSQL or Amazon Aurora PostgreSQL-Compatible Edition often requires adjustments to the database schema or SQL commands. AWS provides DMS Schema Conversion to aid in converting existing database schemas and AWS Database Migration Service (AWS DMS) to assist in data migration, featuring enhanced security and minimized downtime. SQL Server uses the HierarchyID data type for managing hierarchical data, while PostgreSQL employs the LTREE extension for similar purposes. The migration process involves preparing both the source SQL Server and target PostgreSQL environments, creating tables, installing the LTREE extension, and converting schemas using AWS DMS Schema Conversion. The migration steps include creating sample tables in SQL Server with HierarchyID columns, enabling change data capture (CDC), creating the LTREE extension in PostgreSQL, and preparing the target table structure. AWS DMS endpoints are created for both source and target databases, followed by the creation and execution of an AWS DMS migration task. Post-migration, the original HierarchyID column is replaced with the LTREE column, and the IDENTITY column behavior is reverted to its original state. The migration process is verified by inserting rows in PostgreSQL and ensuring they are in the correct LTREE format. Common functions from SQL Server's HierarchyID are mapped to their PostgreSQL LTREE equivalents, facilitating the transition between the two systems.

Tech Optimizer

January 28, 2026

How to Unlock Google Chrome’s Built-in Malware Scanner

- Regularly update Chrome to include security patches. - Avoid installing unknown extensions and only download from reputable sources. - Review permissions carefully before granting access to extensions or websites. - Conduct periodic safety checks to identify potential threats. - Stay alert to unusual browser behavior, such as loading unfamiliar pages or displaying excessive ads.