NewApp Digest
search bot

data processing

Microsoft Makes Rare Move to Optimize 8GB Memory as Windows Bloat Becomes Biggest Bottleneck for AI PCs
Winsage
August 24, 2026

Microsoft Makes Rare Move to Optimize 8GB Memory as Windows Bloat Becomes Biggest Bottleneck for AI PCs

Microsoft is re-optimizing Windows memory performance for devices with 8GB or more RAM, moving away from its previous approach that treated 8GB as entry-level. The company is recognizing that hardware growth can no longer mask systemic inefficiencies, particularly with the rise of AI requiring substantial resources. Windows has accumulated background services and frameworks without a cohesive resource management strategy, leading to inefficiencies. Compatibility with legacy systems has complicated resource management, while commercial pressures have contributed to system bloat. The reliance on web technologies, particularly WebView2, has further increased memory consumption. Microsoft aims for Windows to achieve integration similar to macOS but faces challenges due to its diverse ecosystem. The demand for memory driven by AI has made system-level optimization a pressing issue, prompting Microsoft to adjust its guidance on memory requirements. The company must balance modernization with maintaining compatibility with older applications and drivers as it adapts to new computing demands.
Manic Android Malware Exfiltrates Data From Offline Phones via Nearby Infected Devices
AppWizard
August 23, 2026

Manic Android Malware Exfiltrates Data From Offline Phones via Nearby Infected Devices

A new Android malware threat, codenamed Manic, poses significant risks to Ukrainian banks, government services, and messaging applications, with a reach extending to Russian and European financial institutions, global fintech platforms, cryptocurrency services, and military communication channels. Manic combines Android banking malware and mobile spyware, targeting sensitive applications and enabling comprehensive device takeover. It features a novel Wi-Fi mesh technique for data relay through compromised devices and utilizes phishing sites and dropper apps. The malware originated in February 2026, with initial development leading to its first deployment by late May. It monitors 169 package IDs related to banks, payment services, and messaging applications, primarily affecting Ukrainian targets but also impacting applications in Russia and Europe. Manic can infiltrate commercial and military messaging apps, track locations, monitor notifications, and collect files. It exploits Android's accessibility services to capture sensitive data and employs a store-and-forward relay mechanism for data exfiltration through nearby compromised devices. Google has stated that no apps containing this malware are found on Google Play, and Android users are protected by Google Play Protect.
Electric Joins Databricks to Bring WASM Postgres to AI Agent Sandboxes, Expanding Databricks Postgres from the Lakehouse to the Edge
Tech Optimizer
August 19, 2026

Electric Joins Databricks to Bring WASM Postgres to AI Agent Sandboxes, Expanding Databricks Postgres from the Lakehouse to the Edge

Databricks has integrated the Electric team to enhance its capabilities by incorporating WASM Postgres into AI agent sandboxes. Electric has developed PGlite, which provides each agent with a lightweight Postgres instance for low-latency access to local context, facilitating real-time data processing. Their real-time sync engine maintains synchronization of agents' distributed states with a central Lakebase, allowing effective collaboration among agents. Both Electric and Lakebase utilize Postgres, with Lakebase offering it at a production scale and PGlite introducing WASM Postgres into the agent's environment. This integration allows for collaborative applications, execution of Postgres within the agent sandbox, and ensures synchronization among agents while centralizing control in Lakebase Postgres.
Windows 11 could soon get significantly faster with Microsoft's new performance tools
Winsage
August 6, 2026

Windows 11 could soon get significantly faster with Microsoft’s new performance tools

Microsoft has introduced a preview of the Event Tracing for Windows Model Context Protocol (ETW MCP) to enhance Windows performance analysis. This server integrates artificial intelligence to streamline the analysis of Windows Event Tracing (ETW) logs. The ETW MCP allows developers to use tools like GitHub Copilot to examine Event Trace Log (ETL) files, answer queries about the logs, and identify performance issues without manual data sifting. The MCP provides structured, read-only access to processed trace information, enabling developers to query insights such as CPU usage and execution paths. Current features of the ETW MCP include trace processing, querying, multi-trace comparison, symbol-aware analysis, critical path analysis, and regions of interest. The ETW MCP is designed for headless environments and automation, while a forthcoming WPA MCP will provide similar AI-assisted analysis within a graphical interface. The ETW MCP preview is available as the Microsoft.Windows.EventTracing.MCP NuGet package, and Microsoft is seeking developer feedback for further enhancements.
Developers: Beware of Ad Libraries that Betray Your Users’ Location
AppWizard
August 5, 2026

