tables Archives

Tech Optimizer

April 11, 2026

Database Branching in Postgres: Git-Style Workflows with Databricks Lakebase

Database branching is a modern approach that addresses the limitations of traditional database management in development workflows. Unlike conventional database copies, which require significant time and resources to duplicate data and schema, database branching allows for the creation of isolated environments that share the same underlying storage. This method utilizes a copy-on-write mechanism, enabling branches to be created in seconds regardless of database size, with storage costs tied only to the changes made. Key features of database branching include: - Branch creation time: Seconds, constant regardless of database size. - Storage cost: Proportional to changes only, not the total data size. - Isolation: Each branch has its own Postgres connection string and compute endpoint. - Automatic scaling: Idle branches can scale compute to zero, incurring costs only when active. The architecture supporting this approach separates compute from storage, allowing multiple branches to reference the same data without conflict. This design facilitates time travel capabilities, enabling branches to be created from any point in the past for instant recovery and inspection. Database branching unlocks new workflows, such as: - One branch per developer, providing isolated environments for each engineer. - One branch per pull request, automating branch creation and deletion tied to PRs. - One branch per test run, provisioning fresh databases for each CI pipeline execution. - Instant recovery from any point in time within a designated restore window. - Ephemeral environments for AI agents, allowing programmatic database provisioning. Databricks Lakebase offers this database branching capability, transforming the database from a bottleneck into a streamlined component of the development process.

Winsage

April 10, 2026

Microsoft begins removing Copilot from Windows 11, starting with Notepad, Snipping Tool

Microsoft has removed the Copilot branding from the Notepad app for Windows Insiders, replacing it with a "Writing tools" icon in the latest update (version 11.2512.28.0). Despite the removal of the logo, AI functionality remains intact, and users can disable the feature through the Settings menu under "Advanced Features." The Snipping Tool has also eliminated the Copilot button and currently shows no AI integration. Microsoft is scaling back unnecessary Copilot integration in various apps, including Notepad and Snipping Tool, while still maintaining underlying AI capabilities.

Tech Optimizer

April 8, 2026

PostgreSQL logical replication: How to replicate only the data that you need

Many organizations using PostgreSQL face challenges in replicating data across different logical databases while controlling shared information. PostgreSQL 15 introduces native logical replication with column-level and row-level filtering within publications, allowing precise control over data transfer between PostgreSQL databases. Logical replication operates on a publish-subscribe model, where the source database logs changes to the Write-Ahead Log (WAL) and applies publication filters to transmit only the relevant data to the target database. Two filtering modes are available: column-level filtering allows users to specify which columns to replicate, while row-level filtering uses WHERE clauses to determine which rows to include. Both filtering modes can be combined in a single publication. The SQL syntax for creating publications and subscriptions is consistent across various PostgreSQL environments, with specific configurations required for enabling logical replication. Use cases for logical replication include multi-tenant SaaS data isolation, regional data distribution for ecommerce, PCI DSS compliance in financial services, development and testing environments, and retail inventory management. Prerequisites for implementing logical replication include using PostgreSQL 15 or later, ensuring network connectivity, having a user with replication privileges, enabling logical replication on the source instance, and monitoring WAL retention. Logical replication has limitations, such as the need for a replica identity for UPDATE and DELETE operations, the non-replication of DDL changes and sequences, and potential performance overhead during initial synchronization and ongoing replication. After testing, it is advisable to clean up by removing replication resources to prevent unnecessary costs.

AppWizard

April 8, 2026

Minecraft village features, loot, trades, and how to find them

Minecraft villages are important locations in the game, serving as resource-rich hubs for players. They can be found by looking for flickering lights at dusk or scanning for house silhouettes during the day. Players can also use specific seeds to locate villages directly. Villages contain various buildings, including libraries and cleric temples, which provide valuable resources like bookshelves and brewing stands. Villagers have specific trades that can be beneficial, such as: - Fletcher: Ideal for acquiring emeralds. - Librarian: Source of enchanted books. - Cartographer: Offers maps to mansions and oceans. Villagers can adopt professions when a profession block is placed nearby, except for Nitwits. Once traded with, a villager's trades remain fixed unless their profession block is removed. A list of villagers and their corresponding profession blocks includes: - Armorer - Blast Furnace - Butcher - Smoker - Cartographer - Cartography Table - Cleric - Brewing Stand - Farmer - Composter - Fisherman - Barrel - Fletcher - Fletching Table - Leatherworker - Cauldron - Librarian - Lectern - Mason - Stonecutter - Shepherd - Loom - Toolsmith - Smithing Table - Weaponsmith - Grindstone The fletcher is a good starting point for earning emeralds by trading sticks. Players can create and repeatedly break a fletching table to encourage trades. The librarian is crucial for obtaining enchanted books, with sought-after enchantments like Mending and Fortune linked to specific biomes. The cartographer offers maps to Woodland Mansions and Trial Chambers, which are essential for exploration.

