NewApp Digest
search bot

table

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.
Windows K2 tracker: Keeping tabs on Microsoft's promises to fix Windows 11
Winsage
April 29, 2026

Windows K2 tracker: Keeping tabs on Microsoft’s promises to fix Windows 11

Microsoft has outlined a roadmap for Windows 11 as part of its Windows K2 initiative, focusing on enhancements to user experience by addressing longstanding issues and responding to user feedback. A table detailing Microsoft's commitments includes the following: - Taskbar Repositioning: Allow taskbar at top, left, and right - Status: Preview expected imminently. - Taskbar Customization: More personalization options including smaller taskbar - Status: Preview expected this year. - AI Integration: Reduce unnecessary Copilot entry points in various tools - Status: Copilot in Snipping Tool removed; Notepad Copilot button replaced with AI writing tools. - Windows Update Control: Skip updates during setup; restart/shutdown without forced updates; pause longer - Status: Rolling out now. - File Explorer: Faster launch, reduced flicker, smoother navigation - Status: Work in progress; faster launch times already in testing. - Widgets: Quieter defaults, more control, better personalization - Status: No preview yet. - Windows Insider Program: Simpler channels, clearer definitions, higher-quality builds - Status: Rolling out now. - Feedback Hub: Largest redesign yet - Status: Rolling out now. - System Performance: Reduced resource usage, improved responsiveness - Status: Work underway; some early improvements noted. - WinUI 3 Migration: Move more Windows experiences to WinUI 3 - Status: In progress; Start menu migration confirmed but not yet shipping. - File Explorer Fundamentals: Lower latency for search, navigation, context menus - Status: Committed, not yet being previewed. The Windows K2 initiative aims to improve performance, reliability, and craftsmanship in Windows 11, addressing user feedback to enhance competitiveness against macOS and Linux. The project seeks to reshape internal perspectives on product development to be more user-centric. Regular updates will reflect the latest progress.
Get 10 Steam Deck-friendly games worth $182 for just $8.55 with Fanatical’s new Adrenaline Bundle
AppWizard
April 29, 2026

Get 10 Steam Deck-friendly games worth $182 for just $8.55 with Fanatical’s new Adrenaline Bundle

