spatial Archives

Winsage

September 21, 2026

Microsoft remembers Mixed Reality exists, adds basic features I bet you thought were already here

A recent update to Mixed Reality Link has improved the user experience for utilizing a virtual reality headset as a monitor for Windows 11 PCs. The update, version 26.9105.9070.0, allows direct access to the headset's microphone and cameras within the Windows environment. Mixed Reality Link enables the connection of up to three virtual monitors on compatible headsets, such as the Meta Quest 3 and Meta Quest 3S, supporting both wired and wireless connections. Previous versions required users to connect an external microphone, but the latest update integrates the headset's built-in microphone and camera with Windows applications.

Tech Optimizer

September 4, 2026

Object Storage + WAL: Lakebase Postgres for the agentic era

Agents interacting with traditional OLTP databases face bottlenecks at the storage layer due to data movement required for operations like deploying instances and managing replicas. Object storage solutions, such as Amazon S3, provide a more efficient and cost-effective alternative. The text discusses two OLTP models: data-centric and transaction-centric. The transaction-centric model emphasizes the importance of transaction history, which Postgres retains through its write-ahead log (WAL). The WAL records every modification before it is committed, allowing for the reconstruction of the database state as of a specific point in time. Lakebase Postgres introduces a two-layer architecture separating compute and storage. The compute layer handles SQL operations, while the storage layer ensures data durability and historical integrity. The WAL is streamed to safekeepers for replication, and the pageserver transforms WAL into materialized pages stored in object storage. This architecture allows for efficient read and write operations without direct interaction with object storage during queries. Key features of Lakebase Postgres include branching, which allows agents to create pointers to specific LSNs without copying data; instant restore capabilities that enable point-in-time recovery; time travel queries for accessing historical data; and read replicas that do not require data duplication. The system also supports scaling down idle compute nodes and eliminates the need for separate copies of data for transactional and analytical processing by storing a single durable copy in object storage. Overall, Lakebase Postgres enhances agent interactions with the database by leveraging object storage as a foundational element.

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.

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.

AppWizard

July 6, 2026

New Meta Quest, SteamVR and PC VR games launching in July 2026

In July 2026, several virtual reality titles are set to release across various platforms: - Enigmo: Launching on July 7 for PC VR, it is a physics puzzle game where players redirect liquid droplets, plasma particles, and lasers. - Geronimo: An Early Access tactical shooter releasing on July 10 for PC VR, focusing on cooperative gameplay and team-based movement. - One More Delve 1.0: Celebrating its full release on July 13 for PC VR and Quest 3, this cooperative dungeon crawler features physics-based combat and loot collection. - Fixer Undercover: Arriving on July 16 for PC VR, it is a spy-themed escape room game where players solve challenges while disguised as a maintenance worker. - Roboquest VR: Launching on July 23 for Quest 3, this game includes a co-op update for enhanced multiplayer experience. - Puzzles of the World: Transitioning from Early Access to a full release on July 23 for Quest 3 and Quest 3S, it offers a miniature-building experience. - Cybercore Protocol: Releasing on July 26 for Quest, it turns players' surroundings into a mixed reality battlefield. - Hyperstacks: Scheduled for July 30 on SteamVR, it combines parkour, combat, and puzzle-solving with user-generated content. - Streets of Miami VR: Initially set for July 30, it has been postponed to August 28 on SteamVR, featuring a semi-open world in 1980s Miami.

AppWizard

June 18, 2026

Sony’s Forgotten Multiplayer PS5, PC Game Gets Final Update as Developer Moves On

Velan Studios has announced the release of the final update for their multiplayer shooter, Midnight Murder Club, which was launched by Sony in August 2025 for PS5 and PC. This update is primarily for Steam players and marks the end of post-launch support, although the game will remain available and the servers will stay operational. Midnight Murder Club features online multiplayer gameplay where players navigate a dark mansion using stealth and strategy. Despite its innovative concept, the game struggled to maintain a large player base.

BetaBeacon

June 17, 2026

Get it reserved: Xreal’s Aura smart glasses refresh the game with powerful Android XR and AI

