application Archives

AppWizard

June 21, 2026

Acoustic mapping app uses thousands of networked old Android phones to hunt Shahed drones — crowd-sourced microphone network spots small, low-RCS military targets

A Lithuanian startup has developed an Android application that allows verified users to monitor for the acoustic signatures of Shahed-type drones used by Russia. The app detects these drones and enables users to report their locations, contributing to a collective defense mechanism. It uses an embedded algorithm to isolate drone sounds from environmental noise and relays detection information to a public map, improving situational awareness. The effectiveness of the system increases with more users running the app. Shahed-type drones are favored in military operations due to their cost-effectiveness. Other nations are also developing countermeasures against drone threats, including microwave drone swarm killers and anti-drone laser systems.

Tech Optimizer

June 21, 2026

Is Free Antivirus Safe in 2026? What Most Free Antivirus Apps Don’t Tell You

Some free antivirus software provides legitimate protection against malware, viruses, ransomware, trojans, and suspicious downloads, but not all are equal. Free antivirus programs often generate revenue through premium upgrades, advertising, partner promotions, data collection, or bundled software offers. Users may face upselling tactics, including pop-up notifications and upgrade prompts, which can create confusion between marketing messages and actual security threats. Many free antivirus apps collect data on websites visited, download activity, device information, and security events, raising privacy concerns. Devices often come with built-in antivirus protection, such as Microsoft Defender for Windows and XProtect for Mac, while smartphones have multiple layers of security. In 2026, the biggest cybersecurity risks are phishing attacks, fake websites, investment scams, account takeovers, social engineering attacks, and credential theft, rather than malware. Free antivirus software can create a false sense of security, leading users to believe they are safe from cyber threats. A reputable free antivirus may suffice for users who browse responsibly and maintain good online habits, while paid antivirus may be worth it for additional services like identity theft monitoring and VPNs. Not all free antivirus products offer the same level of protection, so users should choose reputable providers and scrutinize privacy policies.

Tech Optimizer

June 20, 2026

PostgreSQL 18 on Amazon Aurora and Amazon RDS: Security, monitoring, and developer enhancements

PostgreSQL version 18 has deprecated MD5 password authentication in favor of SCRAM-SHA-256, with a new parameter, md5_password_warnings, enabled by default to log deprecation warnings. It has enhanced monitoring capabilities by adding columns to pg_stat_database and pg_stat_statements to track parallel worker activity, with the default max_parallel_workers_per_gather set to 0 in Aurora PostgreSQL. The pg_stat_subscription_stats view now includes new columns for tracking conflict types in logical replication. Optimizer statistics are automatically transferred during upgrades, while uuidv7() generates timestamp-ordered UUIDs. The default streaming option for CREATE SUBSCRIPTION has changed to parallel, and the idle_replication_slot_timeout parameter automatically invalidates inactive replication slots. Enhancements to the COPY command include REJECT_LIMIT for error tolerance and a silent LOG_VERBOSITY level. OLD and NEW aliases have been introduced in RETURNING clauses for various DML commands.

Winsage

June 20, 2026

Users are complaining that the new Windows version of Outlook is running slowly.

Microsoft has introduced two versions of Outlook in Windows 11: Outlook Classic (a Win32 desktop application) and the New Outlook. Users have reported significant performance issues with the New Outlook, noting a lag of approximately 10 seconds for tasks that Outlook Classic performs instantly. The New Outlook operates on WebView2, which involves multiple processes and higher memory consumption, while Outlook Classic runs as a single process. Microsoft is aware of these performance challenges and is testing a new API called 'Delayed Message Timing' to address them. Users find Outlook Classic to be more reliable and faster, particularly for businesses that need efficient notification processing.

AppWizard

June 20, 2026

I tried Samsung Health’s huge redesign for 2026. Here are the 5 biggest hits and misses

Samsung has redesigned its health tracking application, Samsung Health, coinciding with the launch of the Galaxy Watch 9 and One UI 9. The new interface features a vibrant color palette that some users find overwhelming, as colors no longer correspond to specific health metrics. The app includes a new top shortcuts bar for easier navigation to core health aspects like Activity, Sleep, Vitals, Mindfulness, and Nutrition, and allows customization of the dashboard. Graphs have been improved with pinch-to-zoom functionality, but this feature is inconsistently applied across different metrics. The app lacks a comprehensive graph page for comparing multiple metrics and may present unsupported features for users of older devices like the Galaxy Watch 4.

Tech Optimizer

June 20, 2026

Save 75% and Get 3 Free Months on NordVPN + Antivirus (Test Results Included)

