Extension Archives

Winsage

June 6, 2025

The Microsoft Store is now faster, more personalized… and injected with AI

Microsoft has updated the Microsoft Store app, introducing a personalized home page and improved performance, with start times reportedly twice as fast as six months ago. Users can now install individual game components, and there is a new feature for launching Windows search to quickly find and install apps or games from the Store. Additionally, app suggestions for opening file extensions are being tested for Windows Insiders in the US and China. Copilot AI features have been added, allowing users in the US to ask questions while browsing product pages. Other enhancements include better search capabilities and improved labeling and discovery options.

Tech Optimizer

June 5, 2025

UltraAV Delivers Continuous Innovation in Antivirus Protection

UltraAV, an antivirus solution from Point Wild, has introduced significant enhancements to improve threat protection and user experience. Key updates include: - Advanced AV Engine upgrades for faster scans and improved detection rates across versions 12.0, 12.3, 12.4, and 12.7.2. - The ability to scan external USB devices and schedule recurring scans, introduced in version 12.8. - Expanded privacy and identity protections for premium users, including identity theft monitoring and real-time fraud alerts. - Seamless integration with Total Cleaner for premium subscribers, enhancing app reliability (versions 12.7 and 12.7.1). - Self-protection features to safeguard UltraAV binaries from malware (version 12.8). - URL filtering to block harmful URLs for Chrome users (version 12.4). UltraAV is built on over 20 years of research and development, integrating real-time threat intelligence and AI-driven detection. Point Wild, the parent company, provides cybersecurity solutions to over 25 million users globally.

Tech Optimizer

June 4, 2025

Migrate Google Cloud SQL for PostgreSQL to Amazon RDS and Amazon Aurora using pglogical

PostgreSQL is a popular open-source relational database used by enterprise developers and startups, enabling rapid prototyping and supporting mission-critical applications. Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL-Compatible Edition facilitate easy setup, operation, and scaling of PostgreSQL deployments in the AWS Cloud, automating administrative tasks like software installation, storage management, and backups. The pglogical extension, compatible with PostgreSQL versions 9.4 and higher, allows for asynchronous replication and is supported on RDS for PostgreSQL and Aurora PostgreSQL from version 12. It uses a publisher/subscriber model for logical streaming replication. To migrate a PostgreSQL database from Google Cloud SQL to RDS for PostgreSQL or Aurora PostgreSQL, users must configure the primary database in Cloud SQL, create a PostgreSQL user with replication privileges, enable logical replication parameters, and create the pglogical extension. The RDS instance also requires a special user for replication, enabling logical replication parameters and creating the pglogical extension. Known limitations of pglogical include the inability to replicate primary key changes directly, the need to manually transfer extensions, and the lack of support for materialized views and large objects. Workarounds involve using surrogate keys for primary keys, manually creating extensions, and converting large objects to bytea columns or storing them in Amazon S3. DDL statements are not automatically replicated, but can be queued using the pglogical.replicate_ddl_command function.

Tech Optimizer

June 4, 2025

I put McAfee and Norton head-to-head in an antivirus showdown, and the results were quite surprising

McAfee and Norton are two leading antivirus providers known for their robust online safety solutions. Both offer essential security features such as real-time threat detection, firewall protection, identity theft protection, VPN services, password management, and parental controls, but they differ in implementation. McAfee uses advanced machine learning for real-time threat detection but has a higher rate of false positives and shows room for improvement against ransomware and phishing. Norton excels in malware detection and has a strong performance against ransomware, blocking 95% of phishing links in tests. McAfee's firewall monitors incoming threats and protects connected devices, while Norton’s firewall prevents untrusted applications from accessing the internet with extensive configuration options. In identity theft protection, McAfee offers comprehensive features with live agent support, whereas Norton partners with LifeLock for enhanced services, including credit monitoring and up to one million dollars in compensation for identity theft losses. McAfee provides unlimited VPN access with basic functionality, while Norton’s VPN includes advanced features like split tunneling and a kill switch. Both include password managers, but McAfee's lacks some functionalities, whereas Norton’s is user-friendly and supports data import from other managers. For parental controls, McAfee allows website blocking and app restrictions, while Norton offers detailed content filtering and monitoring of online activities. In system performance, both have received high marks, with McAfee showing a superior impact score in tests. User experience varies, with McAfee being more accessible for non-technical users and Norton catering to more experienced individuals. Recent testing indicates both effectively blocked nearly all threats, but McAfee had more false positives. Both brands received high ratings from SE Labs for protection and accuracy. The choice between them depends on individual needs, with McAfee being user-friendly and Norton offering advanced features and enhanced identity protection.

Tech Optimizer

June 3, 2025

Malwarebytes Premium Security review

Malwarebytes, founded in 2004 by Marcin Kleczynski, is an independent cybersecurity company that provides effective malware protection globally. The Malwarebytes Premium Security suite includes antivirus, phishing and identity protection, and an unlimited VPN powered by Mullvad. Pricing for the one-year license for a single device is .99, while a five-device license costs .99, and a two-year plan is priced at .98. The Premium Security Ultimate plan offers full identity protection and credit monitoring for .99 for the first year, with renewal at 9.99. A limited free version is available that detects and removes existing threats but lacks real-time protection. The app features a straightforward design with a clear dashboard, prioritizing user experience. Malwarebytes focuses on efficient scanning of commonly infected areas, completing test scans in 13 minutes. However, it does not automatically scan removable drives and lacks a warning system for password-protected files. Independent lab testing is infrequent, but Malwarebytes has received an AVLab 'Product of the Year' award and demonstrated strong performance in MRG Effitas assessments. In practical tests, Malwarebytes effectively detected known malware but struggled with behavioral detection against custom ransomware. It includes anti-phishing features, initially blocking 16% of phishing sites, which improved to 62% with the BrowserGuard extension. The unlimited VPN offers encryption and privacy but has limitations in unblocking streaming services. The identity protection feature scans for breaches associated with user email addresses and Social Security Numbers for U.S. users.

