NewApp Digest
search bot

challenges

silver Android smartphone
AppWizard
July 12, 2026

Helldivers 2 dev cracks down on ‘suspicious super credit activity’, though it would help if earning premium currency wasn’t so boring to begin with

A segment of players in Helldivers 2 has found ways to exploit super credits, prompting developer Arrowhead to address the issue. Arrowhead acknowledged player frustrations regarding cheating and announced plans to implement changes to tackle the problem. The current method of earning super credits is seen as tedious, as they can only be obtained from a limited number of points on the map, and the most efficient way to accumulate them is by playing on easier difficulty levels. Arrowhead has sold over 20 million copies of the game and is considering introducing new side objectives or combat challenges to enhance the super credit earning process. The studio has been responsive to player feedback, leading to a shift in Steam reviews from mostly negative to predominantly positive in a couple of months.
Black Flag Resynced certainly scratches my nostalgia itch, but do you know what else does? Assassin's Creed Black Flag
AppWizard
July 12, 2026

Black Flag Resynced certainly scratches my nostalgia itch, but do you know what else does? Assassin’s Creed Black Flag

Ubisoft's Black Flag Resynced features enhanced visuals and quality-of-life improvements but raises questions about the essence of the original game. The revamped stealth mechanics allow players to crouch anywhere, eliminating fail conditions from stealth missions and diluting the sense of accomplishment. The original game's combat retains its fluidity with a classic control scheme, while Resynced departs from this style. The movement and climbing mechanics in the original require thoughtful navigation, whereas Resynced allows for a more reckless approach. The ship combat in Resynced is improved with new firing modes and officer upgrades, making naval battles more challenging. The narrative of the original remains compelling, with new quests in Resynced feeling lacking in comparison. Modern additions like an in-game shop and a battle pass mechanic create dissonance between old and new elements. Overall, players driven by nostalgia may prefer the original Black Flag over Resynced.
What Is Serverless PostgreSQL?
Tech Optimizer
July 12, 2026

What Is Serverless PostgreSQL?

Serverless PostgreSQL is a fully managed cloud database model that separates compute and storage, allowing them to scale independently and automatically based on demand. It eliminates the need for manual infrastructure provisioning and capacity planning, charging only for active usage. Unlike traditional PostgreSQL setups, which require continuous resource allocation and manual scaling, serverless PostgreSQL provisions resources on demand and can scale down to zero during idle periods. Serverless PostgreSQL integrates with serverless compute platforms, enabling analytical queries to access the same data within a unified architecture. Key differences between traditional and serverless PostgreSQL include manual versus automatic provisioning and scaling, fixed versus usage-based billing, and high versus reduced operational overhead. Lakebase architecture is an emerging model that combines transactional databases with lakehouse foundations, allowing operational and analytical workloads to coexist on a single platform. This architecture minimizes data duplication and simplifies access, enhancing data management and analysis. Serverless PostgreSQL operates on a cloud-native architecture that enhances efficiency by allowing compute and storage to scale autonomously. It features scale-to-zero behavior, where compute resources are suspended when inactive and reactivated upon new queries. Major providers include Databricks Lakebase, Amazon Aurora Serverless v2, and Neon, each offering varying capabilities and integrations. Pricing for serverless PostgreSQL typically includes charges for compute resources, storage, and data transfer, with costs fluctuating based on workload activity. Cold start latency is a performance consideration, as reactivating compute resources can introduce delays. Strategies to mitigate this include keeping resources partially active or selecting providers with minimal cold start impacts. Serverless PostgreSQL is well-suited for OLTP workloads, while lakebase architecture is better for AI development, variable workloads, and environments requiring rapid iteration. Setting up serverless PostgreSQL involves choosing a provider, creating a database instance, and configuring access settings. It can also be used alongside serverless compute platforms for analytics, further extending its capabilities.
Weekend PC Game Deals: GTA, Borderlands, Kingdom Come, Stray and more
AppWizard
July 12, 2026

Weekend PC Game Deals: GTA, Borderlands, Kingdom Come, Stray and more

The Epic Games Store is offering two free titles this week: Nova Lands and Tattoo Tycoon, available until July 16, when Echo Generation and Luto will replace them. The July Humble Choice lineup includes eight games: Sea of Stars: Sunset Edition, TUNIC, Neon White, Police Simulator: Patrol Officers, Drop Duchy - Complete Edition, Sledders, Dicefolk, and Our Adventurer Guild, available for purchase until August 4. Additionally, Humble has released two game bundles: the Narrative Bundle, featuring 12 games, and the Squad Goals bundle, which includes cooperative titles. The GOG store has ended its DRM-free summer sale but continues with standard promotions. Availability and pricing may vary by region.
Obsidian game director is sick of hearing bad takes about the state of the studio: 'The through line from KotOR2 to our current games is pretty clear'
AppWizard
July 12, 2026

