Gates Archives

Tech Optimizer

August 17, 2026

How PGSimCity Turns PostgreSQL Complexity Into a Virtual City 3D Simulation

Nikolay Samokhvalov has introduced PGSimCity, an open-source educational tool that visualizes PostgreSQL cluster mechanics in a 3D simulation accessible via web browsers. The tool represents PostgreSQL 18's internals as municipal districts, with components like shared_buffers and Write-Ahead Logging organized spatially. It separates rendering from state transitions to maintain architectural integrity. Backend developers can trace SQL statement lifecycles and simulate operational anomalies, such as memory restrictions leading to performance issues. The project has generated discussions on AI-assisted visualization and has received community feedback for improvements. PGSimCity includes PGlite for in-browser PostgreSQL execution and has a roadmap for future enhancements, with its codebase available on GitHub under the Apache-2.0 License.

AppWizard

August 15, 2026

EverQuest Legends is the only MMO that could hook me in 2026

PC Gamer's column "Terminally Online" explores the world of MMOs, featuring insights and guest writers discussing their favorite games. The author reflects on their experience with EverQuest, recalling their first adventures in 1999 at the age of six, influenced by their father's choice of a gnome magician. They describe the game's vastness and their initial fear of exploring beyond West Freeport, where they spent time battling rats and orc centurions. The recent release of EverQuest Legends aims to evoke nostalgia by reconstructing the original game with its graphics and mechanics while introducing modern conveniences such as in-game maps and a more forgiving gameplay experience. Project 1999 offers a free-to-play version of classic EverQuest, but many find it a fleeting experience. EverQuest Legends, developed by Game Jawn, has made the game more accessible with frequent level-ups and a gentler learning curve, inviting players to explore at their own pace. The game retains the essence of the original while appealing to those who enjoy mastering its systems, blending nostalgia with modernity.

AppWizard

August 8, 2026

By Royal Decree: Medieval Fantasy RPG Sovereign Tower Launches Today on PC!

On August 6, 2026, the Rennes-based studio WILD WITS, in collaboration with publisher Curve Games, released Sovereign Tower, a medieval fantasy round-table RPG available on PC starting at 5 PM BST. Players assume the role of the Sovereign, navigating a court filled with eccentric knights while managing the demands of a kingdom. The game involves recruiting Knights with unique strengths, assigning them to quests, and balancing relationships with the populace and nobles. Players can consult a Demon to rewind time and rectify mistakes. A supporter bundle is available on Steam, including the full game and soundtrack featuring songs from Hildegard Von Blingin’. Wild Wits, founded in 2021, specializes in narrative-driven experiences, while Curve Games is known for a diverse catalog of over 50 titles. G4F Records produces original soundtracks for video games and visual media.

BetaBeacon

August 2, 2026

The World as a Sliding Puzzle: Puzzle-Platformer Lost Twins 2 Released on iOS and Android

Lost Twins 2 is a puzzle-platformer game where players help twins Abi and Ben reunite and find their way home through a world of unique creatures. The game features an environment rearrangement mechanic where players can move and swap tiles to create new pathways and solve puzzles. Players will encounter increasingly complex challenges, including controlling both twins and coordinating their actions. Lost Twins 2 offers solo and local co-op modes, with a "try before you buy" model allowing players to download the game for free and unlock the full version with a one-time purchase.

AppWizard

August 1, 2026

ACRODRIFT: FPV Drone Simulator Arrives on PC on August 7

ACRODRIFT: FPV Drone Simulator is set to launch on PC via Steam on August 7, 2026, with console versions for PlayStation 5 and Xbox Series X|S expected in 2026 or 2027. Developed by Dueking Studio and published by Ultimate Games S.A., the simulator features realistic flight physics and offers three core gameplay modes: Free Flight, Race, and Collection. Players can engage with over 20 challenges and customize their drones in a workshop with options for pre-built models or scratch builds. The game includes six maps, 11 drone frames, and 13 types of motors. It supports both gamepads and professional drone controllers. The minimum system requirements for PC include Windows 10 64-bit, Intel Core i5-8400 or AMD Ryzen 5 1500X CPU, 8 GB RAM, and NVIDIA GeForce RTX 2060 or AMD Radeon RX 5600 XT GPU.

AppWizard

August 1, 2026

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

Total War: Warhammer 3 features ongoing issues with siege mechanics, notably a "gate bug" that affects unit movement during battles. Players have historically faced challenges with sieges, including unreliable pathfinding and the tendency for units to scale walls instead of moving through gates. The upcoming Total War: Warhammer 40k may change the approach to sieges, focusing on grander battlefield designs without conventional siege towers and ladders, potentially eliminating walls altogether. This shift could enhance tactical gameplay in streets and chokepoints, moving away from traditional wall-based defenses. The new War Core engine is expected to address persistent siege bugs from previous titles.

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.

Winsage

July 25, 2026

Today in Apple history: Windows scores big victory over Mac

On July 25, 1989, Apple faced a legal defeat against Microsoft in a copyright infringement lawsuit concerning the "look and feel" of the Macintosh and Windows operating system. Apple filed 189 counts of infringement related to Windows 2.0.3, but the judge dismissed 179 of these claims, allowing Windows to grow rapidly. The origins of the conflict began when Microsoft proposed a licensing agreement to Apple in 1985, which was rejected. Following this, Microsoft launched Windows 1.0 in November 1985, leading to tensions as Windows 2.0 more closely resembled the Macintosh interface. Apple filed a lawsuit on March 17, 1988, claiming copyright violations. The judge ruled that the existing licensing agreement covered many elements of Windows, contributing to a long-standing rivalry between the two companies and establishing a legal foundation for Windows' dominance in the 1990s.

AppWizard

June 29, 2026

Despite having no clue when GTA 6 is coming to PC, 39% of you are more than happy to wait for it

Rockstar Games has opened pre-orders for Grand Theft Auto 6, offering two versions priced at and 0, but the latter has not generated much enthusiasm. The game will not be available on PC at launch, leading to speculation about its release date for that platform. A poll revealed that 39% of respondents prefer to wait for the PC version, 28% expressed no interest in the game, 16% plan to purchase it on console, and 8% would buy it on console if they owned one. Another 8% are undecided and will wait until release to make a decision.

BetaBeacon

June 25, 2026

Marie Android is a 3D action game in which the cute heroine can get absolutely shredded

Marie Android is a 3D action-adventure game developed by Jinbey Aoyama, set to be released this summer. Players control a small robot named Marie with unique powers, such as transforming into a tank or flattening herself. The game involves solving puzzles and combat, with each section of the map presenting different challenges that players must master to progress. Aoyama, who has been active as a VTuber since 2018 under the name Marie Android, is working on the game solo, with virtual singer Pochi Korone lending her voice talents to the project.