setup Archives

Winsage

July 11, 2025

4 things Linux does better than Windows for the average user

Windows 11 dominates the consumer market due to partnerships with laptop manufacturers, creating a barrier for Linux. Windows 11 requires users to create a Microsoft account during setup, allowing data tracking, while Linux allows setup with just a local username and password, enhancing privacy. Windows 11 imposes unnecessary features like OneDrive and aggressive marketing, whereas Linux offers a customizable experience without upsells. Windows often includes bloatware, while Linux distributions typically come with only essential applications that can be uninstalled. Linux provides extensive customization options through various distributions, allowing users to tailor their computing experience.

Winsage

July 10, 2025

Unofficial Windows reinstaller app locks you out of your Windows 11 PC until you pay

Windows 11 version 25H2 may allow users to uninstall Microsoft apps, addressing concerns about pre-installed software. However, recent tests suggest that the impact of such bloat on performance is minimal, leading some users to reconsider the need for a cleaner system. A concerning trend involves an unofficial app called "Windows Reinstall Master," which charges users 98 RMB for reinstallation services while locking them out of their operating system. This app resembles ransomware and often installs unwanted software, counteracting users' intentions to reset their systems. The situation is exacerbated by Microsoft's upcoming end of support for Windows 10, prompting users to seek help from unreliable sources, increasing the risk of scams.

Winsage

July 10, 2025

Breathing new Life into Old Devices with Windows 11 on Amazon WorkSpaces

The end of support for Windows 10 is set for October 2025, prompting businesses to consider alternatives like desktop-as-a-service (DaaS) solutions, such as Amazon WorkSpaces, due to many devices being incompatible with Windows 11. Organizations are repurposing older devices as clients for DaaS desktops to reduce costs and promote sustainability. Amazon WorkSpaces offers secure, cloud-based virtual desktops, enhancing security and business continuity while facilitating remote work. It has been recognized as a leading DaaS provider by Gartner. AWS announced compatibility with ChromeOS Flex in March 2025, making it suitable for repurposing older laptops. ChromeOS Flex requires minimal hardware specifications and simplifies IT management. Testing showed that a repurposed Dell E7440 laptop could effectively connect to a Windows 11 WorkSpaces desktop. The integration of Microsoft 365 Apps for enterprise on Amazon WorkSpaces allows users to utilize existing licenses at no extra cost. Amazon WorkSpaces operates on a pay-as-you-go model, supporting sustainability and cost savings while providing secure access to virtual desktops.

Tech Optimizer

July 9, 2025

Query Amazon Aurora PostgreSQL using Amazon Bedrock Knowledge Bases structured data

Amazon Bedrock Knowledge Bases has introduced a fully managed Retrieval Augmented Generation (RAG) feature that connects large language models (LLMs) with internal data sources, enhancing the relevance and accuracy of responses by integrating contextual information from private datasets. During AWS re:Invent 2024, it was announced that this feature now supports natural language querying for structured data retrieval from Amazon Redshift and Amazon SageMaker Lakehouse, allowing generative AI applications to access both structured and unstructured data sources. The system converts user queries into SQL queries using natural language processing, enabling data retrieval without requiring users to know SQL syntax. Amazon Bedrock Knowledge Bases currently supports structured data retrieval from Amazon Redshift and SageMaker Lakehouse. Although direct support for Aurora PostgreSQL-Compatible is not available, users can utilize zero-ETL integration between Aurora PostgreSQL-Compatible and Amazon Redshift to make their data accessible. This integration replicates Aurora PostgreSQL tables to Amazon Redshift in near real-time, simplifying data management. To enable natural language querying of structured application data stored in Aurora, organizations can set up an Aurora PostgreSQL database, create a schema with interconnected tables (products, customers, and orders), and populate these tables with sample data while maintaining referential integrity. Subsequently, they can establish zero-ETL integration with Amazon Redshift, which involves creating a Redshift Serverless workgroup and mapping the database for synchronization. Once the zero-ETL integration is verified, organizations can create an Amazon Bedrock knowledge base for natural language querying. This requires granting appropriate permissions to the Amazon Bedrock Knowledge Bases AWS Identity and Access Management (IAM) role and ensuring the knowledge base is synchronized with Amazon Redshift. After setting up the knowledge base, users can execute natural language queries, which are translated into SQL and processed to generate human-readable responses. Examples of queries include counting unique customers and identifying customers who have purchased the most products. Finally, it is recommended to clean up resources after use to avoid ongoing charges.

Winsage

July 9, 2025

How to delete the Microsoft account that Windows made you set up

Microsoft requires users to log in with an online account during the installation of Home versions of Windows 10 and 11. Users can bypass this requirement or modify their account settings after installation. To delete a Microsoft account, users should access the Settings app, navigate to the 'Accounts' section, select their account information, and follow prompts to remove the account. After removal, users can create a local account that does not require an online login.

AppWizard

July 9, 2025

9 best apps for the Galaxy Z Fold 7’s large display

