filter Archives

Tech Optimizer

April 8, 2026

PostgreSQL logical replication: How to replicate only the data that you need

Many organizations using PostgreSQL face challenges in replicating data across different logical databases while controlling shared information. PostgreSQL 15 introduces native logical replication with column-level and row-level filtering within publications, allowing precise control over data transfer between PostgreSQL databases. Logical replication operates on a publish-subscribe model, where the source database logs changes to the Write-Ahead Log (WAL) and applies publication filters to transmit only the relevant data to the target database. Two filtering modes are available: column-level filtering allows users to specify which columns to replicate, while row-level filtering uses WHERE clauses to determine which rows to include. Both filtering modes can be combined in a single publication. The SQL syntax for creating publications and subscriptions is consistent across various PostgreSQL environments, with specific configurations required for enabling logical replication. Use cases for logical replication include multi-tenant SaaS data isolation, regional data distribution for ecommerce, PCI DSS compliance in financial services, development and testing environments, and retail inventory management. Prerequisites for implementing logical replication include using PostgreSQL 15 or later, ensuring network connectivity, having a user with replication privileges, enabling logical replication on the source instance, and monitoring WAL retention. Logical replication has limitations, such as the need for a replica identity for UPDATE and DELETE operations, the non-replication of DDL changes and sequences, and potential performance overhead during initial synchronization and ongoing replication. After testing, it is advisable to clean up by removing replication resources to prevent unnecessary costs.

AppWizard

April 6, 2026

Play Store now lets you search Android app reviews, ditches ‘this device model’ filter

Google is updating the Play Store by introducing a keyword search feature for app reviews, allowing users to search for specific terms within reviews. This feature aims to improve the user experience by helping individuals identify common issues or experiences. However, the update also removes the “device model” filter, which previously allowed users to filter reviews based on their specific device model. While the “latest version” filter has been moved to a more prominent position, the removal of the device-specific filter may hinder users seeking tailored insights related to their hardware. These changes have been observed in the latest updates but have not been officially announced by Google.

AppWizard

April 5, 2026

Review of ‘DoNotNotify,’ a free Android app that filters and blocks unwanted smartphone notifications.

DoNotNotify is an Android app that allows users to manage their notification settings with a high degree of customization. Key features include: - Real-time notification blocking using Android's NotificationListenerService. - Creation of deny and allow lists for specific notifications. - Support for simple partial matching and regular expression patterns to filter notifications. - Scheduling rules to be active during specific time frames. - Over 40 pre-configured rules for popular applications. - Automatic addition of relevant rules when compatible apps are installed. - Customizable notification retention and review of received alerts. - Tracking of blocked notifications through a block history feature. - Ability to import and export rules as JSON files. - Offline operation without data collection. To install the app, users can download it from the Google Play Store, enable notification access, and manage rules through the app's interface. Users can create new rules based on their notification history and customize settings, although advanced filtering may require experimentation.

AppWizard

March 26, 2026

4 Android Auto apps that make EV range anxiety a thing of the past

Owning a Hyundai Ioniq 5 electric vehicle has provided insights into EV charging, particularly with a Level 2 charger installed at home. Key Android Auto applications help alleviate charging anxiety during road trips. Finding public fast-charging stations can be challenging, requiring more planning than traditional gas vehicles. PlugShare is a useful app for locating reliable public EV chargers, providing a comprehensive list of charging stations, user reviews, and average charging speeds. In the Greater Toronto Area, many EV chargers are often out of service, making PlugShare's features valuable. Waze offers navigation with EV charger information, but its updates may lag behind PlugShare. A Better Route Planner (ABRP) helps plan road trips by tailoring recommendations based on specific EV models and factors affecting battery life, though it requires a subscription. FLO EV Charging is the preferred charging network in the Greater Toronto Area, allowing convenient payments through the app and filtering options for chargers.

AppWizard

March 20, 2026

Google Just Made Four Big Upgrades to Android Gaming on Your Windows PC

