NewApp Digest
search bot

creation

'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.
After leaving Epic Games last month, its former 'Unreal evangelist' is now building his own game engine
AppWizard
July 28, 2026

After leaving Epic Games last month, its former ‘Unreal evangelist’ is now building his own game engine

Sjoerd De Jong left Epic Games after 12 years as the lead evangelist for Unreal in June. He plans to create his own game engine, tentatively named Immens, to address the complexities of established engines like Unreal and Unity. De Jong believes there is a need for a modern engine designed from the ground up and envisions incorporating large language models and generative AI tools into the gaming ecosystem. He aims for Immens to be adaptable for AI integration while emphasizing the importance of developers in maintaining the artistry of game creation.
FreeBSD Developing New NTSYNC Driver For Accelerating Windows NT Sync Primitives
Winsage
July 27, 2026

FreeBSD Developing New NTSYNC Driver For Accelerating Windows NT Sync Primitives

The FreeBSD project released its Q2-2026 status report, highlighting several advancements, including the introduction of an AMD ROCm port and the development of a new NTSYNC driver. Enhancements for desktop and laptop users included porting the latest graphics driver code, transferring WiFi driver code from Linux, improving suspend and resume functionalities, enhancing support for the Framework Laptop, implementing suspend-to-disk capabilities, and refining the audio stack. An intern from the FreeBSD Foundation worked on porting AMD ROCm, and the NTSYNC driver is designed to be compatible with the Linux 7.0 interface. The unified system management platform, Sylve, received new features, and improvements were made in the scheduler, IPv6 support, and various software updates.
Powerful Windows 11 app Wintoys just got significantly better with long list of improvements
Winsage
July 27, 2026

Powerful Windows 11 app Wintoys just got significantly better with long list of improvements

Microsoft has enhanced the Windows experience with utilities like the Media Creation Tool and PowerToys, while third-party applications like Wintoys, an unofficial counterpart to PowerToys, have also been updated. The latest version of Wintoys features performance improvements from upgrades to .NET 10 and Windows App SDK 2.3.1, resulting in a 30% reduction in RAM usage on the Services page, a 20% decrease on the Apps page, and a 10% improvement on the Startup entries page. Key updates include the ability to enable or disable the recommended section in the Start menu, manage recent items tracking, and a new Device metadata option to prevent unauthorized app installations. The Services page has been rewritten for better memory usage and real-time updates. Additional improvements include enhanced keyboard navigation, new acrylic backdrop features for Windows 10 and 11, and various bug fixes for system settings, network stats, and overall stability. The updated version of Wintoys is available for download via the Microsoft Store.
Ubisoft says the Black Flag remake has exceeded 'annual expectations' in just two weeks, shortly after it laid off a number of the people who made it
AppWizard
July 27, 2026

Ubisoft says the Black Flag remake has exceeded ‘annual expectations’ in just two weeks, shortly after it laid off a number of the people who made it

Assassin's Creed Black Flag Resynced sold 2 million copies within 24 hours of its release. Ubisoft's CEO, Yves Guillemot, stated that the game exceeded annual expectations within two weeks and is the highest-rated entry in the franchise since the original Black Flag. The game was developed with significant contributions from Ubisoft Barcelona, particularly in the underwater levels. Despite its success, the launch occurred amidst recent layoffs at Ubisoft, affecting hundreds of employees. Player reception has been mostly positive, but some critiques have emerged regarding day-one downloadable content, simplified swordfights, and an in-game shop. A review by PC Gamer described the game as "a well-made, but inessential remake that loses more than it gains."
What does GTA Online 2.0 even look like—and, more to the point, what do we even want from Grand Theft Auto 6 multiplayer?
AppWizard
July 26, 2026

What does GTA Online 2.0 even look like—and, more to the point, what do we even want from Grand Theft Auto 6 multiplayer?