Foldable smartphones have evolved into functional devices, with Samsung's Galaxy Z Fold 7 featuring a book-style design and a large display. Notion is a productivity tool that benefits from the Fold 7's screen space for note-taking and managing tasks. The Kindle app enhances the reading experience by utilizing the larger display for e-books. Samsung's Good Lock app allows for device customization, including features tailored for foldable devices. The Dolphin Emulator takes advantage of the Fold 7's Snapdragon 8 Elite chipset for gaming, allowing users to play GameCube and Wii titles. Super Display enables the Fold 7 to function as a portable monitor for Windows PCs. Canva's photo editor benefits from the larger display for designing graphics. Octopi Launcher allows users to customize app layouts for different screen orientations. The Galaxy Z Fold 7 is the thinnest and lightest of Samsung's book-style foldables, enhancing the mobile app experience.

Winsage

July 9, 2025

Windows 11 KB5062553 & KB5062552 cumulative updates released

Microsoft has released two cumulative updates for Windows 11: KB5062553 for version 24H2 and KB5062552 for version 23H2, addressing security vulnerabilities and various issues. Users can install these updates via Start > Settings > Windows Update or manually from the Microsoft Update Catalog. After installation, Windows 11 24H2 will have a build number of 26100.4652, and version 23H2 will be updated to 226x1.5624. The updates include enhancements such as smaller taskbar icons, a Microsoft 365 Copilot button in the Click to Do feature, and new features for Narrator and voice access. The PC-to-PC migration experience is being rolled out, and the Settings homepage is being updated for commercial customers. The taskbar will now dynamically resize icons, and the Accessibility menu has been reorganized. Ongoing issues with certain fonts in regions like China, Japan, and Korea have been noted, but no new issues have been identified.

Tech Optimizer

July 8, 2025

How TimescaleDB helped us scale analytics and reporting

At Cloudflare, PostgreSQL and ClickHouse are used as primary databases for transactional and analytical workloads. PostgreSQL is preferred for product development due to its speed, versatility, and reliability, with hundreds of instances running in various configurations. ClickHouse, introduced in 2017, allows ingestion of tens of millions of rows per second with millisecond-level query performance but comes with trade-offs. The Digital Experience Monitoring (DEX) product was developed with a focus on simplicity and rapid shipping, utilizing a team of three engineers and collaboration with other teams. DEX's initial launch included fleet status logs uploaded every two minutes and synthetic tests with usage caps, leading to a successful MVP launch ahead of schedule. The architecture included an HTTP API, PostgreSQL for storing configurations, and a React UI in the Cloudflare Dashboard. PostgreSQL was chosen for analytics due to its ability to handle structured logs, with a table created for device state logs lacking a primary key but optimized with unique and standard indexes for common queries. The UPSERT query was used for data insertion, and the order of columns in multicolumn indexes was optimized for performance. After launching DEX, the system scaled to 1,000 inserts per second, leading to performance degradation. Precomputed aggregates were implemented to improve query performance, resulting in up to a 1000x improvement. Table partitioning was considered but ultimately not pursued due to its manual management requirements. TimescaleDB was explored as an alternative to enhance query performance, offering features like automatic partition management, continuous aggregates, and compression. A side-by-side comparison with PostgreSQL showed significant performance improvements, particularly for longer time windows. TimescaleDB's integration allowed for efficient data retention and aggregation, simplifying the infrastructure. Following the success of DEX, other teams at Cloudflare began using TimescaleDB for analytics and reporting, consolidating data from various sources and managing high ingestion rates effectively by optimizing data handling techniques such as switching to COPY for bulk inserts and adjusting replication settings.

AppWizard

July 8, 2025

Jack Dorsey Unveils ‘Personal Experiment’ Bluetooth-Based Messaging App

Jack Dorsey, co-founder of Twitter and CEO of Block, has launched a messaging service called Bitchat, which allows smartphones to exchange encrypted messages via Bluetooth without internet connectivity. Currently in beta on Apple’s TestFlight, Bitchat creates a mesh network linking nearby devices, enabling communication even when cellular and Wi-Fi signals are weak. The app does not route traffic through company servers, collect personal information, or require accounts, and messages are stored only on users' devices and designed to disappear by default. Bitchat features group chats called “rooms,” identified by hashtags and secured with passwords, and includes a “store and forward” capability for offline users. The application aligns with Dorsey's commitment to decentralization and is intended to facilitate communication during blackouts, censorship, or surveillance. A technical paper about Bitchat is available on GitHub, and future updates will enhance connectivity through Wi-Fi Direct links.

Tech Optimizer

July 7, 2025

Percona offers clear view into Transparent Data Encryption

Percona has launched its Transparent Data Encryption (TDE) extension for PostgreSQL, designed to secure sensitive data at rest without licensing fees or usage restrictions. TDE automatically encrypts and decrypts data at the database layer, protecting backups and transaction logs, with encryption keys stored separately. The pg_tde extension supports compliance with regulations like GDPR, HIPAA, SOX, and PCI DSS v4.0, and allows users to encrypt all database files, apply encryption at the table level, and maintain control over their encryption strategies. It integrates with Key Management Services (KMS) providers and requires a patched PostgreSQL server to function. Percona aims to extend pg_tde to Community PostgreSQL, with some code already contributed for review. The extension is included in the Percona Distribution for PostgreSQL, which also offers support and consulting services for TDE setup and configuration.