NewApp Digest
search bot

managing

Inside the Architecture of an MCP Server for PostgreSQL
Tech Optimizer
April 30, 2026

Inside the Architecture of an MCP Server for PostgreSQL

The Model Context Protocol (MCP) serves as a standard interface between large language models (LLMs) and external systems like PostgreSQL, emphasizing the importance of control over mere connectivity. An MCP server must act as a mediation and policy layer, enforcing security boundaries and ensuring that connections default to read-only. It should validate AI-generated SQL as untrusted input, encapsulate queries within transactions, and apply execution-time controls. The server must separate query generation from execution approval to manage operational costs and enforce guardrails on query types, such as limiting the number of rows returned. Token efficiency is crucial, with design considerations for compact data representation and schema introspection. In production, connection management is vital to prevent data leakage among multiple AI agents, and observability through logging executed queries and metadata is necessary for debugging and compliance. Long-running sessions require support for paginated responses to manage context effectively. Overall, the MCP server must integrate security, query safety, token efficiency, and observability into its design from the outset.
S&box makes nearly $1 million on launch day, and yes there are problems but that's okay: 'We love it when things break because then we get to fix them'
AppWizard
April 29, 2026

S&box makes nearly $1 million on launch day, and yes there are problems but that’s okay: ‘We love it when things break because then we get to fix them’

The gaming community has mixed reactions to the release of S&box, the successor to Garry's Mod, with some players dissatisfied and others hopeful for improvement. Facepunch Studios, the developer, reported technical challenges during the launch, including backend issues and a self-inflicted DDoS. Despite these hurdles, they remain optimistic about S&box's future and the role of AI in programming education. The game will not include an AI Assistant button, but Facepunch aims to enhance the discovery algorithm for quality content. They have chosen a forward rendering technique for better visual performance. Financially, S&box generated nearly million on its first day, leading Facepunch to double its Play Fund to million. A patch for S&box has been released to improve the game based on player feedback.
Google Photos may soon be searchable from your Pixel launcher — and that's just the start
AppWizard
April 29, 2026

Google Photos may soon be searchable from your Pixel launcher — and that’s just the start

Google is enhancing the Pixel launcher to allow users to search their photo libraries directly from it, as indicated by the latest version of Google Photos (update 7.74.0.906046556). This integration will improve the image-search experience and may extend to other apps, including Google Workspace apps like Docs and Drive, based on findings from the Android 17 Beta. Additionally, a new app package named com.google.android.apps.pixel.launcherconnector suggests a framework for the search bar to interface with various Android apps.
Microsoft is changing the rules of the game: updates are no longer forced in Windows 11
Winsage
April 29, 2026

Microsoft is changing the rules of the game: updates are no longer forced in Windows 11

Windows 11 has introduced a new update management model that allows users to pause updates indefinitely, transforming the previous 35-day limit into a flexible option. This change addresses user frustrations regarding unexpected reboots and system instability caused by updates. Users can now choose to restart or shut down their systems without automatic updates being installed. This adjustment aligns with Microsoft's strategy to enhance user autonomy, although the company warns that neglecting updates can increase security vulnerabilities. The new features are currently available in test builds, with a wider rollout expected soon.
Microsoft Says Defender Antivirus Is Good Enough. I Say Nope
Tech Optimizer
April 29, 2026

Microsoft Says Defender Antivirus Is Good Enough. I Say Nope

Microsoft Defender Antivirus, originally launched in 1993 as Microsoft Anti-Virus for MS-DOS, has evolved over the years but historically struggled with effective malware protection. Recent improvements have led to better performance in independent lab tests. Microsoft claims that Defender's built-in capabilities are sufficient for protection against various threats, but it acknowledges that third-party antivirus solutions may be necessary for users with multiple devices. Defender's phishing protection is limited to the Edge browser, and it lacks many features found in competing antivirus products, such as advanced scam protection and a user-friendly interface. While Defender offers basic protection, it may not meet the needs of most users in today's digital landscape.
Total War Warhammer 3 overhauls mod manager, so you'll no longer have to fight Chaos before even starting the game
AppWizard
April 29, 2026

