NewApp Digest
search bot

installation

PostgreSQL 18 on Amazon Aurora and Amazon RDS: Performance enhancements
Tech Optimizer
June 20, 2026

PostgreSQL 18 on Amazon Aurora and Amazon RDS: Performance enhancements

PostgreSQL 18 addresses common performance challenges for users, including managing query performance across composite indexes, diagnosing memory spills in materialized Common Table Expressions (CTEs), and upgrading major versions without plan regressions. Key enhancements include skip scan optimization for multicolumn indexes, improved EXPLAIN functionality, and optimizer statistics that persist through major version upgrades. Skip scan optimization allows PostgreSQL to efficiently utilize multicolumn B-tree indexes even when leading columns are not specified in the WHERE clause, significantly improving query performance. The EXPLAIN command has been enhanced to include buffer statistics by default, providing deeper insights into query execution and resource usage. PostgreSQL 18 also introduces visibility into the storage of materialized nodes in query plans, indicating whether intermediate results were stored in memory or spilled to disk. A new metric, Index Searches, has been added to EXPLAIN ANALYZE output, indicating how many times the database traversed the index tree during query execution. Additionally, Self-Join Elimination (SJE) automatically detects and removes unnecessary inner joins of a table to itself, optimizing query performance. The autovacuum mechanism has been improved with the introduction of autovacuum_vacuum_max_threshold, which caps the number of dead tuples that can accumulate before autovacuum triggers a VACUUM, addressing issues with large tables. The vacuum_truncate parameter provides a server-wide control point to disable VACUUM’s file truncation behavior, reducing locking issues on busy systems. PostgreSQL 18 also separates the allocation of autovacuum worker slots from their usage, allowing for dynamic adjustments to autovacuum_max_workers without requiring a server restart. Finally, new columns in pg_stat_all_tables track cumulative time spent on maintenance operations, providing better insights into maintenance overhead for each table.
Выпуск qBittorrent 5.2.2
TrendTechie
June 20, 2026

Выпуск qBittorrent 5.2.2

On May 15, 2026, qBittorrent version 5.2.2 was released. It is an open-source torrent client developed using the Qt toolkit, with source code available on GitHub under the GPLv2+ license. The software supports Linux, Windows, and macOS. The project started with version 4.0 in November 2017, followed by versions 5.0 in September 2024 and 5.1 in April 2025. The 5.2.2 update focuses on bug fixes and stability improvements, including D-Bus utilization for file display, header mismatch correction in Safari, magnet link sending issue fix, correct string identifier implementation for RSS Downloader, 64-bit binary installation on ARM64 systems, prevention of SSRF attacks, and mitigation of proxy interference in multi-threaded processing. Key features include an integrated search engine, RSS feed subscription, support for BEP extensions, remote management, sequential downloading, advanced torrent settings, bandwidth scheduling, IP filtering, torrent creation interface, and UPnP/NAT-PMP support.
Microsoft Details Windows Clipper Malware Campaign Using USB LNK Worm and Tor-Based C2
Winsage
June 19, 2026

Microsoft Details Windows Clipper Malware Campaign Using USB LNK Worm and Tor-Based C2

Microsoft has identified a Windows-based cryptocurrency clipper campaign that has been active since February 2026. This campaign uses clipboard-intercepting malware with self-spreading capabilities and operates through the Tor network. The clipper malware employs Windows Script Host and ActiveX to launch a Tor proxy and connect to a hidden command-and-control server. It focuses on stealing clipboard data, particularly cryptocurrency wallet addresses, and can exfiltrate screenshots. The malware is distributed via malicious Windows Shortcut (LNK) files on USB drives, which activate a worm that checks for existing infections and fetches the payload from a remote server. The clipper monitors the clipboard every 500 milliseconds for sensitive information and can replace copied wallet addresses with those controlled by attackers. Microsoft recommends behavioral detections, disabling AutoRun for removable media, blocking LNK execution from drives, and monitoring clipboard-related activities as mitigations against this threat.
silver Android smartphone
AppWizard
June 19, 2026

Google sets launch date for review of Android apps distributed outside the Play Store

Google's upcoming Android app verification system will begin on September 30, 2026, restricting the installation of apps from unverified developers outside the Google Play ecosystem. Certified Android device users will be unable to install apps from developers lacking Google verification, which requires identity authentication through the Android Developer Console. A list of participating app stores includes Google Play, Samsung Galaxy Store, Xiaomi GetApps, HONOR App Market, OPPO App Market, vivo V-Appstore, and Palm Store by Transsion. A new system component, com.google.android.verifier, will be integrated into certified devices running Android 8 or later. In August, Google will introduce a feature called Advanced Flow, allowing users to install unverified apps through a complex process. A Limited Distribution mode for independent developers will enable app distribution to a maximum of 20 devices without registration fees or document verification. The regulations will initially be implemented in Brazil, Indonesia, Singapore, and Thailand, with plans for a global rollout by 2027.
4 security upgrades in Android 17 you didn't know about, but will be glad to have
AppWizard
June 19, 2026

4 security upgrades in Android 17 you didn’t know about, but will be glad to have

Google's Android 17 update is being deployed to Pixel devices, introducing new features such as multitasking bubbles, expanded dark theme controls, and a revamped screen recording interface. Key user preferences from a poll indicate that 32% favor multitasking app bubbles, while other features received varying levels of support. The update includes App Memory Limits to prevent excessive RAM usage by apps, enhancing performance. It also restricts apps from scanning local networks without explicit permission, improving user privacy. Additionally, Android 17 tightens restrictions on dynamic code loading to strengthen malware protection and implements Certificate Transparency protections by default for secure HTTPS connections. Overall, these changes aim to enhance performance, security, and user experience.
This app can translate your favorite games into any language, but there's a big catch
BetaBeacon
June 19, 2026

This app can translate your favorite games into any language, but there’s a big catch

- Google Play Protect blocks the app's installation due to sensitive permissions, such as recording the screen and utilizing the "display over other apps" permission. - The developer used generative AI to assist with the app's development, but claims to heavily review the code and make/validate all architectural decisions to ensure security.
PlayTranslate brings realtime game translation to Android
BetaBeacon
June 19, 2026

PlayTranslate brings realtime game translation to Android

PlayTranslate is an open-source Android app that provides realtime overlay translation for games, supporting 23 in-game languages translated into 59 different languages. Users may need to temporarily pause Google Play Protect to install the app due to screen-record and display-over-apps permissions. It also offers offline translations, text-to-speech functionality, flashcard features, and multi-screen translation options.
After years of forgetting Windows shortcuts, I finally found a method that makes them stick
Winsage
June 19, 2026

After years of forgetting Windows shortcuts, I finally found a method that makes them stick

On Windows 11, keyboard shortcuts enhance productivity, but many users are only aware of a few common ones like "Windows key + E" for File Explorer and "Ctrl + C" and "Ctrl + V" for copying and pasting. To help users discover more shortcuts, the Microsoft team behind PowerToys has released a revamped Shortcut Guide in version 0.100. This guide can be accessed through the GitHub page or the Microsoft Store and activated via PowerToys settings. Users can customize the guide's color theme, position, and exclude specific applications. The guide can be opened using the "Windows key + Shift + /" shortcut and provides organized shortcuts for Windows 11 and PowerToys. It also includes context-aware functionality, showing relevant shortcuts based on the active application. The development team has provided guidelines for developers to integrate their apps into the Shortcut Guide.
Search