Obsidian game director is sick of hearing bad takes about the state of the studio: ‘The through line from KotOR2 to our current games is pretty clear’

Microsoft has restructured Xbox, resulting in significant layoffs affecting thousands of employees and the disbanding of four game studios, including Double Fine and Compulsion Games returning to indie status, while Ninja Theory and Undead Labs were sold. Obsidian Entertainment, initially thought to be unaffected, also faced layoffs but is reportedly developing a new Fallout game with Josh Sawyer as director. A member of Obsidian's leadership, Adler, expressed frustration over misconceptions about the studio's evolution, emphasizing that key figures from its past successes remain. He reassured fans that the core essence of Obsidian is unchanged, despite recent challenges. Adler acknowledged the emotional toll of the layoffs and expressed support for departing employees. Anticipation for Obsidian's new Fallout title is growing.
Running pgvector in production on Amazon Aurora PostgreSQL
Tech Optimizer
July 12, 2026

Running pgvector in production on Amazon Aurora PostgreSQL

Running pgvector on Amazon Aurora PostgreSQL-Compatible Edition offers a vector store with operational capabilities, high availability, and scalability. It is favored for Retrieval Augmented Generation (RAG) workloads transitioning to production, but increased traffic introduces challenges like query latency and memory management. Key operational practices for pgvector workloads include selecting the appropriate index type (HNSW or IVFFlat), establishing a baseline schema, choosing a suitable distance operator, scaling the index through quantization and partitioning, and preparing for churn and observability. The prerequisites for using pgvector include an Aurora PostgreSQL-Compatible cluster with specific PostgreSQL versions and the vector extension enabled. The embedding model used in examples is Amazon Titan Text Embeddings V2, which produces 1024-dimensional embeddings. pgvector supports two Approximate Nearest Neighbor (ANN) index types: HNSW, which is efficient for querying and allows for incremental insertions, and IVFFlat, which is less resource-intensive but requires rebuilding if data changes. There are scenarios where forgoing an index is beneficial, such as small datasets or partitioned datasets requiring 100% recall. A baseline schema for a multi-tenant document store includes creating a table for documents with an embedding vector and establishing indexes for tenant IDs and embeddings using HNSW. The recommended parameters for HNSW include m = 16 and ef_construction = 128. Scaling to millions of vectors involves quantization, tuning HNSW parameters, and partitioning. Aurora Optimized Reads can extend effective cache capacity, and managing index churn is crucial for maintaining performance. Observability metrics include query-level statistics, instance-level metrics, and custom application-defined metrics. To clean up after testing, it is advisable to drop the created indexes and tables, and delete the Aurora PostgreSQL-Compatible cluster and any manual snapshots taken during testing.
Roughly 192 Subnautica 2 players have drowned every minute since launch
AppWizard
July 12, 2026

Roughly 192 Subnautica 2 players have drowned every minute since launch

Players of Subnautica 2 have collectively logged over 58 million hours of gameplay in under two months since its early access launch. During this time, players have recorded a staggering number of drownings, exceeding the average annual unintentional drowning deaths in the United States (4,083) by a factor of 3,829. Many players are equipped with oxygen tanks and exploring areas with breathable oxygen bubbles.
Palworld studio says delete your old mods before the 1.0 release: 'Disabling them is not enough'
AppWizard
July 11, 2026

Palworld studio says delete your old mods before the 1.0 release: ‘Disabling them is not enough’

Palworld is officially launching on July 10 after two and a half years in early access. The game's price will remain unchanged, but players are warned about potential issues with outdated mods. Pocketpair encourages players to back up their save data, delete specific old files, verify game files via Steam, and check that the game launches properly before the update. Players should unsubscribe from and delete any mods and wait for developers to confirm compatibility with the 1.0 version before reinstalling. Issues arising from using mods are not covered by support.
The most deranged videogame challenge run I've seen: A no-hit playthrough of the 'Unfair' difficulty in a 100-hour RPG
AppWizard
July 11, 2026

The most deranged videogame challenge run I’ve seen: A no-hit playthrough of the ‘Unfair’ difficulty in a 100-hour RPG

Davey Gunface, a YouTuber, achieved a no-hit playthrough on the Unfair difficulty setting of Pathfinder: Wrath of the Righteous. This game is known for its challenging nature, requiring skill and an understanding of build optimization. Gunface used a specific character build: Human Witch of the Veil 10 / Loremaster 9 / Rowdy Rogue 1, and employed strategies like sacrificing starter companions' builds to survive early levels. His journey includes notable characters like the Rowdy Rogue and Sabertooth Tiger pets. Gunface's full video documenting this achievement is three hours long and available on YouTube.
Search