processing Archives

Tech Optimizer

July 3, 2026

Best Antivirus for Windows XP: Options That Still Work

Finding a reliable antivirus solution for Windows XP is challenging due to the lack of support since 2014. Major antivirus vendors have withdrawn compatibility, leaving limited options. Panda Security continues to support Windows XP with its Panda Dome antivirus, which offers real-time protection and a cloud-based engine. Antivirus software can block known malware, flag suspicious activity, and stop recognized threats, but it cannot patch the operating system itself. Users have fewer choices for protection as new vulnerabilities emerge. Several antivirus tools compatible with Windows XP include: - Panda Dome: Actively maintained, offers real-time protection, free and paid plans available. - Avast (v18.8): Limited support, last updates in October 2024, free legacy version only. - AVG (v9): Discontinued in 2019, operates offline, free legacy version only. - ClamWin: Open-source, actively maintained, no real-time protection, free. - 360 Total Security: Active legacy version, multi-engine approach, real-time protection, free and premium options. - Malwarebytes (legacy): Only older versions support XP, best as a supplement, free legacy version. - VirIT eXplorer Lite: Actively maintained, free lite version with real-time protection. Choosing the right antivirus requires consideration of internet connectivity, hardware age, update status, and whether to use free or paid options. For most users, Panda Dome is recommended for its active support and real-time protection. To enhance security on Windows XP, users should keep machines offline when possible, use ad blockers, be cautious with emails and links, avoid fake antivirus downloads, transfer files via USB from modern computers, and keep third-party software updated.

Winsage

July 3, 2026

Windows 11 finally climbs over 70% of all users on Steam

Valve's June 2026 Steam Hardware & Software Survey shows that Windows 11 has a user base of 70.44%, up 0.68 percentage points from May, while Windows 10 is at 23.56%, down 0.43%. Windows accounts for 94.10% of users, macOS is at 2.21%, and Linux is at 3.69%. SteamOS Holo leads among Linux distributions with 0.84%. In hardware, 16GB of RAM is present in 41.57% of systems, and 1920x1080 resolution is favored by over half of users. The RTX 4060 Laptop GPU is now the most common GPU at 3.81%, surpassing the RTX 3060 at 3.73%. 24.50% of users utilize 16GB of VRAM, a 0.45% increase. Intel holds 54.01% of the CPU market share, while AMD has 45.99%, narrowing the gap from Intel's 68.8% in January 2025.

Tech Optimizer

July 2, 2026

From monolith to Lakebase to LTAP: rethinking the database from storage up

Sixteen years ago, the author began their PhD at UC Berkeley and was advised to focus on analytics rather than OLTP databases, which were considered solved. This led to the creation of Apache Spark and Databricks. However, during the development of Databricks, it was found that OLTP databases were not solved problems; they were difficult to scale and fragile. This realization led to the development of Lakebase, a serverless Postgres database designed with modern technology. Lakebase architecture separates the write-ahead log (WAL) and data files into independent, scalable services. The WAL is externalized to a service called SafeKeeper, which uses Paxos-based replication for durability, while data files are managed by PageServer, which stores them in cloud object storage. This design addresses challenges such as data loss, scaling, and performance interference between transactional and analytical workloads. Lakebase maintains compatibility with Postgres, offers unlimited storage, serverless compute, durable writes, and simpler high availability. It also introduces LTAP (Lake Transactional/Analytical Processing), which allows both transactional and analytical processing to operate on a single data copy in real time, eliminating the need for separate data copies and reducing costs. LTAP utilizes a unified storage layer that allows data to be materialized in both row and columnar formats, optimizing it for both transactional and analytical workloads. The system ensures that analytics can access the most current data without affecting transactional performance by using a log sequence number (LSN) to retrieve the latest changes. Unlike traditional CDC approaches, LTAP requires no explicit table replication, as all data is stored in a single governed copy. This architecture circumvents common issues faced by hybrid transactional/analytical processing (HTAP) systems, such as incomplete feature sets, lack of ecosystem support, and performance contention. The Lakebase architecture has unlocked capabilities like unlimited storage, elastic compute, durable writes, and instant branching, with ongoing developments anticipated in the future.

Tech Optimizer

July 2, 2026

From monolith to Lakebase to LTAP: rethinking the database from storage up

Sixteen years ago, the author began their PhD at UC Berkeley, where they were advised to focus on analytics rather than OLTP databases, which were considered a solved problem. However, upon developing Databricks, they found that OLTP databases were cumbersome, challenging to scale, and fragile. This led to the creation of Lakebase, a serverless Postgres database designed to address these issues by externalizing the write-ahead log (WAL) and data files into independent services. Lakebase architecture separates the WAL into a distributed service called SafeKeeper and data files into another service called PageServer, allowing for improved durability, scalability, and performance. This architecture eliminates data loss risks associated with disk failures and misconfigurations, simplifies high availability, and allows for elastic compute resources. Lakebase also introduces LTAP (Lake Transactional/Analytical Processing), which enables transactions and analytics to operate on a single data copy in real-time, avoiding the need for separate data copies and reducing costs. The system retains Postgres's ACID semantics while storing data in open columnar formats, making it accessible to both transactional and analytical engines without the delays and complexities of traditional replication methods. The architecture allows for unlimited storage, serverless compute, and instant branching, while ensuring that analytics can read the most current transactional data without affecting transactional workloads. LTAP aims to unify transactional and analytical processing by leveraging distinct compute engines for each workload while integrating at the storage layer.

Tech Optimizer

July 2, 2026

EDB Named a Leader in Multimodel Data Platforms Evaluation

