ContentPosts from @varbear..
Link
@varbear shared a link, 1 month, 3 weeks ago
FAUN.dev()

Understanding the Go Compiler: The Linker

Go’s linker stitches together object files from each package, wires up symbols across imports, lays out memory, and patches relocations. It strips dead code, merges duplicate data by content hash, and spits out binaries that boot clean - with W^X memory segments and hooks into the runtime... read more  

Understanding the Go Compiler: The Linker
News FAUN.dev() Team Trending
@varbear shared an update, 1 month, 3 weeks ago
FAUN.dev()

VillageSQL Launches: A Drop-In MySQL Fork Bringing Extensions and AI to the Core

VillageSQL MySQL

VillageSQL is a drop-in, open-source fork of MySQL that introduces a true extension framework, enabling permissionless innovation for AI-era workloads. It allows developers to add custom data types and functions - with vector indexing and search on the roadmap - bringing MySQL closer to PostgreSQL-style extensibility without waiting for core upstream changes.

 Activity
@varbear added a new tool VillageSQL , 1 month, 3 weeks ago.
Link
@varbear shared a link, 1 month, 3 weeks ago
FAUN.dev()

Discord Alternatives, Ranked

A veteran Discord admin did a deep dive into chat platform alternatives - Signal, Matrix, Zulip, Rocket.Chat, Discourse - stacked against five key pillars: functionality, openness, security, safety, and decentralization. Discord didn't come out looking great. Centralized. No end-to-end encryption. S.. read more  

Discord Alternatives, Ranked
Link
@varbear shared a link, 1 month, 3 weeks ago
FAUN.dev()

What Is an Async Agent, Really?

An async agent is not inherently async, it depends on whether you wait for it to finish or not. Async agents can manage their own event loop of other agents, spawning and coordinating them to handle tasks, just like an async runtime in programming. This architectural distinction allows for concurren.. read more  

Link
@varbear shared a link, 1 month, 3 weeks ago
FAUN.dev()

I struggled to code with AI until I learned this workflow

AI coding assistants work best when given clear context, a specific plan, and implemented in small, reviewable steps. Start with context, then a plan, and iterate through implementation and testing to avoid AI freelancing pitfalls... read more  

Link
@varbear shared a link, 1 month, 3 weeks ago
FAUN.dev()

Company as Code

Organisations rely heavily on digital systems, yet manage important organisational data using outdated manual methods despite advanced automation capabilities in other areas. A novel "Company as Code" concept proposes a programmatic representation of the entire organisation, enabling structured, ver.. read more  

Link
@varbear shared a link, 2 months ago
FAUN.dev()

Unconventional PostgreSQL Optimizations

PostgreSQL 18 now supportsvirtual generated columns, indexable expressions without burning storage. Perfect for standardizing queries in analytics-heavy pipelines. Pair that withplanner constraint exclusion(constraint_exclusion=on), and Postgres can dodge irrelevant table scans based on constraints... read more  

Unconventional PostgreSQL Optimizations
Link
@varbear shared a link, 2 months ago
FAUN.dev()

Software engineering when machine writes the code

In 1968, computer scientists identified the "software crisis" - the existing methods of programming were struggling to handle the power of computers. Today, AI coding assistants are accelerating productivity, but concerns arise about understanding the code they generate, the implications for debuggi.. read more  

Link
@varbear shared a link, 2 months ago
FAUN.dev()

The challenges of soft delete

"Soft delete" sounds gentle. It isn't. Slapping adeleted_atcolumn on every table pollutes queries, drags down migrations, and leaves tombstones all over production. This post digs into saner options:PostgreSQL triggers,event archiving in the app layer, andCDC via WAL. Each separates the dead stuff f.. read more