Grand Theft Auto 6 is anticipated to be released, with a focus on a single-player experience, although there are indications of an evolving multiplayer component. Rockstar has acquired Cfx.re and is discussing Project Rome, suggesting a broader vision for Vice City. GTA Online has transformed into a social hub with diverse subcultures, raising questions about the future of Online 2.0, including content moderation, creator ownership, and the relationship between the new and original versions. Rockstar's acquisition of FiveM indicates a shift towards a community-driven approach, potentially adopting a model similar to Fortnite with a creator economy and live events. The next iteration of GTA Online will face a different environment compared to its predecessor, and the release of GTA 6's first single-player installment in nearly 15 years may provide a distraction during this transitional period.
How do you feel about AI videogame music?
AppWizard
July 26, 2026

How do you feel about AI videogame music?

Generative AI has become increasingly integrated into game development, evolving from basic applications to the creation of entire games with minimal human involvement. This shift raises concerns about the impact on human creativity and artistic expression. In the realm of videogame music, while generative AI has not fully taken over, its influence is growing, with AI-generated rearrangements of game scores appearing on platforms like YouTube and accusations against Spotify for including AI tracks in playlists. This situation prompts questions about how gamers perceive AI-generated music and its effect on their experience. The emotional depth provided by human composers is viewed as irreplaceable by some, leading to concerns about the dilution of artistry in the gaming industry.
I checked Reddit to see which Windows 11 features people truly find "life changing", and the community had some surprising answers
Winsage
July 26, 2026

I checked Reddit to see which Windows 11 features people truly find “life changing”, and the community had some surprising answers

Windows 11 includes several features that enhance productivity, many of which are underutilized by users: 1. Clipboard History: Activated with "WIN + V", it allows users to access a history of copied text and images, improving multitasking by enabling retrieval of multiple copied items. 2. Snipping Tool: Beyond screenshots, it includes screen recording, text extraction (OCR), basic image editing, and GIF creation, streamlining workflows by reducing the need for third-party applications. 3. End Task from Taskbar: Users can terminate unresponsive applications directly from the Taskbar, simplifying the process compared to using Task Manager. 4. Windows Sandbox: Provides a temporary Windows environment for testing untrusted software without risking the main system, available only on Windows 11 Pro, Enterprise, and Education editions. 5. Winget Command: The Windows Package Manager simplifies app installation and updates via command line, saving time compared to searching for applications online. 6. Snap Layouts: Activated with "Win + Z", it enhances window management by allowing users to arrange applications efficiently on larger monitors. 7. Windows Key + Shift + Arrow: This shortcut enables quick movement of windows between multiple monitors, improving productivity for users with dual or multiple displays. 8. Voice Typing: Activated with "Win + H", it allows dictation in nearly any text field, enhancing efficiency and accessibility. 9. Reliability Monitor: Accessible via "perfmon /rel", it presents system issues on a timeline, making troubleshooting easier and potentially preventing unnecessary reinstallation of Windows 11. 10. Advanced Display Settings: Users can check and adjust their monitor's refresh rate in Settings, ensuring optimal performance, as many monitors default to 60Hz even if they support higher rates.
These 11 paid Android apps are worth every penny I spent
AppWizard
July 26, 2026

These 11 paid Android apps are worth every penny I spent

Stellarium Plus is a digital sky guide that shows celestial object positions and offers guided Tours and a calendaring feature. Buzzkill is a notification manager that allows personalized rules for alerts. Key Launcher Pro replaces the default Pixel Launcher with rapid search capabilities and additional features like Super Shortcuts and Focus Mode. Octopi Launcher Pro allows custom layouts for foldable devices, enhancing user experience through regular updates. KWGT Pro is a widget creation tool that enables device personalization with additional features in the Pro version. Tropical Hurricane Tracker provides timely updates on tropical weather conditions from NOAA and NWS, with an ad-free option available. PeakFinder identifies nearby mountains using the phone's camera and location, providing names and elevations. Hermit Premium transforms web pages into standalone web apps, enhancing privacy with an editable ad blocker and multiple profiles. Moon+ Reader Pro offers extensive customization for reading, including PDF editing tools. SuperDisplay provides low-latency connections that mimic a dedicated monitor. Tasker is an automation tool that allows users to create complex automation recipes for enhanced productivity.
Search