NewApp Digest
search bot

digital

AWS embeds DuckDB in its PostgreSQL DBMS to speed queries of live and historical data
Tech Optimizer
October 10, 2026

AWS embeds DuckDB in its PostgreSQL DBMS to speed queries of live and historical data

Amazon Web Services Inc. has enhanced its Aurora PostgreSQL database management system to allow users to query the Apache Iceberg data lake directly. This feature integrates the DuckDB analytical engine, enabling seamless access to live transactions and historical records without data duplication or complex ETL processes. Customers can use existing PostgreSQL applications to query data in Amazon S3, including S3 Tables. The integration aims to reduce the engineering workload associated with data pipelines and supports real-time applications. DuckDB processes analytical scans within Aurora, eliminating extra network hops and allowing single queries to access both live and archived data. The feature supports external catalogs compliant with the Iceberg REST Catalog specification and can create foreign tables referencing data across multiple catalogs. Aurora optimizes query performance by filtering records and caching frequently accessed data. Customers can combine recent transactions in Aurora with historical data from S3 without manual schema definitions. For low-latency workloads, selected data can be copied into native Aurora tables using standard SQL. This capability requires the aurora_analytics extension and an AWS IAM role for S3 and Glue access, and is compatible with Aurora PostgreSQL versions 17.11 and 18.6. The feature is available across all AWS regions at no additional charge, with costs incurred only for Aurora computing resources and S3 requests.
Deadlock surpasses Team Fortress 2's all-time concurrent player count peak as it adds a chess wizard
AppWizard
October 10, 2026

Deadlock surpasses Team Fortress 2’s all-time concurrent player count peak as it adds a chess wizard

Valve's game Deadlock, currently in invite-only testing, has reached a peak concurrent player count of 262,145, surpassing Team Fortress 2's previous record of 253,997. This milestone coincided with the release of six new community-chosen heroes. The game's success reflects its popularity in the MOBA genre and highlights Valve's ability to innovate in game development.
Be warned: Nivalis Nights may not be the cozy game you expect: 'If you want a cozy existence in this city, you're going to have to earn it'
AppWizard
October 10, 2026

Be warned: Nivalis Nights may not be the cozy game you expect: ‘If you want a cozy existence in this city, you’re going to have to earn it’

Nivalis Nights is a user-generated tag on Steam that is described as a cyberpunk shop/life simulation game, with elements of management and relaxation. However, the game presents an overwhelming volume of quests and notifications, creating a chaotic experience that contrasts with traditional notions of coziness. Lead writer Thomas Welsh acknowledges that the game reflects life in a capitalist society, where players face burdensome debt and bureaucratic challenges. Despite its harsh world, the game includes decorating and management elements, visually stunning graphics, character narratives, and a hint of romance. The initial overwhelm from the quest log and constant notifications contributes to the subjective interpretation of coziness in gaming.
Best antivirus for Windows PC in 2026: 7 apps to keep your PC safe
Tech Optimizer
October 10, 2026

Best antivirus for Windows PC in 2026: 7 apps to keep your PC safe

Robust antivirus software is essential due to the rise of sophisticated online threats, including AI-driven attacks. Various antivirus solutions for Windows include: - Norton: Comprehensive protection with a user-friendly interface. - Avast: Easy to use, ideal for straightforward experiences. - AVG: Budget-friendly without compromising essential features. - Avira Prime: Simple and effective for beginners. - McAfee: Focuses on privacy and safeguarding personal information. - Panda: Offers a wide range of features for comprehensive security. - Windows Security: A free option providing basic protection. Key features to consider in antivirus software include strong protection against malware, user-friendly interfaces, performance impact on systems, and additional tools like parental controls and VPNs. Norton 360 Deluxe includes parental controls and cloud storage, while Avast One is noted for its simplicity. AVG Internet Security is cost-effective, and Avira Prime offers beginner-friendly features. McAfee Total Protection emphasizes privacy but may be pricier.
30-year Microsoft veteran explains why you shouldn’t run two antivirus apps on Windows 11
Tech Optimizer
October 10, 2026

30-year Microsoft veteran explains why you shouldn’t run two antivirus apps on Windows 11

Raymond Chen, a Microsoft veteran, advises against installing multiple antivirus solutions on the same system due to conflicts that arise, such as each program attempting to quarantine the other's processes. This can lead to significant performance issues and erratic behavior in Windows. Microsoft has stated that Windows Defender is sufficient for most users, highlighting its comprehensive security features in Windows 11. The company warns that running multiple real-time antivirus programs can increase resource consumption and conflict likelihood. Independent testing has shown that Microsoft Defender ranks highly among antivirus solutions.
DBtune autonomous optimization blows PostgreSQL bottlenecks away
Tech Optimizer
October 10, 2026

DBtune autonomous optimization blows PostgreSQL bottlenecks away

DBtune, a startup based in Malmö/Lund, Sweden, was founded in 2020 by Dr. Luigi Nardi as a spin-off from Stanford University and Lund University. The company focuses on enhancing PostgreSQL's capabilities through autonomous database optimization technology and has raised .4 million in a seed round from various investors in July 2023, with support from the Wallenberg Foundation and Vinnova. DBtune's technology utilizes agentic AI for optimizing PostgreSQL databases by tuning server parameters, optimizing indexes, and monitoring autovacuum processes. The release of DBtune version 4.0 incorporates machine learning and AI to dynamically adjust server parameters and suggest optimal indexing strategies. The platform identifies and ranks potential index opportunities based on workload and provides recommendations for new indexes and maintenance of existing ones. A case study with Midwest Tape demonstrated a 10.8x performance improvement in database query runtime after employing DBtune for performance tuning. Benchmarking tests showed a transaction throughput increase of 87% during initial optimization, with a further 17% improvement on an already optimized system. Disk I/O activity was reduced by 43%, and WAL generation decreased by 23%. Dr. Nardi emphasizes the need for AI-driven optimization to manage the complexities of PostgreSQL databases and rising cloud costs, suggesting that significant code adaptations will be necessary for achieving fully autonomous PostgreSQL.
Search