code Archives

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.

TrendTechie

July 2, 2026

Релиз BATorrent 3.0 — легковесного BitTorrent-клиента, созданного на C++, Qt 6 и libtorrent-rasterbar

BATorrent 1.0 is a lightweight BitTorrent client released in March 2026, developed using C++, Qt 6, and libtorrent-rasterbar. It is open-source and available on GitHub under the MIT license, with builds for Windows, Linux, and macOS. Key features include support for magnet links and .torrent files, resuming capabilities, sequential downloading, file prioritization, and imports from qBittorrent. It has automatic RSS downloading with regex filtering, duplicate detection, and automatic tracker list generation from Stremio. Streaming is supported with players like VLC and IINA. BATorrent emphasizes user privacy with no telemetry or analytics, and the only outgoing request is a release check on GitHub, which can be disabled. The user interface includes three themes, a real-time speed graph, a detailed tabbed panel, a filter panel, drag-and-drop support, and system tray notifications. It supports multiple languages and prioritizes privacy with features like PT mode for private trackers, one-click Tor proxy setup, and leech blocking. Notifications can be sent via Telegram webhook, and it has enhanced Discord presence status and native OS notifications.

Winsage

July 1, 2026

Former Microsoft engineer shrinks Notepad down to size

Dave Plummer, a former Microsoft engineer, has created TinyRetroPad, a minimalist text editor that is only 2.5 kilobytes in size. It aims to provide a simple text editing experience, reminiscent of older software like Notepad, which has become bloated over time with unnecessary features. TinyRetroPad includes essential functions such as Open and Save As dialogs, font selection, and printing capabilities, while using assembly language and the RICHEDIT50W from the WinAPI. The application requires more system resources to run effectively but focuses on maintaining lean code and binaries.

Winsage

July 1, 2026

Steve Ballmer once trashed Linux as “a cancer” — now it’s saving Windows 10 holdouts

In 2001, Steve Ballmer, then CEO of Microsoft, referred to Linux as a "cancer" threatening Microsoft's intellectual property and likened its users to "communist thieves." By 2016, after Microsoft ported SQL Server to Linux, Ballmer expressed enthusiasm for the change and acknowledged that the conflict with open-source had benefited Microsoft's financial success. In 2020, Microsoft President Brad Smith admitted the company had been on the wrong side of history regarding open source and noted the need for change. Microsoft has since embraced open-source technologies, introducing products like Azure Linux 4.0, built on Fedora. As Windows 11's transition becomes difficult for users, advocacy groups have criticized Microsoft for ending support for Windows 10, which could lead to millions of discarded computers. Microsoft extended Windows 10's life through an Extended Security Updates program until October 14, 2026, with a recent announcement pushing it to 2027. Rising hardware costs and design flaws in Windows 11 have led some users to consider alternatives like Linux. A survey revealed that 30% of PCs are still running Windows 10, and a poll showed that 68% of respondents plan to stick with Windows 10 through 2027.

AppWizard

July 1, 2026

Massive Samsung Galaxy Glasses leak gives sneak peek into manager app and gestures

A leak has revealed details about the Galaxy Glasses manager app, which will serve as the main hub for managing Samsung's upcoming smart glasses. The app will assist users in pairing the glasses, installing updates, and adjusting settings. It will feature menu options such as Camera, AI assistants, Read notifications aloud, Advanced features, Accessibility, and Find my glasses, with additional settings accessible only when connected to the glasses. Users can also automatically import photos and videos taken with the eyewear. The leak also describes intuitive buttons and gestures for user interaction with the Galaxy Glasses. Users can swipe to navigate music tracks and adjust volume, tap to pause or resume media playback, and use a button on the arm to capture photos or record videos. The glasses will have two LED lights to indicate recording status. Captured images and videos will be available in the Now Bar for previewing and reframing, with functionality expected to extend to the Galaxy Watch. Additionally, a Galaxy Glasses Controller app is in development for Galaxy Watches, and the upcoming Galaxy Ring will support gesture controls for enhanced user experience with the smart glasses.

