stores Archives

Tech Optimizer

July 3, 2026

Why identity theft protection now matters just as much as antivirus

Cybercrime has shifted focus from targeting individual devices to stealing credentials and personal data for identity theft. In 2024, consumer losses due to fraud reached billion, a 25% increase from the previous year, with over a million identity theft reports filed. Stolen passwords and session cookies are central to most breaches, making credential theft the primary enabler of attacks. Password reuse is a significant vulnerability, with 65% of individuals reusing passwords, leading to increased risk of account takeovers through credential stuffing. Bitdefender offers features like Scam Protection Pro, which protects against fraud across email, chat, and SMS, and identity monitoring in Ultimate Security that alerts users to data leaks in real-time. In 2025, researchers identified approximately 2 billion unique leaked credentials, emphasizing the need for identity protection alongside traditional antivirus solutions.

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.

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.

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

‘They refuse to offer a meaningful alternative’: Game preservation leader agrees that piracy is the only preservation option for a discless future

Sony plans to discontinue the production of physical game discs for the PlayStation 5 by 2028, shifting towards a fully digital licensing model. Frank Cifaldi from the Video Game History Foundation has raised concerns about the preservation of video game history, stating that piracy may become the only means of safeguarding digital works. He criticized the Entertainment Software Association for resisting efforts to create a legal framework for preserving digital content. Cifaldi highlighted that museums and archives are preparing for this digital future, questioning the industry's expectations for cultural institutions as physical media is phased out. The transition to digital ownership has sparked discussions in the gaming community, particularly regarding the lack of backward compatibility in the PlayStation ecosystem and the challenges posed by the closure of digital stores for older consoles. The urgency for solutions to protect video game history is increasing as the industry moves towards a digital-only future.

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).

AppWizard

July 1, 2026

South Korea accuses Google of Android App market abuse

South Korea's antitrust regulator, the Korea Fair Trade Commission (KFTC), has formally accused Google of abusing its dominant position in the Android app market. The allegations involve a program called the Games/Google Velocity Program (GVP), which reportedly pressured game developers to favor the Google Play store over competitors. The KFTC claims Google's actions have affected approximately 14.16 trillion won in revenue and could lead to fines of up to 6% of that amount. The program, operational since July 2019, provided financial support to developers in exchange for favorable terms on Google Play. The KFTC has categorized these actions as an abuse of market dominance and an unfair exclusive dealing practice. Google has eight weeks to respond to the allegations before a final ruling is made. This case is part of a larger global scrutiny of Google's influence in app distribution, with similar issues arising in India and the European Union.

AppWizard

July 1, 2026

South Korean trade watchdog alleges Google abused its position in Android app store

South Korea's antitrust regulator, the Korea Fair Trade Commission (KFTC), has raised concerns about Google's practices in the Android app marketplace, identifying potential abuses of market dominance that may have stifled competition. The KFTC's Market Surveillance Bureau reported that Google's actions have impacted approximately 14.16 trillion won (around billion) in revenue. The report focuses on Google's "Games/Google Velocity Program," which operated from July 2019 to March 2026, providing financial support to game developers in exchange for launching games on Google's app store under favorable terms compared to competitors. This program reportedly diminished developers' incentives to use rival app stores, effectively creating a state of exclusive dealing with Google. If found guilty of market abuse, Google could face a fine of up to 6% of the affected revenue, approximately 0 million. Google has eight weeks to respond to the report, and the KFTC will issue a final ruling thereafter.

AppWizard

July 1, 2026

KFTC accuses Google of abusing Android app dominance, may face $9.1bn fine

South Korea's competition regulator, the Korea Fair Trade Commission (KFTC), has accused Google of using its dominant position in the Android apps market to suppress competition, potentially leading to significant financial penalties. The KFTC estimates that Google's practices have revenue implications of 14.16 trillion won (approximately .1 billion). The investigation centers on the Games/Google Velocity Program, also known as "Project Hug," which allegedly provided financial incentives to game developers for launching titles exclusively on the Google Play store. This program reportedly discouraged developers from distributing their games through competing platforms, particularly OneStore. If the KFTC finds that Google abused its market position, the company could face fines of up to 6% of the affected revenue, around 0 million. Google will have eight weeks to respond to the evidence against it, and the KFTC plans to expedite a final decision while respecting Google's due process rights.

AppWizard

June 29, 2026

XBOX PC and Games

The PC is a popular platform for gamers, and Windows 11 enhances this experience with features tailored for gaming. It includes an integrated Xbox app that connects with third-party game stores and Microsoft's gaming ecosystem. The Game Bar allows users to capture screenshots, record video clips, and interact with friends on Xbox Live. Xbox Mode optimizes resource usage for gaming but is not enabled by default. Windows 11 comes with pre-installed gaming features, including the Xbox app and Game Bar, which can be customized through the Settings app. Users can configure display settings, connect an Xbox Wireless Controller, and customize the Game Bar and its widgets. The Xbox app allows users to manage their game libraries, access Game Pass subscriptions, and stream games via Cloud Gaming. Microsoft offers various Xbox Game Pass subscription tiers for access to a library of games. Xbox Mode provides a full-screen, controller-optimized interface that enhances gaming performance.