Xreal announced the launch of its Aura smart glasses with Google's Android XR and Qualcomm's Snapdragon Reality Elite, featuring a 70-degree FOV, hand-tracking, and strong multimodal AI.

AppWizard

June 10, 2026

A new Steam Frame setup video leak hints at imminent release date

A video demonstrating the setup procedure for the Steam Frame has leaked, showcasing the user experience and referencing the upcoming device. Valve is expected to release the Steam Frame this summer, following the successful launch of the Steam Controller. The Steam Frame and Steam Machine are part of Valve's new hardware lineup. The setup video, shared on Reddit, features a "Welcome to Steam Frame" message and guides users through powering on controllers and connecting to a PC. The Steam Frame will be a standalone headset with 2,160 x 2,160 LCD screens for each eye, offering both independent gaming and PC connectivity, and it eliminates the need for base stations.

Tech Optimizer

June 6, 2026

PostgreSQL vs SQL Server 2026: $0 vs $15K License

PostgreSQL has become the most utilized database for developers for two consecutive years as of 2026, while SQL Server has introduced native AI capabilities and vector search functionalities in its latest release. PostgreSQL is favored for new projects due to its permissive licensing, cross-platform operation, and extensive ecosystem of extensions, whereas SQL Server is preferred by organizations already using Microsoft products for its robust tooling and enterprise support. As of June 2026, SQL Server ranks third in the DB-Engines popularity ranking with a score of 698, while PostgreSQL ranks fourth with a score of 688. Developer adoption trends show that 49% of respondents in the Stack Overflow 2024 Developer Survey use PostgreSQL, compared to 27% for SQL Server. The latest stable version of PostgreSQL is 18.4, released on May 14, 2026, while SQL Server 2025 (version 17.x) became generally available on November 18, 2025. PostgreSQL is free under a permissive license, while SQL Server's Enterprise Edition can cost upwards of ,123 per two-core pack, with an eight-core minimum. PostgreSQL supports various operating systems, including Linux, Windows, macOS, and BSD, while SQL Server operates on Windows and Linux. PostgreSQL uses PL/pgSQL as its primary procedural language, allowing for multiple procedural languages, whereas SQL Server uses T-SQL. PostgreSQL's JSONB type offers rich indexing, while SQL Server added native JSON support in its 2025 release. Both databases are capable of handling high transaction volumes, but PostgreSQL excels in read-heavy scenarios due to its multi-version concurrency control, while SQL Server's columnstore indexes provide advantages for analytical workloads. PostgreSQL supports tables up to 32 TB, while SQL Server can handle a maximum database size of 524 PB. SQL Server's high availability technology includes Always On Availability Groups, while PostgreSQL offers built-in streaming and logical replication. The security features of both databases meet enterprise standards, with PostgreSQL providing a transparent patching process and SQL Server integrating with Microsoft tools. Real-world usage examples include Stack Overflow using SQL Server, while Instagram and Reddit utilize PostgreSQL. Developer sentiment increasingly favors PostgreSQL for new projects, emphasizing flexibility and open-source solutions. For new startups or greenfield projects, PostgreSQL is recommended due to its zero license cost and compatibility. Existing Microsoft enterprises are advised to stick with SQL Server for its integration benefits. Migration from SQL Server to PostgreSQL is becoming common, with a structured approach required for successful transitions.

AppWizard

June 3, 2026

New Dino Survival Game: The Lost Wild Comes To PS5 and PC in 2027

Great Ape Games has announced The Lost Wild, a survival horror game set to launch on PlayStation 5 and PC in 2027. The game focuses on survival around dinosaurs, emphasizing observation, instinct, and restraint rather than combat. Players must navigate a world where dinosaurs are portrayed as believable animals, fostering a sense of vulnerability and tension. The gameplay involves studying dinosaur behavior and using the environment to evade threats. The narrative unfolds through environmental storytelling, allowing players to piece together the island's history. The game aims to create a unique form of fear that emphasizes the player's lack of control and respect for the dinosaurs. Players can wishlist the game on PS5 or Steam.