Knowledge base
Practical resources and guides on AI tools, technology, and software development.
Collecting a report from several sources into one document
How it works: define the metrics glossary before writing code, read sources through APIs, save a snapshot of each response, calculate figures with SQL, and use a model only to describe changes. Common causes of discrepancies include time zones and shifted payment dates.
Supabase: database, authorization and API without its own backend
Managed PostgreSQL, automatic REST on top of the schema, login by mail and OAuth, and rights are set by line-by-line policies right in the database. Analysis of the mechanics, traps of RLS and ways to verify that the data is really closed.
Autonomous AI agents: where they can handle it themselves and where a person is required
Levels of autonomy from a hint to an action on a white list, the mechanics of independent work and a list of actions that are not given to the agent under any settings.
Claude Code Windows: installation, Git Bash, WSL and rakes along the way
Two working circuits on Windows - native and WSL2 - with installation commands, shell settings and a list of problems that occur in almost everyone.
How deployment works: build, release, rollback
An artifact is assembled once and promoted through environments, a release is an artifact plus a config, rollback only works if the base is compatible with the previous version of the code. Analysis of stages, rollout strategies and a migration scheme that does not block rollback.
Single source, multiple channels: publishing pipeline
Manual posting across multiple channels breaks down on markup, tags in links, and resending after a failure. Analysis of mechanics: one source, adapter per channel, queue with an idempotent key, scheduler.
PostgreSQL for those who came from tables
Translation of Excel and Google Sheets habits into the language of the base: a sheet becomes a table, a VLOOKUP becomes a foreign key, a pivot becomes a query with GROUP BY, and data validation becomes a limitation that cannot be circumvented.