Terraform 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.

AppWizard

April 5, 2026

Tarn Adams, co-creator of Dwarf Fortress, has over 1,400 hours in Factorio and is currently obsessed with terraforming games: ‘Dwarf Fortress just doesn’t accommodate a full-on sci-fi thing’

Tarn Adams is the co-founder of Bay 12 Games and is best known for co-creating Dwarf Fortress, which was released in 2006 and is celebrating its 20th anniversary. He has recently been playing The Planet Crafter, a terraforming game, and has logged 1,454.5 hours in Factorio, a factory-building simulation. Adams does not have a single game he would never uninstall but frequently plays Caves of Qud. He uses Ableton, a music sequencer, as essential non-gaming software. His desktop is about half full with various folders and .txt files, including a nostalgic folder for BASIC games from the '80s.

AppWizard

February 28, 2026

5 Best Video Games Like Terraria

"Terraria" fans have several similar gaming options. 1. Minecraft: Launched in 2011, it features procedurally generated worlds made of cubes, allowing players to gather resources, craft items, and engage in both cooperative and competitive play. It is the best-selling video game in history. 2. Starbound: Released in 2016, this sci-fi game allows players to explore various planets, terraform environments, and craft items while establishing settlements. It features procedurally generated worlds and character customization. 3. Forager: Released in 2019, this game emphasizes crafting over combat in a top-down perspective, allowing players to mine, farm, fish, and cook while exploring and developing their base. 4. Valheim: A fantasy survival game that gained popularity in 2021, where players act as fallen Viking warriors in an afterlife, combining survival elements with home maintenance and featuring a dynamic day-night cycle. 5. Core Keeper: An early access fantasy sandbox game where players explore a procedurally generated underground world, dig tunnels, and craft gear. It supports solo or cooperative play with up to seven friends.

AppWizard

February 25, 2026

My new indie darling is this crafting game stuffed with hand-sculpted creatures made by a husband and wife dev team

OddFauna: Secret of the Terrabeast is a sandbox crafting game where players assume the role of an Astor, a critter living on a legged whale called a Terrabeast. Players can chop down trees to craft materials, build a cottage, cultivate a garden, and befriend various creatures. The demo lasts five in-game days, taking about 90 minutes to complete, and is set in a single biome. The game features hand-crafted assets and intuitive controls. It emphasizes environmental choices that affect the game's fauna. OddFauna is scheduled for early access in spring 2026, with a demo available during the Steam Next Fest until March 2.

Winsage

January 29, 2026

Microsoft’s Quiet Exodus: Why Enterprise Developers Are Abandoning Windows for Linux Workstations

Microsoft developers and enterprise technology leaders are increasingly choosing Linux over Windows for development tasks, driven by performance concerns, workflow inefficiencies, and the rise of cloud-native development. The Windows Subsystem for Linux (WSL) has facilitated this shift by allowing developers to work in a Linux environment while still using Windows. Tools like Docker, Kubernetes, and Terraform, which are primarily designed for Linux, have led to a reevaluation of desktop strategies across various industries. Linux provides direct access to the same kernel and toolchain used in production, reducing discrepancies that can lead to bugs. It typically requires less memory at idle compared to Windows, making it more efficient for developers managing multiple containers or virtual machines. Microsoft has responded by investing in platform-agnostic tools like Visual Studio Code and embracing Linux on its Azure cloud platform, where over 50% of virtual machines run Linux. The introduction of WSL2 has improved compatibility and performance, but it has also highlighted Windows' limitations, leading to frustrations among developers. Security considerations favor Linux due to its open-source nature, allowing for greater customization and auditing. Financially, Linux can be more economical for enterprises due to lower licensing costs and reduced hardware requirements. Organizations that have switched to Linux report significant improvements in build times and overall developer experience. Hybrid strategies are emerging to accommodate developer preferences while ensuring security, with cloud-based development environments gaining traction. The trend toward Linux workstations reflects broader industry movements toward open source and platform independence, as companies adapt to attract and retain technical talent.

AppWizard

November 25, 2025

Stellaris Infernals brings the heat to the strategy game’s universe, and I can’t wait to burn it all down

