Extension Archives

AppWizard

June 22, 2026

Valve Wants You To Know The Steam Machine Isn’t A Video Game Console: ‘We Think Of It As An Extension Of PC Gaming’

Valve's Steam Machine is positioned as an extension of the PC gaming experience rather than a traditional video game console. The device starts at ,050 for the 512GB model, contrasting with the PlayStation 5 and Xbox Series X, which retail for around 0, and the PS5 Pro at 0 for a 2TB SSD. The maximum storage option for the Steam Machine is 1TB, priced at ,350. Valve emphasizes a more open gaming ecosystem, differing from the conventional model of selling hardware at a loss. The company collects a 30 percent platform fee on games sold through Steam but aims to remain outside the traditional hardware competition.

AppWizard

June 22, 2026

The Steam Machine is the start of an even more expensive future for game consoles

Valve's Steam Machine is priced at ,049 for the 512GB model and ,128 with a Steam Controller. The 2TB version costs ,349 or ,428 with the controller. In comparison, the 2TB Xbox Series X retails for 9.99, the PS5 Pro for 9.99, and the upcoming Switch 2 is expected to launch at 9.99. The Steam Machine offers access to Steam's extensive library of games and is positioned as a premium option in a market with rising hardware prices. Recent data shows a 46% decline in PS5 sales year-over-year, coinciding with a price increase to 9.99. Xbox is developing "Project Helix," a device between a console and a PC, but pricing concerns have led to a reevaluation of its vision.

Winsage

June 21, 2026

New DirectX Dump Files tool will make debugging crashes easier GPU + Windows

Microsoft has launched a public preview of DirectX Dump Files, designed to improve the debugging process for GPU crashes on Windows. The .dxdmp files are created when a hardware error is detected and contain hardware snapshots, driver data, Direct3D runtime context, and application user data. Developers need to meet specific requirements, including using Windows 24H2 or 25H2 with update KB5089573 or later, Windows 26H1 with update KB5089570 or later, Agility SDK Update Package 1.721.1-preview, and enabling developer mode. Additionally, AMD Software AgilitySDK Developer Preview Edition 26.10.07.02 is required for AMD graphics cards, along with compatible benchmark drivers from Intel, NVIDIA, and Qualcomm, and PIX version 2606.18-preview for analyzing dump files. The tool is currently focused on gathering developer feedback and is not intended for retail game integration. Developers can choose between three operational modes: NOOVERHEAD, MEDIUMOVERHEAD, and HIGH_OVERHEAD. The full launch is expected in fall 2026.

TrendTechie

June 20, 2026

Что такое торрент, как он работает и можно ли им пользоваться

Downloading a Linux distribution from the official website typically takes about half an hour, but during high-demand periods, such as new Ubuntu releases, speeds can drastically decrease due to server overload. Torrents, which use a peer-to-peer file-sharing protocol, allow users to download and share data simultaneously, reducing the load on a single server. Torrents operate by enabling direct exchanges between users through the BitTorrent protocol, where files are divided into smaller pieces and downloaded in parallel from multiple sources. Key terms include peers (users with parts of the file), seeds (users who have fully downloaded the file), .torrent files (metadata files), and magnet links (text-based alternatives to .torrent files). The BitTorrent protocol does not rely on a central server, enhancing resilience as files can continue to circulate as long as at least one seed is available. To use torrents, a torrent client is needed, with recommended options for 2026 including qBittorrent, Transmission, and BiglyBT. The BitTorrent technology itself is legal, but legality depends on the content being shared. Legal uses include downloading Linux distributions, open-source software, and scientific datasets, while unlicensed movies and cracked software are illegal. In Russia, while torrent technology is not prohibited, downloading copyrighted content without permission is a violation. Risks of using torrents include exposure to viruses and malware, copyright infringement, fake distributions, and IP address exposure. To protect oneself, users should choose moderated trackers, avoid suspicious files, use antivirus software, and limit upload speeds. Common problems include slow speeds, connection issues, and disappearing files, which can often be resolved by checking settings or ensuring there are seeds available. Sharing files after downloading is not legally mandatory but is considered good etiquette in the torrent community.

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 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.

Tech Optimizer

June 18, 2026

Retro gaming fans are the new target for fake GitHub malware

Retro gaming enthusiasts should be cautious when exploring GitHub projects for tools or plugins, as cybercriminals may disguise malware as homebrew software. A specific incident involved a project called EQVita, which pretended to be a free audio tool for PlayStation Vita but actually contained Windows malware. The downloaded file included three files: Launch.bat, luajit.exe, and x64.txt, with the latter concealing a hidden script that connected to the attacker's server upon execution. This scam is part of a broader trend where counterfeit GitHub repositories distribute SmartLoader malware, which retrieves additional malicious software aimed at stealing passwords and cryptocurrency wallets. The PS Vita community, despite the console's production ceasing, remains active in modding, making it a target for attackers. Legitimate plugins typically come in Vita-compatible formats, while fake ones may feature polished marketing materials and AI-generated descriptions. Users are advised to verify sources, be cautious of suspicious downloads, and utilize security tools like Malwarebytes. If someone has executed the malicious EQVitav1.3.zip file, they should conduct a malware scan, change important passwords, and monitor accounts for unauthorized access. Indicators of compromise include the domains https://github.com/Voistace/EQVita and https://voistace.github.io, and the IP address 85.137.52.21.

Tech Optimizer

June 18, 2026

Snowflake Postgres Unifies Your Apps, Analytics and AI

Every enterprise operates in two realms: one for real-time applications that process orders and engage customers, and another for analytics platforms that extract insights and drive AI. Snowflake is introducing Snowflake Postgres to bridge these realms with two key features: 1. Data mirroring, which is an always-on replication feature between Postgres and Snowflake, set to enter public preview soon. 2. Postgres for data lakes, allowing synchronization with analytics using open formats like Iceberg, which will be generally available shortly. These features aim to simplify the connection between transactional and analytical data, reducing the need for complex ETL pipelines. Customer feedback indicates that transferring data between OLTP and OLAP databases is the most challenging infrastructure task, leading to costs and issues such as data inconsistencies and delayed decision-making. Snowflake Postgres offers a simplified integration method with low-latency data mirroring that automatically maintains target tables in Snowflake to reflect the current state of source tables in Postgres. This setup can be configured easily through various interfaces or a single SQL command.

Tech Optimizer

June 18, 2026

Announcing Lakebase Search: agent-native retrieval built into Lakebase Postgres

Lakebase Search is a hybrid vector and full-text retrieval system integrated into Lakebase, now in beta on AWS and Azure. It utilizes two Postgres extensions: lakebase_vector and lakebase_text, allowing agents to operate on a single data backend. Agents manage four times more databases than human users and require real-time access to indexed data. The system features a tiered architecture that stores cold data in cost-effective object storage while keeping active data in local NVMe, significantly reducing costs. The lakebase_vector extension offers 32x compression for vectors, allowing a billion vectors to fit into under 10GB of RAM. The lakebase_text extension provides BM25 relevance ranking without high RAM usage. Benchmarking shows that Lakebase Search can efficiently handle large-scale workloads, achieving high recall and low latency with reduced resource requirements compared to traditional architectures. The system allows for continuous search experimentation and dedicated retrieval engines for each agent, enhancing operational efficiency and scalability.