NewApp Digest
search bot

Open-Source

My new favourite Tolkien game is free, has over 40 years of history, and would run on a toaster
AppWizard
August 1, 2026

My new favourite Tolkien game is free, has over 40 years of history, and would run on a toaster

Sil-Q is a free and open-source game that reimagines the classic Rogue experience within Tolkien's First Age of Arda, as depicted in The Silmarillion. It draws inspiration from the game Angband, which is a descendant of the 1983 title Moria. Players are tasked with infiltrating Morgoth's fortress to retrieve a Silmaril gem, focusing on strategic evasion rather than combat. The game restricts character options to races aligned with Tolkien's lore, including the Noldor, Sindar, Naugrim, and Edain, prioritizing immersion over balance. Players encounter challenges reminiscent of classic rogue-like gameplay while navigating Morgoth's domain, battling orcs and discovering mythical weapons. Sil-Q emphasizes storytelling and community engagement within the gaming realm.
Someone turned PostgreSQL into a city you can walk around in
Tech Optimizer
July 31, 2026

Someone turned PostgreSQL into a city you can walk around in

Nik Samokhvalov created PGSimCity, a visualizer for the open-source database PostgreSQL, inspired by the game SimCity. It allows users to navigate a city-like environment using gaming controls, where database transactions are represented as animations. The project originated from a prompt to Claude and involved 3.86 billion tokens of AI-assisted coding. PGSimCity is open source and has potential for adaptation to explain other complex technologies.
Microsoft PowerToys is still the first app I install on every Windows PC
Winsage
July 31, 2026

Microsoft PowerToys is still the first app I install on every Windows PC

PowerToys is celebrating its 30th anniversary this year, having originally been released for Windows 95 in November 1996. The Power Display feature simplifies the management of multiple screens, while other notable features include FancyZones for window management and PowerRename for file renaming. There is a gap in awareness about PowerToys, indicating that Microsoft could improve outreach to inform more users about its functionalities.
Windows 11 File Explorer just changed how file sizes work, how to see MB and GB right now
Winsage
July 31, 2026

Windows 11 File Explorer just changed how file sizes work, how to see MB and GB right now

Microsoft has updated the Details view in File Explorer for Windows 11 to display file sizes using appropriate units (KB, MB, GB) instead of only kilobytes (KB). This change aims to enhance user understanding of file sizes, particularly for casual users. The update is confirmed in the release notes for Windows 11 KB5101684. Users can enable this feature by downloading ViveTool, running a specific command, and rebooting their system. The original KB-only display can be restored with another command, although there is no toggle option provided by Microsoft for switching back.
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.
After rewriting SQLite in Rust, Turso turns its sights on Postgres
Tech Optimizer
July 29, 2026

After rewriting SQLite in Rust, Turso turns its sights on Postgres

Cloud database provider Turso is developing a Postgres-compatible implementation based on its SQLite-compatible database, which was created from scratch in Rust. CEO Glauber Costa believes Postgres can benefit from modernization for cloud-native applications. Turso's SQLite reimplementation, now called Turso, uses a virtual machine architecture that may eventually support other database frontends, including MySQL and Redis. The company initially forked SQLite into libSQL but later pivoted to a cloud service named Turso. They focused on a virtual machine architecture for their rewrite, which translates SQL queries into a custom bytecode language. Turso has developed a Postgres-compatible prototype named pgmicro, which aims to run existing applications with minimal modifications. The company is also working on a database-as-a-cloud service that will allow customers to use various database types on the Turso platform.
Search