subscriptions

Tech Optimizer
June 20, 2026
PostgreSQL version 18 has deprecated MD5 password authentication in favor of SCRAM-SHA-256, with a new parameter, md5_password_warnings, enabled by default to log deprecation warnings. It has enhanced monitoring capabilities by adding columns to pg_stat_database and pg_stat_statements to track parallel worker activity, with the default max_parallel_workers_per_gather set to 0 in Aurora PostgreSQL. The pg_stat_subscription_stats view now includes new columns for tracking conflict types in logical replication. Optimizer statistics are automatically transferred during upgrades, while uuidv7() generates timestamp-ordered UUIDs. The default streaming option for CREATE SUBSCRIPTION has changed to parallel, and the idle_replication_slot_timeout parameter automatically invalidates inactive replication slots. Enhancements to the COPY command include REJECT_LIMIT for error tolerance and a silent LOG_VERBOSITY level. OLD and NEW aliases have been introduced in RETURNING clauses for various DML commands.
AppWizard
June 18, 2026
Google's sideloading process allows users to access applications beyond the Play Store, including open-source and free apps. Five notable apps highlighted are: - WriteOn: A minimalist note-taking app that supports checklists, numbered lists, images, an in-app calendar, and a calculator. It features a Scratchpad for temporary notes and allows exporting notes as TXT files. It also includes a Flashcards feature for studying. - Fridgey: An open-source app for managing fridge and pantry inventory, allowing users to catalog food items by freshness and expiration. Users can input item details and adjust quantities as items are consumed. - PrivacyFlip: An app that enhances privacy control for Android users, enabling toggling of Wi-Fi, Bluetooth, and other features even when the device is locked. It includes a battery-saving feature and requires a straightforward setup process. - Timety: A productivity app that combines a to-do list, habit tracker, and focus timer. Users can categorize tasks, set priorities, and create subtasks. It features customizable habit tracking and a Pomodoro timer for maintaining focus. - Lune: An offline music player that supports Hi-Fi audio, allowing users to organize songs by various criteria and create customizable playlists. It includes equalizer adjustments and playback controls from notifications. These apps were selected for their open-source nature and utility in productivity and entertainment, with a focus on those that have received updates in the past year.
AppWizard
June 18, 2026
The Google Home Speaker features a sustainable design with a custom 3D-knit textile and is available in Hazel and Porcelain colors. It includes a light ring underglow to indicate its status and a microphone mute toggle for privacy. The device assists with planning trips, providing kitchen help, and recommending entertainment. It is available for pre-order in Australia and New Zealand through various retailers. A purchase includes a 6-month trial of the Google Home Premium subscription, which is required for certain features. The device requires a Google Home app, Wi-Fi, and an internet connection.
AppWizard
June 17, 2026
Guild Wars 3 has been announced, with beta testing scheduled for 2027. ArenaNet has outlined core philosophies for the game: it will have no subscriptions, no pay-to-win mechanics, respect players' time, and aim to evolve the MMO genre. The game seeks to create an accessible experience for both new and veteran players, acknowledging the busy lives of its audience.
Winsage
June 17, 2026
The annual fee for Microsoft 365 starts at .99, and Windows 10 has not received security updates since 2025. A current offer allows the purchase of Windows 11 Pro and a lifetime license for Microsoft Office for .97, down from 8.99, but this offer expires on June 28 at 11:59 p.m. PT. Windows 11 Pro includes features like remote desktop access, BitLocker encryption, and an AI assistant called Copilot. The Microsoft Office Professional 2021 package includes applications such as Word, Excel, PowerPoint, Outlook, Teams, OneNote, Publisher, and Access.
Search