The Stellaris Infernals Species Pack introduces new playable alien races adapted to volcanic worlds, including bird-like, crocodilian, and insectoid forms. It features a new Crisis Path with the Galactic Hyperthermia mechanic, allowing players to terraform stars into red giants and create Entropy Conduits. The DLC also adds four new Civics focused on fire and heat, such as the Fire Cult and Scorched World Heralds. The new species possess the Thermophilic trait, thriving on hot planets and consuming alloys instead of traditional food sources, but they struggle on Arctic worlds. The DLC is available for purchase on Steam.

AppWizard

October 27, 2025

With the survival feel of Valheim and daunting dungeons, this medieval city builder finally has a release date

Dungeons and Kingdoms is a medieval city-building adventure game that combines settlement management with action RPG gameplay. Players manage a group of refugee settlers on a mysterious island, facing challenges such as predators and ancient ruins while building their settlement. The game features survival mechanics, including foraging, crafting, and resource harvesting, with over 500 unique building pieces available for creative expression. Players can terraform the environment and engage in combat reminiscent of soulslike games. The game has generated nearly 200,000 wishlists after its demo at Steam Next Fest and is set to launch in early access on November 17, priced at .99.

AppWizard

September 15, 2025

With Manor Lords’ city building and Valheim’s survival action, this beautiful new ARPG just shot to the top of my wishlist

Dungeons and Kingdoms is a new game that combines high-stakes combat with city-building mechanics. Players take on the role of a leader guiding refugees to a new home in a lush paradise. The gameplay includes crafting, foraging, and battling low-level creatures, with the potential to recruit animal companions. Players can terraform the land, build various structures, and share designs on the Steam Workshop, with over 500 building types available. The game features dungeons with challenges and a variety of enemies, emphasizing strategic combat. It has a pixel art style inspired by games like Valheim and Old School Runescape. Dungeons and Kingdoms is scheduled for release in Steam Early Access in Q4 of 2025, with a demo available from October 13 to October 20. A wishlist option is also available for interested players.

AppWizard

August 30, 2025

Chill simulation strategy game Plan B: Terraform has hit 1.0

Plan B: Terraform has officially launched its 1.0 version after a successful early access period. Players aim to transform a barren planet into a habitat for humanity by constructing automated infrastructures that support the growth of new cities. The gameplay involves introducing greenhouse gases, melting ice caps, and nurturing ecosystems with liquid water, greenery, and wildlife. The game offers a laid-back approach, allowing players to thoughtfully build production chains without the pressure of failure. It is available on Steam.

Tech Optimizer

August 5, 2025

Building a job search engine with PostgreSQL’s advanced search features

Job search platforms connect employers and candidates through advanced search engines that analyze structured and unstructured data. These platforms require robust database technologies for executing complex queries, full-text and semantic searches, and geospatial functionalities. A modern job search engine consists of a data repository that stores job listings and candidate profiles, and a search engine that facilitates bidirectional searches. Key features of an effective job search engine include: - **Full-text search**: Provides lexical matching for job titles and skills, supporting exact phrase matching and typo-tolerant searches. - **Semantic search**: Uses vector-based similarity to understand context and relationships beyond literal terms. - **Geospatial search**: Incorporates geographic considerations to find opportunities within specific distances. PostgreSQL serves as both a data repository and search engine, supporting full-text search, semantic search via the pgvector extension, and geospatial queries using the PostGIS extension. The job search engine utilizes PostgreSQL to manage job listings and candidate profiles, enabling real-time searches across millions of entries. The data model for a job search engine includes tables for jobs and resumes, with columns for full-text search vectors, semantic vectors, and geographical locations. PostgreSQL's full-text search capabilities include tokenization, dictionaries for language-aware parsing, and ranking functions for relevance. Advanced features such as proximity search, simple and weighted ranking, and fuzzy matching enhance search accuracy. Vector embeddings represent text in high-dimensional space, allowing for semantic searches that recognize similar roles or skills. PostgreSQL supports vector similarity searches with specialized indexing methods like IVFFlat and HNSW for efficient querying. Geospatial search capabilities in PostgreSQL enable location-aware job searches, allowing candidates to find jobs within commuting distances. Combining different search techniques, such as full-text and semantic searches, provides more relevant results. Performance optimization features in PostgreSQL address challenges related to computational complexity, indexing overhead, and concurrent query loads. The architecture discussed is applicable to various applications beyond job search platforms, including e-commerce, real estate, content recommendation systems, travel, and healthcare provider matching.