Google has introduced enhancements to the Google Play gaming experience on Windows PCs, focusing on game discovery and purchasing processes while expanding the availability of paid titles. Key updates include: - An expanded game library with more paid, premium games optimized for PC. - A new PC section in the Play Store Games tab on mobile devices to identify cross-platform compatible titles. - A single purchase option for games that allows access on both mobile and desktop platforms. - Game trials for selected titles, enabling free play up to a certain limit before prompting purchase, with progress carried over if bought. Upcoming games for PC include Moonlight Peaks, Sledding Game, and Low-Budget Repairs. Users can start playing by visiting the Google Play Games web portal, downloading the software, and syncing their Google account. After installation, a list of available games will be displayed, with options to customize controls and visual settings. However, syncing issues may occur, and Game Trials are still in development.

AppWizard

March 17, 2026

This open-source app turns Microsoft’s GitHub into an app store for your Android phone — and your Windows PC, too

GitHub Store is a new feature on GitHub that enhances discoverability and provides a mobile app store experience. It is designed to be user-friendly, with tabs for trending projects, hot releases, and popular selections. Users can search for mobile-compatible applications and filter results by platform. Installation is straightforward, similar to downloading apps from the Play Store, but does not include automatic updates unless using an additional app called Obtainium. GitHub Store also has a Windows version that showcases desktop-friendly projects. The app offers aesthetic customization options, including font choices and basic theming features.

TrendTechie

March 14, 2026

МТС начал взимать ежедневную плату за использование VPN

MTS, a major mobile operator in Russia, has reclassified virtual private networks (VPNs) as equivalent to torrent services, imposing a daily fee of up to 87 rubles for users who wish to engage in private browsing. Traffic routed through VPNs will no longer be included in standard service packages, leading to additional charges for accessing blocked resources or securing connections. The new tariff structure charges users based on their region and plan, with fees ranging from 80 to 87 rubles per day for a quota of five gigabytes of specialized traffic. Users can block this service to avoid charges, resulting in the complete unavailability of VPN connections. This policy is seen as a response to pressures for new monetization strategies and aligns with government efforts to limit internet circumvention. The potential for other major telecom operators to adopt similar practices could impact net neutrality in Russia.

Winsage

March 3, 2026

New Defender deployment tool streamlines Windows device onboarding with single executable

Microsoft has enhanced its Defender deployment tool for Windows to streamline the onboarding process for device security management. The tool now features improved progress visibility and additional administrative controls, consolidating onboarding files into a single downloadable .exe file for both modern and legacy systems. It supports silent and non-interactive options for large-scale deployments, integrates with Group Policy or Configuration Manager, and allows for custom package identifiers. Administrators can monitor deployment events through the device timeline and advanced hunting tabs for real-time insights. The updated tool is accessible via Settings > Endpoints > Onboarding > Windows and extends support to Linux. Comprehensive onboarding and offboarding guides are available on the Defender portal.

Tech Optimizer

March 2, 2026

Is Bitdefender Antivirus Better Than McAfee? What Consumer Reports Data Says

Consumer Reports evaluates antivirus software, assigning ratings out of five across factors such as protection, ease of use, and data privacy, culminating in a score out of 100. Top contenders include Bitdefender, McAfee, Norton, Avira, and Avast. Bitdefender specializes in anti-malware protection and offers a free version, while McAfee is a full security suite with a subscription model. Bitdefender slightly outperforms McAfee in overall ratings, though both scored equally in six categories during lab tests. McAfee includes features like a firewall and password manager, which Bitdefender lacks. Consumer Reports also assessed Bitdefender's paid security suites, which include more features than the free antivirus version and outperform McAfee Total Protection in functionality. Bitdefender's suites include features like spam filters, parental controls, and banking protection, while Consumer Reports rates Bitdefender higher overall.

Winsage

March 1, 2026

Forget ‘debloat apps.’ Sophia Script gives you real control over Windows 11. Here’s how it works.

Windows 11 users often find system settings dispersed and many functionalities unconfigurable. The Sophia Script for Windows is an open-source PowerShell module designed to debloat and optimize Windows 10 and 11. It requires manual adjustments to select desired optimizations. To use the script, users must download it via PowerShell or from GitHub, extract files, and run the SophiaScriptWrapper.exe to import the Sophia.ps1 file. Users can customize functions and export a custom script before executing it. The script requires specific commands to run and may prompt users for selections during operation. Users can also run individual functions without modifying the entire script. The Sophia Script offers advanced control over privacy settings and system functions, appealing to power users who seek deeper customization beyond standard interfaces.