EDB has been recognized as a Leader in The Forrester Wave: Multimodel Data Platforms, Q2 2026, with EDB Postgres AI (EDB PG AI) achieving the highest scores in Vision, Innovation, Roadmap, and Partner Ecosystem criteria. EDB PG AI integrates transactional, analytical, and AI workloads into a unified platform, supporting open-source frameworks and enabling various deployment options. The platform features governance at the data layer and is designed for operational efficiency, allowing organizations to implement sovereign AI quickly. EDB PG AI can be deployed on-premises, in hybrid environments, or across cloud infrastructures, backed by partnerships with companies like Dell, IBM, and NVIDIA.

Tech Optimizer

July 2, 2026

EDB named Forrester Leader in multimodel data platforms

EDB has been recognized as a Leader in Forrester's Multimodel Data Platforms evaluation for Q2 2026 for its EDB Postgres AI platform, receiving the highest scores in Vision, Innovation, Roadmap, and Partner Ecosystem. The platform is designed to manage mixed translytical and AI workload demands, offering flexibility in deployment across on-premises, hybrid, and multi-cloud environments. EDB's recent product update introduced agentic database and converged analytics functionalities, reportedly accelerating database tuning by up to tenfold and reducing analytics ownership costs by as much as 58%. The platform is supported by a partner ecosystem that includes Dell, IBM, NVIDIA, Red Hat, and Supermicro, which plays a crucial role in influencing database purchasing decisions. EDB's roadmap focuses on advancements in GPU-accelerated workloads, semantic intelligence, governance, and knowledge graph functionalities. The emphasis on sovereign deployment aligns with organizations' needs for control over sensitive data amidst stricter regulations.

Winsage

June 30, 2026

Microsoft Reveals Windows Setting to Safely Remove USB Drives and Prevent Data Loss

Removing a USB drive from a port without using the “safely remove” option is generally acceptable on many Windows computers, depending on the policy for the external device. Microsoft provides two main options for removable drives: quick removal and better performance. Under the quick removal policy, users can disconnect the device without the “Safely Remove Hardware” process, although this may reduce system performance. Since Windows 10 version 1809, quick removal has been the default policy for external devices. However, users must ensure that all operations, such as copying or formatting, are completed before removal. The better performance policy requires users to use the safe removal option to prevent data loss, as it allows write caching. Failing to do so increases the risk of data loss if the drive is disconnected while Windows is still processing writes. The highest risk of data loss occurs when the drive is removed while Windows or an application is engaged in file operations. The safe removal icon serves as a confirmation that the drive is not in use, helping to prevent accidental ejection during active processes. Users can check the flash drive policy by accessing the device properties in Disk Management. The chosen setting may persist upon reconnection to the same computer port, leading to different experiences for users with similar drives. To minimize data loss, it is recommended to wait for operations to finish and use safe removal when uncertain about the drive's status.

Winsage

June 26, 2026

Microsoft is turning Windows 11 into an AI operating system

Darren Oberst, co-founder of LLMWare.ai, highlighted the benefits of using local models on neural processing units (NPUs) for optimized AI performance and suggested that businesses can enhance efficiency by scheduling automated agent runs. Leonard Lee, principal analyst at Next Curve, emphasized the importance of safe deployment of agentic AI features being introduced by companies like Samsung and Lenovo. Jack Gold, principal analyst at J. Gold Associates, noted that Microsoft is embedding AI into its Windows operating system, requiring support for multiple AI chip types to provide flexibility for enterprises.

Tech Optimizer

June 26, 2026

EDB launches agentic Postgres AI with governance tools

EDB has introduced new features for its Postgres AI platform, including an agentic database and converged analytics capabilities, allowing enterprises to run AI agents alongside transactional workloads on a unified PostgreSQL foundation. The platform includes governance tools that position control mechanisms at the data layer and integrates AI processing with operational data, enabling businesses to connect live records with AI systems without transferring sensitive information. The agentic database can monitor over 200 metrics, identify issues, suggest changes, and apply fixes automatically based on user-defined policies. It consolidates various data types through a single SQL interface, significantly accelerating database tuning processes and enhancing application performance. EDB has also expanded its analytics capabilities with a zero-ETL architecture for real-time analysis and large-scale warehousing. EDB PG AI for ClickHouse targets real-time analysis, while EDB PG AI for WarehousePG focuses on historical analysis at petabyte scale. The platform claims up to 30 times faster query performance compared to legacy systems and improved scaling efficiency. EDB's platform integrates vector search and retrieval for AI agents, demonstrating lower query latency and higher retrieval accuracy than competitors. NTT East is using EDB PG AI for AI-driven network operations, while the governance feature manages agent access at the data querying point using native Postgres roles and row-level security. The platform can be deployed on-premises, in hybrid environments, or across cloud infrastructures, with partnerships including Dell, IBM, Nvidia, Red Hat, and Supermicro.

AppWizard

June 26, 2026

Steam Summer Sale 2026 Is Live: 90% Deals on PC Games as Machine Lottery Closes

Valve's Steam Summer Sale 2026 began today at 1:00 PM ET and will run until July 9, 2026, featuring discounts on over 4,000 titles. The average discount is around 45%, with reductions of up to 90% on older catalog titles. New releases like Gothic 1 Remake, Resident Evil Requiem, and Crimson Desert are included in the sale. Discounts are locked for the entire duration of the sale, and there is a minimum 30-day cooldown between promotional events for specific games, except for the four major seasonal sales. The Steam Machine lottery closed today, with invitations for winners to purchase starting the week of June 29. Those who missed the deadline will be placed on a waitlist, with processing expected by the end of 2026.