Tech Optimizer

June 1, 2025

Supercharging vector search performance and relevance with pgvector 0.8.0 on Amazon Aurora PostgreSQL

The Amazon Aurora PostgreSQL-Compatible Edition has integrated support for pgvector 0.8.0, enhancing vector search capabilities significantly. This version achieves up to 9x faster query processing and delivers 100x more relevant search results compared to previous iterations. Key improvements in pgvector 0.8.0 include: - Up to 5.7x improvement in query performance for specific patterns. - Introduction of the iterative_scan feature, enhancing recall for filter queries requiring approximate nearest neighbor (ANN) index searches. - Improved cost estimation for more efficient query planning, allowing the selection of traditional indexes for complex filtered searches. - Flexible performance tuning with two modes for iterative_scan: relaxed_order and strict_order. Previous versions faced challenges with overfiltering, where combining vector similarity search with traditional SQL filters resulted in fewer results than expected. The HNSW indexing algorithm accelerates vector similarity searches by creating a multi-layered graph structure for efficient navigation. Iterative index scans in pgvector 0.8.0 improve query reliability and performance by applying filters during the scanning process, reducing false negatives and enhancing performance. The configuration options for iterative scanning include off, strict_order, and relaxed_order, with relaxed_order providing the best balance between performance and accuracy. In performance tests, pgvector 0.8.0 demonstrated substantial improvements across various query patterns, with significant enhancements in result completeness and recall. The database can now efficiently handle enterprise-scale applications, such as e-commerce and recommendation systems, with high performance and result quality even as product catalogs expand. Best practices for deploying pgvector 0.8.0 include using HNSW with recommended parameters, creating additional indexes on commonly filtered metadata columns, and tuning query parameters based on specific use cases. Operational best practices involve using Graviton4-based instances for optimal performance, monitoring and tuning slow vector queries, and considering partitioning for very large tables.

BetaBeacon

May 29, 2025

Microsoft Copilot for Gaming AI Game Assistant Enters Beta on Android, iOS

Microsoft has introduced the Copilot for Gaming beta, an AI companion designed to assist players in their video game endeavors. The tool allows players to ask for assistance, inquire about play history and achievements, receive game recommendations, and catch up on games they haven't played in a while. The beta is currently available on Android and Apple devices in specific regions, with plans to expand to Windows PCs in the future.

Winsage

May 28, 2025

Three ways to run Windows apps on a Linux box

If you're transitioning to Linux and need to run Windows applications, you have several options, including dual-booting, using a virtual machine (VM), or employing a compatibility layer like WINE. For virtualization, VirtualBox is a popular open-source choice, while VMware is another option that has been free since late 2024. Both require a Windows ISO, which can be obtained for free from Microsoft. VirtualBox suggests allocating 2GB of RAM and one processor core, but 8GB of RAM and two cores are recommended for better performance. Running a VM requires significant resources, and a valid Windows license is necessary for the guest OS. Dual-booting allows both Windows and Linux to run natively, providing full hardware access and optimal performance. WINE translates Windows application calls into Linux commands and is included in most Linux distributions. Its effectiveness varies by application. Bottles is a user-friendly wrapper around WINE that simplifies installation. For enhanced compatibility, CodeWeavers CrossOver is a premium alternative to WINE, with a free evaluation version available. For gaming, Lutris and Valve’s Proton are tools that facilitate running Windows games on Linux.

AppWizard

May 22, 2025

How to Export Your Saved Articles Before Pocket Shuts Down for Good

Pocket will cease operations on July 8, with users required to export their saved items by October 8. The app is no longer available for download, and sign-ups and renewals have been disabled. Users can export their data by linking their account to a valid email and clicking the Export HTML file button, with the process taking up to 7 days. The export link will expire after 48 hours. Monthly renewals for Pocket Premium have been stopped, and annual subscribers will receive a prorated refund. All accounts and data will be permanently deleted after October 8.

Winsage

May 22, 2025

Screw the Windows Search Bar, and Use Command Palette Instead

Mac users utilize Spotlight for searching applications, files, calculations, and web browsing, while Windows users have the Search Bar, which is less versatile. Command Palette is a new keyboard launcher for Windows, replacing PowerToys Run, allowing users to execute commands, search the web, find files, and create custom bookmarks with global keyboard shortcuts. Command Palette is part of PowerToys, which can be downloaded from GitHub, the Microsoft Store, or via the Windows Package Manager. After installing PowerToys version 0.9 or higher, users can enable Command Palette in the settings and customize its keyboard shortcut. Users can search for files by selecting the File search option and typing the desired term, and they can switch between open windows and execute commands in the Terminal. The hidden package manager WinGet allows users to install applications via Command Palette without opening the Terminal. Users can also enhance Command Palette with third-party extensions, which are currently limited but may expand in the future.