NewApp Digest
search bot

space

silver Android smartphone
AppWizard
July 31, 2026

Total War: Warhammer 40k’s siege reset is one of the things I’m looking forward to most

The author experienced a frustrating siege battle in Total War: Warhammer 3 due to a gate bug that immobilized their unit. Historically, the series has faced technical issues with sieges, including the "gate bug" and unreliable pathfinding. The author speculates about siege mechanics in the upcoming Total War: Warhammer 40k, noting the presence of monumental structures and specialized Space Marine legions. They mention the absence of conventional siege towers and ladders in a recent livestream, suggesting potential changes to siege map designs. The author expresses a preference for battles in streets rather than relying on walls, which could lead to more dynamic gameplay. They anticipate that any siege-related bugs from previous games may not carry over to the new game due to the introduction of the War Core engine, fostering optimism for improved siege mechanics.
Gamers compress 80TB map of Minecraft's oldest anarchy server down to a 15TB download
AppWizard
July 31, 2026

Gamers compress 80TB map of Minecraft’s oldest anarchy server down to a 15TB download

A team of Minecraft enthusiasts has mapped the entire 2b2t server, resulting in a 15TB compressed download that can expand to an 80TB archive. The project, known as the 2b2tplace preservation initiative, began in 2024 and concluded in April 2026 after 22 months of work using 28 bot accounts to map over one million blocks across the Overworld, Nether, and End dimensions. The team developed a custom compression format (.zvcr) to achieve an 81.25% space savings, allowing the data to be stored more efficiently. The 2b2t server, which has been operational since 2010, is known for its lack of rules and moderation, fostering a unique anarchic environment. Despite preservation efforts, concerns exist among players about the server drifting from its original spirit.
Generating Referentially Consistent Synthetic Test Data for PostgreSQL in .NET Application Modernization
Tech Optimizer
July 30, 2026

Generating Referentially Consistent Synthetic Test Data for PostgreSQL in .NET Application Modernization

Satyajit Gokhale, Aiswaryaa Venugopalan, Ruchi Agarwal, Nits Jeganathan, Khurram Khawaja, Vijay Mandadi, and Luke Huan contributed to this article. AWS Transform offers a .NET application modernization service that allows enterprise customers to migrate from Microsoft SQL Server to Amazon Aurora PostgreSQL Compatible Edition. This migration reduces licensing costs and enhances scalability while utilizing an open-source ecosystem. Schema conversion tools can assist in translating DDL to PostgreSQL-compatible definitions, but correctness must be verified by teams to ensure performance under real-world workloads. Traditional testing methods, such as using production data or manual checks, are not scalable and raise privacy concerns. Therefore, there is a need for realistic synthetic data generated at scale that adheres to the migrated schema's constraints. AWS Transform for SQL Server modernization employs an AI agent to generate constraint-respecting synthetic data at scale during the migration workflow. This process involves loading the PostgreSQL schema into a live database, constructing a dependency graph for data generation, and distributing tasks across multiple sub-agents. The agent validates each generated INSERT against the live database, ensuring compliance with constraints and providing error diagnostics for any violations. The synthetic data generation workflow consists of four stages: schema analysis, establishing generation order, distributing tasks across sub-agents, and validation with error recovery. The agent extracts metadata from the PostgreSQL schema, determines a valid table generation sequence, parallelizes data generation while maintaining referential integrity, and generates and validates data row-by-row against the live database. Each successful insertion enriches the context for subsequent generations, while errors are handled through structured diagnostics and iterative regeneration. The process ensures referential integrity and preserves the generation state, allowing for recovery from interruptions without data loss.
I Spent a Month With the Steam Machine and it Perfectly Fills the One Gap in My Gaming Habits
AppWizard
July 30, 2026

I Spent a Month With the Steam Machine and it Perfectly Fills the One Gap in My Gaming Habits

The Steam Machine has been on the market for just over a month and has integrated into the user's gaming routine, particularly during a recent illness. The user connected it to their TV, disabled metrics, and explored their Steam library, finding the experience enjoyable. Despite skepticism about its high price for average consumers, the Steam Machine offers a solution for transitioning gaming from a desk to a living room without monopolizing the network. The user has historically preferred PC gaming over consoles, appreciating the flexibility of switching between devices. Previous attempts to set up living room PCs were inconvenient, but the Steam Machine simplifies this with SteamOS and the Steam Controller's trackpads. The user adjusted the output resolution to 1440p and enjoyed games like Resident Evil 4 Remake and Final Fantasy 7 Rebirth, valuing the ability to continue saves from their PC. The Steam Machine is priced at ,049, which may deter some, but it appeals to users with extensive Steam libraries.
AI taught to design efficient farms in Minecraft - mathematical modeling and constraints are used
AppWizard
July 28, 2026

AI taught to design efficient farms in Minecraft – mathematical modeling and constraints are used

The emergence of virtual assistants in gaming, particularly in agricultural simulation within Minecraft, enhances the gaming experience by providing players with instructions and explanations for farming tasks. A developer named Serranegra has created an AI tool that optimizes farm construction by generating an optimal arrangement of blocks based on player input regarding terrain and desired crops. For example, the AI's solution for sugarcane cultivation increases yield from 54 to 61 units while improving land utilization from 66.7% to 75.3%, representing a 13% efficiency increase. However, the tool's benefits vary by crop, with negligible gains for some, such as cacti and wheat. Serranegra has made the source code of the "optifarm" project publicly available on GitHub for collaboration.
ClamAV Setup: Linux Antivirus in 12 Steps [2026]
Tech Optimizer
July 28, 2026