Winsage

April 7, 2026

Notepad (25H2)

Microsoft has transformed its Notepad text editor in Windows 11, introducing features such as a tabbed user interface, basic session state management, a "Recent files" option, and AI-driven writing tools. Notepad now supports Markdown markup language for light formatting and includes customizable settings for themes, fonts, document opening preferences, and the ability to disable certain features. Users can access AI writing tools through a Copilot button, which requires a Microsoft account and an active Microsoft 365 subscription. The classic Notepad version is still available, allowing users to revert to the previous interface, although it cannot be set as the default app for text files.

Winsage

April 7, 2026

Get Microsoft Office Professional Plus for Windows at $17 or Mac for $25 (Up to $229 value)

Microsoft Office Professional Plus 2019 is available for Windows users at .97 and for Mac users at .97, down from the regular price of 9.99. The suite includes Word, Excel, PowerPoint, Outlook, OneNote, Teams Classic (Mac only), Publisher (Windows only), and Access (Windows only). It is compatible with Windows 10 and 11, and macOS 14 Sonoma, macOS 15 Sequoia, and macOS 26 Tahoe. Users are advised to disable auto-update to avoid prompts for upgrading to the 2021 version. Prices are subject to change.

Tech Optimizer

April 6, 2026

36 Malicious npm Packages Exploited Redis, PostgreSQL to Deploy Persistent Implants

Cybersecurity researchers have discovered 36 malicious packages in the npm registry that impersonate Strapi CMS plugins. These packages exploit Redis and PostgreSQL, deploy reverse shells, harvest credentials, and establish persistent implants. Each package consists of three files—package.json, index.js, and postinstall.js—without descriptions or repositories, and all use version 3.6.8 to mimic legitimate Strapi plugins. The malicious packages follow a naming convention starting with "strapi-plugin-" and were uploaded by four accounts within 13 hours. The identified packages include names like strapi-plugin-cron, strapi-plugin-database, and strapi-plugin-server. The malicious code is embedded in the postinstall script, executing automatically upon installation with the same privileges as the user. The payloads evolve from exploiting Redis for remote code execution to attempting direct PostgreSQL database exploitation and deploying persistent implants for remote access. The campaign appears to target cryptocurrency platforms, as indicated by the focus on credential theft and digital assets. Users of these packages are advised to assume compromise and rotate credentials. This incident reflects a broader trend of supply chain attacks in the open-source ecosystem, with recent examples including credential exfiltration payloads in GitHub repositories and compromised GitHub Actions workflows. Group-IB reported that software supply chain attacks are increasingly reshaping the cyber threat landscape, targeting trusted vendors and open-source software to gain access to downstream organizations.

AppWizard

April 2, 2026

Minecraft’s April Fools update makes inventory management even worse

On April 1, Mojang released a fictional Java Edition snapshot called the Herdcraft Update, which humorously eliminated the inventory system and introduced a mechanic where players could herd blocks and items like livestock. This update allowed players to command blocks to follow them and use them in crafting grids on the ground. The announcement included absurd patch notes and a FAQ section about the herding mechanic. Community reactions were mixed, with some appreciating the creativity of the April Fools' update while others expressed disappointment that it did not address the actual inventory issues in a meaningful way. The Herdcraft Update continues Mojang's tradition of using April 1 to humorously critique its own game.

AppWizard

April 2, 2026

Everything we know about Sulfur Cube in Minecraft

The upcoming release of Chaos Cubed for Minecraft introduces a new underground biome and a creature called the Sulfur Cube. The Sulfur Cube is a passive, bucketable mob found in the Sulfur Caves biome, immune to fall damage, and can split into smaller cubes upon impact. These smaller cubes can grow larger over time when nurtured with golden dandelions. The Sulfur Cube can absorb various blocks, including all wood variants, stone, coral, slime, honey, sculk, froglight, resin, ore, metallic blocks, ice, concrete, sulfur, and cinnabar, but cannot consume walls, stairs, slabs, or fences. Once it absorbs a block, it becomes impervious to damage from player attacks and most mobs, instead being launched away from the attack. Players can retrieve the absorbed block using shears. The Sulfur Cube is expected to debut in the second quarter of 2026, following its appearance in the recent Minecraft Bedrock beta.

AppWizard

April 1, 2026

Latest Steam Freebie Shames You And Your Backlog

Steam users often accumulate a large collection of unplayed games due to enticing sales and discounts. BOXROOM is a game that functions as a design simulator, allowing players to curate a virtual bedroom and import their Steam library, turning digital games into physical boxes for organization. This feature encourages players to confront the reality of their unplayed titles. BOXROOM is set for full release in the second quarter of the year, with a free demo currently available for players to explore.