store Archives

AppWizard

July 2, 2026

Turn Your Android Smartphone Into A GameCube With This App

MrRubrik has developed a GameCube Launcher app for Android devices that allows users to transform their phone's interface to resemble the GameCube console. The app features a GameCube-inspired user interface, instant game launching via the Dolphin emulator, automatic detection of game covers, local game library management, and retro sound effects. It is designed to provide a nostalgic experience while incorporating modern functionality and is available for free on MrRubrik's website and the Google Play Store.

AppWizard

July 2, 2026

Amazon Prime’s 12 ‘free’ games for July include critically acclaimed RPG Symphony of War

Amazon has introduced new offerings for Prime subscribers through its Luna gaming service, previously known as Prime Gaming. This month, subscribers can claim the following PC games: - Available now: - CyClones (GOG) - LoneStar (Epic Games Store) - Symphony of War: The Nephilim Saga (Epic Games Store) - July 9: - Still There (GOG) - Regular Factory: Escape Room (GOG) - July 16: - Poly Vita (Legacy Games) - Framed Collection (GOG) - Escape Academy (Epic Games Store) - July 23: - In Sound Mind (Amazon Games App) - Mystic Academy: Escape Room (GOG) - July 30: - Zoria: Age of Shattering (GOG) - Weakless (GOG) Players can also claim some of June’s free Prime Gaming titles, including Tomb Raider 4-6 Remastered, Mafia 3 Definitive Edition, and G Joe: Wrath of Cobra, which will gradually become unavailable throughout the month. All claimed titles remain in the player's library regardless of their subscription status.

BetaBeacon

July 2, 2026

Your ‘Tiny Bookshop’ Opens Its Doors on July 9 for Android and IOS

Tiny Bookshop is now available on the App Store and Google Play for .99, with no advertising or microtransactions. The game allows players to run a bookshop in a cozy coastal town, interacting with diverse characters and customizing their shop. Key features include a touch-first interface, hand-drawn art, and ambient piano music.

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.

BetaBeacon

July 2, 2026

There’s now a fan-made port of these classic Star Wars games for Android

- Fan-made Android ports of Star Wars games Jedi Academy and Jedi Outcast were available over a decade ago but have since been abandoned. - A modern port called Psi-Touch is now available, allowing users to play Jedi Outcast, Jedi Academy, and Dark Forces on Android devices. - Setting up the port requires PC game files to be copied onto the Android device in specific folders. - Jedi Academy runs smoothly on Android devices and supports mods, gamepad controls, touch controls, auto-aim functionality, gyroscope support, console access, and other enhancements.

Tech Optimizer

July 2, 2026

How JSON.stringify Corrupted 150,000 Rows in My Postgres Database

A dataset of over 100,000 company profiles was found to have approximately 150,000 corrupted values across ten jsonb columns due to incorrect serialization caused by using JSON.stringify on values intended for jsonb columns. The problematic code was `await sql` update listings set services = ${JSON.stringify(record.services)} where id = ${record.id}`. This resulted in jsonb strings instead of jsonb arrays. The issue was detected by querying the type of the jsonb columns, revealing that two frequently updated columns had around 105,000 and 41,000 corrupted values, respectively. The repair process involved extracting the inner text and re-casting it as valid jsonb, while also addressing complications such as NUL bytes and double-encoding. The correct method for inserting jsonb values is to use `sql.json(record.services)` instead of JSON.stringify. Regular type checks are now part of a daily integrity job to prevent similar issues.

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.

AppWizard

July 2, 2026

This PC gaming launcher for Windows handhelds lets you browse stores and compare the best prices

Winhanced has introduced achievement support for popular gaming consoles like Steam, Xbox, and PlayStation. The latest update features a built-in store browser that allows users to navigate digital storefronts within the Winhanced interface. This feature is currently available for testing among supporters. The store browser offers personalized game recommendations based on user preferences and allows for searching specific titles or browsing categories. Winhanced encourages community feedback on the new feature and has a presence on Reddit for discussions.

AppWizard

July 2, 2026

PC game store GOG explains how digital ownership should be as PlayStation announces end of physical discs

PlayStation plans to phase out physical discs for its consoles starting in January 2028, coinciding with the digital-only release of GTA 6. This shift reflects the industry's move toward a digital-only future, impacting collectors and enthusiasts of physical media. Meanwhile, GOG offers a DRM-free gaming experience, allowing users to retain access to purchased games even if they are removed from the store, as long as the files are installed. GOG's model enables personal backups on physical media and does not require an internet connection for gameplay, although online multiplayer may vary. The future of PlayStation adopting a similar DRM-free approach remains uncertain.

AppWizard

July 2, 2026

July is a little light on the big new game releases, but your co-op horror Discord gang will be feastin’

In July 2026, notable game releases include: - Assassin's Creed Black Flag: Resynced (July 9, Steam | Singleplayer): A remake of the original game with enhanced visuals. - College Football 27 (July 9, Steam | 4-player co-op): The latest installment in the football franchise. - Palworld 1.0 (July 10, Steam | 4-player co-op): A survival crafting game with new features. - Halo: Campaign Evolved (July 28, Steam | 4-player co-op): A remake of the original Halo campaign with additional missions. Co-op indie horror games releasing include: - Cursed Cooking Mama - Happy's Burgatory (July 16, Steam | 4-player co-op). - After Hours Puzzler - Storebound 1.0 (July 16, Steam | 3-player co-op). - Asymmetric Rabbit Hunt - Carnival Hunt (July 23, Steam | 5 players). - Killer Customer Service - Shift at Midnight (Release date TBD, Steam | 3-player co-op). Gaming events include: - Tennocon (July 10 – 11). - Final Fantasy 14 Fan Fest (July 25 – 26). - Various Steam Sales throughout the month. Game updates and expansions include: - Flight Simulator 2024 (July 4). - Doom: The Dark Ages (July 7). - Granblue Fantasy: Relink (July 8). - Phasmophobia (July 21).