NordVPN has introduced a revamped application, new subscription plans, and an antivirus upgrade called Threat Protection Pro, which detects 96% of phishing attempts according to AV-Comparatives. The Complete plan has a price drop of 75%, now costing .49 per month with three complimentary months, allowing users to secure up to ten devices. Key features of NordVPN Complete include ID theft protection, scam call protection, malware protection, a password manager (NordPass), and 1 TB of cloud storage (NordLocker). All plans come with a 30-day money-back guarantee. Threat Protection Pro achieved a 99% score in an independent test by Turtlecute, effectively blocking trackers and detecting malware. Not all plans include antivirus protection; the Basic plan offers VPN access without additional features, while NordVPN Prime provides enhanced ID protection through Coveron.

Tech Optimizer

June 20, 2026

pgEdge Announces ColdFront for PostgreSQL, Seamlessly Uniting AI, Analytical and OLTP Workloads

pgEdge ColdFront is a data tiering solution for PostgreSQL that allows seamless access to hot and cold storage without changing application code, reducing storage costs by up to 90%. The cold tier is writable, enabling operations like UPDATE and DELETE on archived rows using standard SQL commands. ColdFront automatically migrates older data to Apache Iceberg in Parquet format, compatible with S3-compatible object stores, while maintaining full accessibility through a single Postgres table name. It enhances performance with the DuckDB vectorized columnar engine, achieving 10-100x faster analytical performance on cold data. ColdFront simplifies data management by automating the movement of cold data to cost-effective storage, addressing challenges like increased storage costs and operational complexities. It allows for compliance tasks, such as GDPR deletion requests, to be executed with a single SQL statement. Key features include a directly writable cold tier, no application changes required, open-source operation, automated partition lifecycle management, cost-effective operations, and distributed access in multi-master clusters. ColdFront is beneficial for sectors like SaaS, IoT, and regulated industries, and is currently available as a production-grade beta, set to be integrated into pgEdge Cloud in the second half of 2026.

Tech Optimizer

June 20, 2026

How Five PostgreSQL Optimizations Sped Up Our Dashboard

The dashboard operates on a Django monolith with PostgreSQL and is transitioning to ClickHouse for denormalization. The initial p50 metric was 0.7 seconds, but the p95 was 8 seconds, which was reduced to 1 second. Observability tools were established to monitor performance, and slow HTTP requests were identified using OpenTelemetry traces. Optimization techniques included late joining, asynchronous counting, creating a PostgreSQL replica for read operations, and improving full-text search. Denormalization was explored to enhance filtering performance by creating composite indexes. The production stack was upgraded to PostgreSQL 18, which provided incremental performance improvements. The final p95 value achieved was 1 second, below the target of 3 seconds.

Tech Optimizer

June 20, 2026

Neoclouds, sovereign AI and Postgres: The new operating model for regulated enterprises

Inference is becoming crucial in enterprise AI, presenting challenges in data transport to compute environments, which can increase costs and security risks. Enterprises aim to maintain data integrity and avoid multiple copies. Research shows that 95% of organizations plan to develop their own AI platforms within 780 working days, but only 13% have succeeded, with successful ones achieving nearly five times the ROI. Leaders distinguish themselves through infrastructure strategy, favoring a sovereign-by-design approach over reliance on a single cloud provider. Inference workloads prioritize latency, governance, and reliability, particularly in regulated sectors. Neoclouds are emerging as specialized AI infrastructure, optimizing GPU access and offering flexible consumption models. Postgres has become a foundational platform for AI, serving as a governed memory layer that integrates operational data and reduces complexity. Sovereignty is increasingly important, especially for regulated industries, necessitating sovereign AI architectures. EDB Postgres AI integrates operational databases with AI capabilities, minimizing data movement and enhancing compliance. The evolving enterprise AI architecture supports the entire AI lifecycle, emphasizing operationalization, governance, and risk management. Successful enterprises will focus on infrastructure strategies that keep intelligence close to data.

Tech Optimizer

June 19, 2026

Looking Ahead to Postgres 19

Postgres has introduced new functionalities, including UPDATE and DELETE FOR PORTION OF, enhancing temporal use cases. The expansion of RANDOM() temporal functions is attributed to Paul Ramsey and Greg Sabino Mullane. Version 19 includes performance improvements in the planner and executor components, with contributions from Tom Lane. Key enhancements include refinements in anti-joins and semi-joins, constant folding optimizations, incremental sorting with append paths, enhanced aggregate processing prior to joins, improved join selectivity computation, and more comprehensive function statistics. These changes allow Postgres to better understand query structures, reducing unnecessary processing. The visibility of memoization in EXPLAIN has improved, sort performance has benefited from radix sort, and foreign key constraint checks have become faster. The COPY FROM command can now utilize SIMD instructions. Postgres 19 offers a range of improvements for application developers, operators, performance enthusiasts, and those building on Postgres, including enhanced graph queries, refined SQL syntax, improved window functions, better upsert behavior, REPACK CONCURRENTLY, advancements in autovacuum, improved monitoring capabilities, and new hooks. The release is still in beta, providing an opportunity for testing applications, migration, extensions, execution plans, and maintenance workflows.