Total War Warhammer 3 overhauls mod manager, so you’ll no longer have to fight Chaos before even starting the game

Total War: Warhammer 3 has received a significant update to its mod manager, released in late 2025, aimed at improving the user experience for modding. Enhancements include faster mass mod activation, reduced startup times for players with many mods, improved search filters for finding specific mods, clearer tooltips, and fixes for bugs related to mod profiles and text legibility. Players can still create 'mod profiles' for easier management of their favorite mods. The update encourages players to explore new mods and provide feedback to the developer, Creative Assembly.
I investigated Windows 11's massive 5GB monthly .msu updates. AI is only part of the problem.
Winsage
April 28, 2026

I investigated Windows 11’s massive 5GB monthly .msu updates. AI is only part of the problem.

Windows 11 updates have significantly increased in size, with monthly cumulative updates often exceeding 4GB and some approaching 5GB. One update can expand to nearly 9GB when extracted. Microsoft has shifted to delivering Latest Cumulative Updates (LCUs), which include all previous fixes, leading to larger update sizes over time. The introduction of Checkpoint Cumulative Updates aims to reduce this growth by establishing periodic baselines, but the effectiveness has been mixed. The May 2025 cumulative update saw a size increase from approximately 6.5GB to nearly 9GB, with new MSIX files related to semantic search and on-device AI contributing to this growth. Windows Update uses applicability logic to minimize download sizes for users, but enterprises must download full packages, resulting in increased storage costs. The average yearly storage cost for enterprises rose from about 11 GB in 2024 to 52 GB by 2026. Users can check their actual download sizes through the Windows Update settings and Event Viewer logs.
Constructive Open Sources Agentic DB, the Postgres Memory Layer for AI Agents
Tech Optimizer
April 28, 2026

Constructive Open Sources Agentic DB, the Postgres Memory Layer for AI Agents

Constructive has released agentic-db, an open-source Postgres database aimed at improving AI agents with features like persistent memory, structured knowledge, and hybrid retrieval. This database allows for efficient searching, filtering, and ranking of information, addressing inefficiencies associated with traditional markdown file storage. Key features of agentic-db include long-term memory, conversation tracking, a versioned registry for skills and tools, rules and policies for governance, task orchestration, and runtime observability. It is delivered as a single installable Postgres schema, indexed for multiple retrieval modes, and supports integration with various AI assistants through generated Agent Skills and CLIs. agentic-db is available under the MIT license for local use, with a cloud offering in development for secure, scalable solutions. Developers can access it on npm and GitHub.
Microsoft Adds Policy to Let IT Admins Uninstall Copilot From Enterprise Windows 11 Devices
Winsage
April 27, 2026

Microsoft Adds Policy to Let IT Admins Uninstall Copilot From Enterprise Windows 11 Devices

Microsoft has introduced a policy allowing IT administrators to remove the Microsoft Copilot app from managed enterprise devices. This "Remove Microsoft Copilot App" policy will be available as a Policy CSP and Group Policy after the April 2026 Windows security updates for Windows 11 devices on the 25H2 update, specifically for Enterprise, Professional, and Education editions. The policy will uninstall Copilot under certain conditions: both Microsoft 365 Copilot and Microsoft Copilot must be installed, the user must not have manually installed the app, and the app must not have been launched in the past 28 days. Administrators can enable the policy through the Group Policy Editor or configure it via Microsoft Intune and SCCM after the April 2026 updates. The policy aligns with Microsoft's recent changes in managing Copilot, including the cessation of automatic installations and the cancellation of plans to integrate Copilot into system notifications and other features. The policy was initially available to Windows Insiders in January before becoming generally accessible in April 2026.
Search