NewApp Digest
search bot

Optimization

Get 100 FPS With an RTX 4070 in Assassin's Creed: Black Flag Resynced Using Our Optimized PC Settings
AppWizard
July 8, 2026

Get 100 FPS With an RTX 4070 in Assassin’s Creed: Black Flag Resynced Using Our Optimized PC Settings

Assassin’s Creed IV: Black Flag has been remastered as Black Flag Resynced, utilizing the Anvil Engine from Assassin’s Creed Shadows. The game features three presets for portable gaming devices and is designed to run on a minimum of an AMD Ryzen 5 3600 and AMD Radeon RX 5500 XT. Visuals are enhanced with lush vegetation and advanced water effects, particularly benefiting sailing and ship combat. The game includes ten graphical presets and twenty adjustable settings for optimization. Recommended specifications for 1440p gameplay include an RTX 3080 or AMD Radeon RX 6800 XT, achieving around 60 fps at ‘High’ preset with ray tracing on ‘Standard’. The RTX 4070 can average 76 fps under these conditions, with potential for 100 fps by adjusting settings. Optimized settings for mainstream PCs and handheld devices are provided, allowing players to customize their experience based on hardware capabilities.
Windows 11 cleanup is finally simple with this powerful open‑source tool that strips bloat, boosts speed, and gives you real control
Winsage
July 8, 2026

Windows 11 cleanup is finally simple with this powerful open‑source tool that strips bloat, boosts speed, and gives you real control

Windows 11 includes built-in tools like Storage Sense, Temporary Files settings, and Storage Recommendations for managing storage. BleachBit is a free, open-source cleanup utility for Windows 11 that removes temporary files, caches, logs, and browsing data without ads. Users can download it via a standard installer or a portable version, with installation possible through the command line. BleachBit features a "Preview" option to estimate storage recovery before deletion and offers recommended cleanup options such as temporary files, logs, and the Recycle Bin. It includes a file shredder for securely deleting sensitive files and can wipe free disk space, although this is not recommended for regular maintenance. BleachBit does not have a Registry cleaner, which can prevent potential system issues. While it does not directly speed up Windows 11, it can free up storage space and resolve some cache-related issues. Users comfortable with Windows 11's built-in tools may not need BleachBit, but it offers greater control for those wanting to manage browser data and temporary files more effectively.
PostgreSQL Extensions Are an Architecture Decision, Not an Afterthought
Tech Optimizer
July 8, 2026

PostgreSQL Extensions Are an Architecture Decision, Not an Afterthought

A common issue in database migrations is the unplanned accumulation of extensions in PostgreSQL, leading to extension sprawl. Teams often install extensions without documenting the rationale, resulting in a complex web of dependencies that complicates future upgrades and removals. The installation process involves PostgreSQL accessing a control file that details the extension's version and dependencies, which can lead to multiple extensions being installed unintentionally. Upgrading and removing extensions are often neglected, causing risks such as the loss of dependent objects. Extensions typically default to the public schema, which can become cluttered; relocating them to dedicated schemas can improve organization. Trusted Language Extensions (TLE) allow non-privileged users to utilize procedural languages in managed databases without needing superuser access. Key extensions recommended for use include pg_stat_statements, pg_trgm, hstore, citext, and PostGIS, each serving specific use cases. Proper governance is essential for managing extensions, including documenting their purpose, ownership, and dependencies, to prevent operational surprises.
This 3KB notepad app shows exactly why modern Windows is so bloated
Winsage
July 8, 2026

This 3KB notepad app shows exactly why modern Windows is so bloated

Dave Plummer, known for creating the Windows Task Manager, discusses software bloat in a recent video, highlighting his compact notepad application, Tiny Retro Pad, which is only 2,686 bytes. He notes that while modern applications require higher specifications due to increased complexity, the lack of optimization in code has led to performance degradation. For example, Windows 10 required 1GB of RAM for its 32-bit version, while Windows 11 requires a minimum of 4GB. Plummer emphasizes the importance of efficient coding practices and critiques the tendency of modern software to include unnecessary components, suggesting that prioritizing efficiency could improve user experience on platforms like Windows 11.
From monolith to Lakebase to LTAP: rethinking the database from storage up
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.
silver Android smartphone
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.
Why B3 chose Android for secure AI-enabled productivity
AppWizard
July 1, 2026

Why B3 chose Android for secure AI-enabled productivity

B3 has deployed a secure mobile solution to 1,000 employees in two weeks using Android Enterprise, enhancing security with AI threat detection and Managed Google Play. The transition is expected to yield a 30% cost savings over the next decade. B3 prioritized security and compliance while providing devices that ensure constant availability and productivity. The deployment process was streamlined through collaboration with Samsung and Android Enterprise's zero-touch enrollment, allowing centralized management of devices. Employees received lightweight devices with 7-inch screens and longer battery life, leading to positive feedback. B3 is also expanding its use of AI to improve productivity and plans to refresh hardware more frequently due to the anticipated cost savings.
Search