NewApp Digest
search bot

Transitioning

How Five PostgreSQL Optimizations Sped Up Our Dashboard
Tech Optimizer
June 20, 2026

How Five PostgreSQL Optimizations Sped Up Our Dashboard

The dashboard operates on a Django monolith with PostgreSQL and is transitioning to ClickHouse for denormalization. The initial p50 metric was 0.7 seconds, but the p95 was 8 seconds, which was reduced to 1 second. Observability tools were established to monitor performance, and slow HTTP requests were identified using OpenTelemetry traces. Optimization techniques included late joining, asynchronous counting, creating a PostgreSQL replica for read operations, and improving full-text search. Denormalization was explored to enhance filtering performance by creating composite indexes. The production stack was upgraded to PostgreSQL 18, which provided incremental performance improvements. The final p95 value achieved was 1 second, below the target of 3 seconds.
silver Android smartphone
Winsage
June 19, 2026

Microsoft’s new Outlook now supports offline email attachments

Microsoft is transitioning users from the traditional Outlook app for Windows 11 to a newer web-based version. The latest update allows users to add email attachments while offline, with emails being sent automatically once the device reconnects to the internet. This feature has been in testing since October 2025 and is now rolling out to a broader audience. Despite these enhancements, many users still prefer the classic Outlook app or the web version.
3 simple Android Auto Automations that helped me stop wasting time in my driveway
AppWizard
June 19, 2026

3 simple Android Auto Automations that helped me stop wasting time in my driveway

The user transitioned from CarPlay to Android Auto in their Ioniq 5 EV and has been exploring sideloading video and web browsing applications to enhance their long drive experience. They have faced issues with Google's Automations since the launch of Gemini, with many not functioning properly and difficulties in creating custom Automations. Despite these challenges, they found value in using Automations for tasks like closing their garage door upon entering the vehicle and modifying stock Automations to manage smart lights efficiently. They also highlighted the effectiveness of Google's stock Good Morning routine, which provides weather updates, jokes, calendar recaps, and news summaries upon command.
Microsoft modernized almost everything in Windows 11, but this 90s feature quietly lives on
Winsage
June 18, 2026

Microsoft modernized almost everything in Windows 11, but this 90s feature quietly lives on

Screensavers were originally designed to prevent burn-in on CRT monitors in the 1980s and 1990s, but evolved into a form of personalization with options like 3D Text and flying toasters. By 2026, the necessity for screensavers has diminished due to modern displays' ability to avoid burn-in and Windows 11's power management features. Screensavers are now mostly used for personal photo slideshows or basic visuals, accessible through Settings > Personalization > Lock screen > Screen saver, with options including 3D Text, Bubbles, Mystify, Photos, and Ribbons. Microsoft has shifted focus to AI and performance improvements, leaving screensavers as a legacy feature that is not actively developed. There is potential for screensavers to be reimagined as a modern ambient mode that enhances the idle experience by displaying personal photos or useful information. Currently, Windows 11 lacks a cohesive system that integrates various idle features, leading to a static or blank display when users step away.
Telegram ban in India: 6 messaging apps to switch to right now
AppWizard
June 16, 2026

Telegram ban in India: 6 messaging apps to switch to right now

WhatsApp is the predominant messaging platform in India, known for its extensive user base and robust features, including end-to-end encryption, voice and video calls, communities for large group interactions, document sharing, status updates, and business messaging. It provides a seamless transition for users coming from Telegram due to its intuitive interface and widespread acceptance, allowing easy adaptation without extensive onboarding.
Samsung MAX VPN goes offline today, leaving Android users searching for alternatives
AppWizard
June 15, 2026

Samsung MAX VPN goes offline today, leaving Android users searching for alternatives

Samsung MAX VPN has officially reached its end of life as of June 15, 2026, leaving over 50 million users without its privacy and data-saving features. The app, which was designed to mask IP addresses and compress mobile data, will no longer function as intended unless uninstalled. Users are encouraged to seek third-party VPN alternatives for online security, as the app will remain on devices but will not provide any services. The Google Play Store offers numerous highly rated third-party VPN applications, including free options, and users should review logging policies and server locations to maintain privacy.
When Windows 7 Arrived in Japan, It Came Printed on Toilet Paper
Winsage
June 14, 2026

When Windows 7 Arrived in Japan, It Came Printed on Toilet Paper

On October 22, 2009, Japan launched Windows 7, accompanied by a unique promotional item: a roll of toilet paper featuring Windows 7 branding and details about its enhancements. This marketing strategy was similar to the previous promotion for Windows Vista Service Pack 1. The toilet paper included messages about Windows 7's speed, security, and compatibility improvements, with sections detailing faster startup times, enhanced memory management, a streamlined user interface, and security features like the Action Center and BitLocker To Go. Networking capabilities were improved with HomeGroup, and Windows Media Center expanded its functionality. The design of the promotional toilet paper allowed users to revisit key points easily, and some versions mimicked Windows software boxes. This initiative was driven by local retailers, reflecting Japan's trend of quirky promotions in the electronics retail sector.
I'm sad, I'm angry, I'm interested: Destiny's final cutscenes are a painful end to a new saga cut short
AppWizard
June 13, 2026

I’m sad, I’m angry, I’m interested: Destiny’s final cutscenes are a painful end to a new saga cut short

Destiny 2's latest update, Monuments of Triumph, concludes the decade-long Light and Darkness saga with The Final Shape and introduces a new narrative arc called the Fate saga, starting with The Edge of Fate. This update features hidden cutscenes that provide insights into the characters' journeys and the future of the game. One cutscene highlights Zavala reflecting on his journey and entrusting the future to Ikora, while the second cutscene presents Lodi in the Dark Forest, hinting at a confrontation between Dark and Light and introducing the Winnower, an extradimensional god. The update showcases improved cinematic quality and leaves players with a mix of intrigue and sadness, suggesting potential for future storytelling in the Destiny universe.
Search