workflows Archives

Winsage

May 4, 2026

You Can Get Windows 11 Pro on Sale for A$18 Right Now

Windows 11 Pro is currently available for a reduced price of A, down from A6. The operating system includes features such as Windows Copilot, a redesigned user interface, new productivity tools, remote desktop access, and robust security features like TPM 2.0, Smart App Control, biometric login options, BitLocker encryption, Azure AD integration, Hyper-V, and Windows Sandbox. The upgrade is available for one PC that meets the minimum system requirements: a 1GHz processor, 4GB of RAM, and 64GB of hard disk space.

Tech Optimizer

May 3, 2026

EDB Releases WarehousePG Postgres Petabyte-Scale Warehouse

On March 31, 2026, EDB launched WarehousePG, an open-source data warehouse built on Postgres, designed for petabyte-scale analytics and in-database AI. It features real-time data ingestion, advanced vector processing for complex queries, and supports existing SQL workflows. Organizations migrating from proprietary data warehouses can achieve up to a 58% reduction in total cost of ownership. WarehousePG supports hybrid deployments and addresses data sovereignty concerns, allowing compliance with local regulations.

Tech Optimizer

May 3, 2026

TigerFS Mounts PostgreSQL As Transactional Filesystem

TigerFS is an open-source project introduced on April 4, 2026, by Michael Freedman, the CTO of TigerData. It allows users to mount a PostgreSQL database as a POSIX-like filesystem, storing database rows as individual files while ensuring ACID guarantees. Key features include an MIT license, support for both file-first and data-first workflows, mounting options using FUSE on Linux and NFS on macOS, and integration with standard Unix tools.

Tech Optimizer

May 3, 2026

Absurd Delivers Durable Workflows On Postgres

On April 4, 2026, Earendil reported on Absurd, an execution system built solely on Postgres, which has been in production for five months and has received several updates. Recent developments include the introduction of Software Development Kits (SDKs) for TypeScript, Python, and an experimental Go SDK, as well as a command-line interface (CLI) called absurdctl and a Habitat dashboard for monitoring and management. Absurd's architecture is resilient, utilizing a checkpointed step model for durable agent workflows, but currently lacks features like partitioning and built-in push scheduling, focusing on reliability and simplicity.

Winsage

May 2, 2026

Windows finally fixed File Explorer’s most annoying quirk, and it only took 20 years

Windows 11's latest builds (26100.8313 and 26200.8313) have improved folder view consistency in File Explorer, ensuring that user-configured settings persist regardless of how a folder is accessed. This update eliminates the need for registry tweaks. Additionally, the updates enhance File Explorer's speed and performance, resolve a white flash issue in dark mode, introduce a "preview anyway" button for the preview pane, and add support for four new archive formats. These changes are currently available in the Release Preview channel and will soon be rolled out to regular users.

Winsage

May 1, 2026

Windows quality update: Progress we’ve made since March

The Windows Insider Program is undergoing changes to improve transparency and user control. Two main channels, Experimental and Beta, are being introduced, with the Beta channel eliminating controlled feature rollouts. Users will have the ability to select features in the Experimental channel and switch between channels more easily. Updates to the Feedback Hub are aimed at enhancing user experience. Windows updates will now be consolidated into a single monthly restart, providing users with more flexibility. AI features are being refined, with a focus on intentional integration. File Explorer is receiving architectural improvements for better performance, and there will be more control over widgets and notification settings. System performance enhancements include memory optimization and improved app launch responsiveness. Upcoming features include Taskbar customization, and the team is engaging with Insiders in various cities for feedback.

Tech Optimizer

May 1, 2026

Ghost: A Database for Our Times?

Ghost, developed by ghost.build, is an "agent-first" Postgres database platform designed for AI-related applications, allowing developers and AI agents to create, fork, inspect, query, manipulate, and delete databases easily. It is free to use and hosted on Ghost’s Cloud infrastructure, making it suitable for testing, prototyping, and disposable database environments. Users can create databases on demand, execute SQL queries, and discard them when finished, contrasting with traditional managed databases. Ghost integrates with AI tools like Codex and Claude Code, providing direct database management capabilities through its MCP server. To install Ghost, users need a supported coding agent and a GitHub account. Installation commands differ for Linux, macOS, and Windows. After installation, users can verify the Ghost MCP server and interact with it through their coding agents. Examples of using Ghost include creating a sales data database, utilizing Ghost CLI commands, and experimenting with databases through AI agents. Ghost allows for rapid database manipulation and is ideal for proofs of concept and experimentation, although caution is advised before using it for production data.

Winsage

May 1, 2026

Microsoft brings a Linux-style window trick to Windows 11 via PowerToys, and I can’t go back

Microsoft's PowerToys version 0.99 introduces two new tools: Grab And Move and Power Display, along with enhancements to the Command Palette Dock. Grab And Move allows users to reposition application windows by holding the Alt key and dragging anywhere on the window, facilitating easier window management. Users can customize the activation key and toggle the feature off during gaming sessions. There are also options to exclude specific applications from using this feature. Power Display enables users to manage monitor settings directly from the system tray, including brightness, contrast, volume, rotation, and color temperature adjustments. It supports multi-monitor setups with DDC/CI standards and includes a Profiles option for saving specific monitor settings. The Command Palette Dock now features a compact mode and customization options for pinned commands, improving user accessibility and screen space utilization.

Tech Optimizer

May 1, 2026

Backstage Ditches Postgres for Databricks Lakebase

The divide between operational and analytical databases is diminishing, as evidenced by Databricks integrating Spotify's Backstage with its Lakebase, transitioning from PostgreSQL to a unified data platform. Lakebase now offers a serverless PostgreSQL interface within Databricks, allowing Backstage to operate without awareness of the underlying changes. The integration involved updating configurations and addressing authentication challenges using OAuth JWTs. The integration transforms the database development lifecycle by enabling near-instant database branching through Lakebase's copy-on-write architecture, allowing developers to focus on testing changes rather than safety. Branching creates a pointer to existing data, making the operation instantaneous. Point-in-Time Recovery (PITR) allows for quick restoration of data, demonstrated by a recovery process that took less than four seconds. The goal is to integrate database branching into developer workflows seamlessly, making it automatic. This change could enhance developer productivity by allowing live data testing from the start, eliminating the need for mock objects, and resolving common issues related to staging environments. The traditional constraints of slow and costly database copies will become obsolete, prompting teams to reconsider how much time they spend on workarounds for now-nonexistent constraints.

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.