ClamAV Setup: Linux Antivirus in 12 Steps [2026]

Malware can threaten Linux systems, which are often mistakenly believed to be immune to viruses. It can be introduced through email attachments, infected files, or compromised plugins, especially when Linux servers interact with Windows clients or handle internet uploads. ClamAV is an open-source antivirus engine maintained by Cisco Talos, designed for scanning mail traffic and file uploads. As of mid-2026, the stable release is ClamAV 1.5.x, with version 1.5.2 being the latest patch. To deploy ClamAV, users need root or sudo access on a compatible Linux machine, at least 2 vCPUs and 2GB of RAM, 5GB of free disk space, and outbound HTTPS access to ClamAV’s signature mirrors. The installation process involves several steps, including configuring freshclam for automatic updates, validating detection with the EICAR test file, and setting up cron jobs for regular scans. ClamAV can also be integrated with mail servers and a SIEM for enhanced security. Common pitfalls in deployment include skipping the initial freshclam run and using clamscan instead of clamdscan for repeated scans. ClamAV is free for commercial use and can also scan Windows systems, although it does not replace comprehensive endpoint protection solutions.
'PGSimCity' shows how the PostgreSQL database actually works internally in a SimCity-like 3D environment.
Tech Optimizer
July 28, 2026

‘PGSimCity’ shows how the PostgreSQL database actually works internally in a SimCity-like 3D environment.

PGSimCity is a web application that provides a 3D visualization of PostgreSQL's architecture, allowing users to explore its internal operations during SQL query execution. The application features an interactive interface that guides users through the connection process to PostgreSQL, illustrating how client connections reach the Postmaster and backend processes. It highlights the significance of connection pooling and the impact of increasing connections on backend processes. In the 'Query Lab' section, SQL statements are transformed into execution plans, showcasing processes like Parser, Rewriter, Planner, and Executor, along with execution paths such as Seq Scan and Index Scan. The shared_buffers area represents PostgreSQL's buffer cache, optimizing performance by reading data in 8KiB pages. Visualizations depict data pages stored on disk, with pathways showing the movement of pages to shared_buffers. The Write-Ahead Log (WAL) mechanism records changes for recovery, and transaction commits wait for WAL records to be flushed. Checkpointing writes dirty pages to storage in batches, which can cause latency spikes. PostgreSQL uses Multi-Version Concurrency Control (MVCC) to manage updated rows and dead tuples, which are cleaned up by autovacuum processes. The application also illustrates replication, where WAL from the primary server is sent to the standby server to maintain data consistency. Overall, PGSimCity provides a comprehensive view of PostgreSQL's components and potential performance issues related to caching, WAL management, checkpointing, vacuuming, and replication.
This week in PC games: a battle royale detective game, a broken Y2K metaverse, a laptop tycoon sim, and a new Company of Heroes RTS
AppWizard
July 27, 2026

This week in PC games: a battle royale detective game, a broken Y2K metaverse, a laptop tycoon sim, and a new Company of Heroes RTS

- Endacopia: A point-and-click horror game inspired by 90s edutainment software. - Broken Reality 2000: A first-person puzzle-platforming adventure set in a Y2K-themed metaverse. - Plum Road Tea Dream: A semi-autobiographical journey of a queer POC developer through seven distinct graphical worlds. - Moon Crashers: A game where players gather resources to build an escape rocket after crash-landing on the moon. - Forsaken Realms: Vahrin's Call: A third-person fantasy adventure set in a beleaguered city. - Kinny and the Cosmic Cauldron: A roguelike deckbuilder where players create soups for eldritch clientele. - Dissolution of the Silent Union: A narrative with gloomy anime aesthetics and themes of decay. - Orbital Hell: A hallucinatory score-attacker game battling geometric boglins. - Désorienté: A narrative-driven experience set in a violent world with intestines as currency. - CipherMind: A battle royale detective game for eight players in a concrete labyrinth. - Lunarium: An action-RPG featuring a knight and a floating sorceress. - Company of Heroes 3: Final Stand: A strategic spin-off involving tactical gameplay against waves of enemies. - Joy Malignant: A dice-based RPG set in a city filled with despair. - Truck-kun is Supporting Me from Another World?!: A humorous isekai game featuring a truck driver. - Outfield: An exploration of agricultural growth and its implications. - Olga: A cozy adventure game without combat. - Legacy of Sail: A nostalgic real-time naval tactics game. - Culdcept The First: A modern adaptation of a board/card game fusion. - Mistfall Hunter: A PvPvE extraction RPG. - Turnip Mountain: A 2D climbing simulator in a whimsical world. - Signy & Mino: Against All Gods: A side-scrolling RPG featuring a girl and her dog. - Devil's Hand: A card game where players form poker hands on a grid. - Parkside: Decayed Soul Manipulation: A sim shooter set in a dystopian California. - Cloud Sculptor: A 3D puzzle-platformer where players create sculptures for ghosts.
Search