Fanatical has launched the Adrenaline bundle, allowing gamers to customize their gaming experience by selecting from various titles. The pricing structure rewards gamers for selecting multiple games: three to four games cost each, while five or more reduce the cost to [openai_gpt model="gpt-4o-mini" prompt="Summarize the content and extract only the fact described in the text bellow. The summary shall NOT include a title, introduction and conclusion. Text: Fanatical continues to solidify its reputation as a premier destination for gamers seeking value through its latest offering, the Adrenaline bundle. This innovative bundle allows players to curate their gaming experience by selecting from a variety of titles, making it an attractive option for those looking to expand their libraries without breaking the bank. What does the bundle offer? The pricing structure of the Adrenaline bundle is designed to reward gamers for selecting multiple titles. For example, choosing three to four games will set you back each, while opting for five or more reduces the cost to just [cyberseo_openai model="gpt-4o-mini" prompt="Rewrite a news story for a business publication, in a calm style with creativity and flair based on text below, making sure it reads like human-written text in a natural way. The article shall NOT include a title, introduction and conclusion. The article shall NOT start from a title. Response language English. Generate HTML-formatted content using tag for a sub-heading. You can use only , , , , and HTML tags if necessary. Text: PC Guide is reader-supported. When you buy through links on our site, we may earn an affiliate commission. Read More Table of Contents Fanatical is one of the best platforms available to you when it comes to game bundles. Each bundle is designed to help gamers expand their game libraries on a tight budget, and the same can be said for its newly launched Adrenaline bundle. Just like most of the other bundles available on Fanatical, this one boasts a build-your-own theme. This means it is fully customizable, thanks to which you can hand-pick the selection of games you want inside the bundle instead of paying for everything. The new Adrenaline bundle is great for regular PC players, and it’s also full of Steam Deck-compatible games. Prices and savings subject to change. Click through to get the current deal prices. Custom URL Learn more --> What does the bundle offer? The total price of the bundle will also depend on the number of games selected. For instance, three to four games will cost $1 each, while selecting five or more will bring it down to $0.95 per game. If you opt for all 10 Steam Deck-compatible games included in the bundle, you’ll have to pay only $8.55, which is 95% less than the original value of $181.91. In any case, here’s a complete list of games included in Fanatical’s Adrenaline bundle, along with their Steam Deck compatibility status. There were a few more games in the bundle, but we didn’t include them on our list as their compatibility was unknown. GameSteam Deck compatibilityOriginal priceThe Darkest TalesVerified$19.99Sniper Elite V2 RemasteredPlayable$34.99Afterimage Deluxe EditionVerified$29.99POSTAL: Brain DamagedVerified$19.99Aaero2Verified$14.99Hammerwatch IIPlayable$24.99HYPER DEMONPlayable$14.99StormEdgeVerified$14.99Xmas ApocalypsePlayable$6.99 As you can see in the table above, most of the games are verified on the Steam Deck, so they should run smoothly right out of the box. The ones marked as Playable should also run fine, but an optimal experience may involve making a few settings tweaks along the way. Either way, you should be in a nice handheld experience. In any case, if you don’t mind buying game bundles outside of Fanatical, we recommend checking out Humble’s Speak to the Manager bundle. This one comes packed with $236 worth of 8 Steam Deck-friendly games, and you can score them for only $12. " temperature="0.3" top_p="1.0" best_of="1" presence_penalty="0.1" ].95 per game. If you decide to go all in and select all ten Steam Deck-compatible games, the total comes to a mere .55—an impressive 95% discount off the original value of 1.91. Here’s a detailed look at the games included in Fanatical’s Adrenaline bundle, along with their compatibility status for the Steam Deck: Game Steam Deck Compatibility Original Price The Darkest Tales Verified .99 Sniper Elite V2 Remastered Playable .99 Afterimage Deluxe Edition Verified .99 POSTAL: Brain Damaged Verified .99 Aaero2 Verified .99 Hammerwatch II Playable .99 HYPER DEMON Playable .99 StormEdge Verified .99 Xmas Apocalypse Playable .99 As illustrated in the table, a majority of the games are verified for compatibility with the Steam Deck, ensuring a seamless gaming experience right out of the box. The titles marked as "Playable" are also expected to perform adequately, although some minor adjustments may enhance your gameplay. Regardless, players can anticipate an enjoyable handheld experience. For those open to exploring options beyond Fanatical, the Humble Bundle's "Speak to the Manager" package is worth considering. This bundle features eight Steam Deck-friendly games valued at 6, available for the enticing price of just ." max_tokens="3500" temperature="0.3" top_p="1.0" best_of="1" presence_penalty="0.1" frequency_penalty="frequency_penalty"].95 per game. If all ten Steam Deck-compatible games are selected, the total price is .55, which is a 95% discount from the original value of 1.91. The bundle includes games such as "The Darkest Tales," "Sniper Elite V2 Remastered," and "Afterimage Deluxe Edition," with most games verified for Steam Deck compatibility.
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.
Ball x Pit has a new update because who needs free time anyway?
AppWizard
April 27, 2026

Ball x Pit has a new update because who needs free time anyway?

The Shadow Update for Ball x Pit introduces two new characters, The Tiptoer and The Tunneller, along with four new passive abilities, 11 new balls, and a guildhall for players to build. The Tiptoer can evade detection by enemies, while The Tunneller can fire balls that wrap around the screen's edges. The new balls include one that manipulates time, one that immobilizes enemies, and one that allows for random teleportation. The update also features the Full Metal Rapier passive ability, which scales damage based on the number of elements on screen, and the Arrow of Fate, which grants projectile immunity and releases smaller balls upon being hit. The update is available for free on Steam and adds 18 new elements, creating 88 combinations of characters, passives, and balls.
After a slow start, Last Flag developer says you can't become the next big hit just by ticking boxes: 'It’s a slippery slope'
AppWizard
April 25, 2026

After a slow start, Last Flag developer says you can’t become the next big hit just by ticking boxes: ‘It’s a slippery slope’

Night Street Games, co-founded by Dan and Mac Reynolds, launched a 5v5 multiplayer shooter called Last Flag, inspired by the capture the flag game mode. The game has received positive reviews on Steam and is priced affordably, but it debuted with fewer than 600 concurrent users, which has since decreased. Mac Reynolds emphasized the studio's focus on creative integrity over chasing trends, aiming to provide a unique gaming experience. Despite the commitment to a creative vision, the game faces challenges in attracting a substantial player base, similar to other recent titles that struggled to maintain engagement. Reynolds believes success should not be solely measured by player numbers, highlighting the team's pride in their work.
Search