Developers: Beware of Ad Libraries that Betray Your Users’ Location

Advertising companies provide software development kits (SDKs) for mobile app monetization, which often automatically transmit users' location data to ad systems and location data brokers, raising privacy concerns. Many developers and users may be unaware of this data sharing. When developers allow SDKs to collect location data, it poses risks beyond targeted ads, including potential misuse by agencies like ICE and global surveillance. Location data brokers harvest precise movements of individuals, often without their consent, through mobile applications. Some apps directly collaborate with data brokers, while others leak data through advertising SDKs during real-time bidding (RTB) auctions. An incident in 2025 revealed that many apps unknowingly contributed to a location data broker's database. Developers must understand their SDKs' location-sharing practices to mitigate risks. Advertising SDKs can collect location data automatically once users grant permission, without specific permissions for the SDKs themselves. Precise location data can be collected when apps have location permissions, leading to potential privacy violations. Several SDKs have been identified as collecting location data by default, increasing the risk of unintentional data leaks. The Electronic Frontier Foundation (EFF) found that four advertising SDKs collect users' location data by default when location permissions are granted. InMobi encourages location sharing for higher revenue, while BidMachine updated its documentation after EFF's inquiry, confirming precise location data collection. Verve's SDK also collects location data by default but presents a cautious narrative in its Play Store guidance. Huawei's SDK recommends obtaining location permissions to enhance revenue, with default location sharing occurring if permissions are granted. Location data can be shared without users' knowledge or meaningful consent, complicating informed consent issues. The focus on four SDKs does not imply that others adequately protect location data, as many have faced criticism for similar practices. Studies indicate that SDKs often encourage increased data collection through design and documentation, leading to minimal control for developers over data transmission. The EFF's analysis highlights that advertising SDKs incentivize location data sharing through default settings and unclear documentation. Developers should assess third-party SDKs and disable unnecessary data collection. Regulators must hold developers accountable for unlawful data sharing, while legislators should enact laws to protect location privacy and address online behavioral advertising, which drives data tracking.
I Built My Second ETL Pipeline. This Time, I Started Thinking Like a Data Engineer
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.
What Is Serverless PostgreSQL?
Tech Optimizer
July 12, 2026

What Is Serverless PostgreSQL?

Serverless PostgreSQL is a fully managed cloud database model that separates compute and storage, allowing them to scale independently and automatically based on demand. It eliminates the need for manual infrastructure provisioning and capacity planning, charging only for active usage. Unlike traditional PostgreSQL setups, which require continuous resource allocation and manual scaling, serverless PostgreSQL provisions resources on demand and can scale down to zero during idle periods. Serverless PostgreSQL integrates with serverless compute platforms, enabling analytical queries to access the same data within a unified architecture. Key differences between traditional and serverless PostgreSQL include manual versus automatic provisioning and scaling, fixed versus usage-based billing, and high versus reduced operational overhead. Lakebase architecture is an emerging model that combines transactional databases with lakehouse foundations, allowing operational and analytical workloads to coexist on a single platform. This architecture minimizes data duplication and simplifies access, enhancing data management and analysis. Serverless PostgreSQL operates on a cloud-native architecture that enhances efficiency by allowing compute and storage to scale autonomously. It features scale-to-zero behavior, where compute resources are suspended when inactive and reactivated upon new queries. Major providers include Databricks Lakebase, Amazon Aurora Serverless v2, and Neon, each offering varying capabilities and integrations. Pricing for serverless PostgreSQL typically includes charges for compute resources, storage, and data transfer, with costs fluctuating based on workload activity. Cold start latency is a performance consideration, as reactivating compute resources can introduce delays. Strategies to mitigate this include keeping resources partially active or selecting providers with minimal cold start impacts. Serverless PostgreSQL is well-suited for OLTP workloads, while lakebase architecture is better for AI development, variable workloads, and environments requiring rapid iteration. Setting up serverless PostgreSQL involves choosing a provider, creating a database instance, and configuring access settings. It can also be used alongside serverless compute platforms for analytics, further extending its capabilities.
Search