AppWizard

July 1, 2026

Google App Update: A Stunning Gemini AI Upgrade For Mac Users

Google is developing a feature that allows Android users to remotely command and monitor AI workflows on their Macs through the Android Google app. This feature is linked to Gemini Spark, Google's AI agent, and includes a "new thread" system to prevent data leakage. The upgrade aims to create a cross-platform ecosystem for Android users to utilize AI capabilities on Apple-silicon Macs. The feature, internally codenamed "Robin," requires Gemini for macOS to be installed on Apple-silicon devices and allows users to perform tasks like summarizing PDFs or triggering scripts remotely. This functionality is currently exclusive to Mac users, providing them an advantage over Windows users who lack a standalone Gemini desktop client. The Gemini Spark AI framework is still in an experimental stage, and its performance on macOS has yet to be fully validated.

AppWizard

June 30, 2026

Open source game engine Godot will no longer accept AI-authored code contributions: ‘We can’t trust heavy users of AI to understand their code enough to fix it’

The Godot Foundation has decided to implement new guidelines to prohibit AI-authored code, pull requests from AI agents, and AI-generated text in communications between contributors. This decision follows concerns about the increasing number of AI-generated contributions, which have made code review more challenging for maintainers. The Foundation aims to reduce the burden on maintainers and ensure that all contributions come from accountable humans. The new policies will explicitly reject AI-authored code and advise contributors to use AI assistance only for minor tasks while requiring disclosure of its use. Machine translations of human-authored text will still be allowed. The Foundation plans to adopt a cautious approach to AI tools and will re-evaluate its policies as the situation evolves.

AppWizard

June 30, 2026

Samsung’s app for Android XR-powered Galaxy Glasses shows case, ‘One UI XR’ [Gallery]

Samsung's Galaxy Glasses are not set for imminent release, but recent leaks reveal details about their design and features. Screenshots from the companion app show a hardware design similar to Warby Parker glasses. The glasses will come with a carrying and charging case that has an external light indicator and uses contact-based charging. The companion app includes user management features, settings adjustments, and a software update section branded as “One UI XR.” There are indications of potential integration with the Galaxy Ring for gesture controls. Both Google and Samsung have confirmed the glasses will launch before the end of the year, but the exact date is still unknown.

Winsage

June 30, 2026

Steve Ballmer once called Linux a “cancer” — it’s funny Windows 10 holdouts may now see it as the cure for Windows 11’s hardware rules and the RAM crisis

Former Microsoft CEO Steve Ballmer initially described Linux as a "cancer" in 2001 but changed his perspective by 2016, supporting Microsoft's decision to port SQL Server to Linux. Microsoft President Brad Smith acknowledged the company's past underestimation of the open-source movement in 2020. Microsoft has integrated open-source solutions into its products, including PowerShell and Visual Studio Code, and launched Azure Linux 4.0. As Microsoft phases out support for Windows 10, critics argue this leads to programmed obsolescence, affecting up to 400 million PCs. Microsoft extended support for Windows 10 through its Extended Security Updates (ESU) program until October 14, 2026, with an additional extension through 2027. Rising hardware costs and stringent requirements for Windows 11 hinder many users' transitions. Advocacy groups are encouraging users to consider Linux, highlighting its advantages. Recent surveys show that 30% of HP PCs still run Windows 10, and a poll indicated that 68% of participants plan to stay with Windows 10 through 2027. There is a growing awareness among consumers regarding the potential shift to open-source alternatives like Linux.

Winsage

June 30, 2026

The smartest Windows OS upgrade costs just $10 through July 1

Windows 11 Pro is available for .97, down from its regular price of 9. This limited-time promotion runs until July 1 at 11:59 p.m. PT. The upgrade includes features such as a modern user interface, improved multitasking, advanced security features, Hyper-V, Windows Sandbox, BitLocker encryption, Azure AD integration, and Microsoft’s AI-powered assistant, Copilot.