Andrés Castañeda
  • Research
  • Tools
  • Writing
  • About
  • Contact
  • CV
Categories
All (15)
AI (6)
efficiency (2)
handbook (4)
Open Brain (6)
programming (1)
R (1)
Stata (8)
Supabase (3)
Telegram (1)

Writing

Technical posts and notes on software, data analysis, and research workflows.

Open Brain · A six-part series

A database for my thoughts.

A personal experiment in capturing ideas and finding them again with AI. Start with the opening chapter.

Read part one →
Beyond this siteExternal & coauthored writing →Writing updatesRSS & email updates →

All posts

Open Brain: The Database Core — Supabase, pgvector, and Hybrid Search

AI
Open Brain
Supabase

Build and verify a private database, save pipeline, hybrid search, and optional MCP interface with focused agent prompts.

Nov 13, 2026
6 min

Open Brain: Mobile Capture with a Telegram Bot

AI
Open Brain
Telegram

Add Telegram text capture and plan optional voice, with access restrictions and recovery checks.

Nov 13, 2026
5 min

Open Brain: Finding the Right Notes

AI
Open Brain
Supabase

Evaluate hybrid retrieval, document context, optional reranking, and graph links before adding complexity.

Nov 13, 2026
6 min

Open Brain: A Browser Interface with Next.js and Vercel

AI
Open Brain
Supabase

Build a small browser interface for existing notes, with authentication, search, and practical verification.

Nov 13, 2026
5 min

Open Brain: Backups, Security, and GitHub Hygiene

AI
Open Brain

Review access, protect credentials, and prove that your Open Brain can be recovered.

Nov 13, 2026
7 min

Open Brain: Why I Built a Database for My Thoughts

AI
Open Brain

A practical, prompt-first introduction to building a personal Open Brain with Supabase and an AI coding agent.

Apr 11, 2026
10 min

Add “and” at the end of character vector

R
efficiency

A small R function to properly concatenate character vectors with an ‘and’ separator

Jul 30, 2020
1 min

A nice template for your do-files: dotemplate

Stata
efficiency

The dotemplate Stata command creates structured templates for do-files and ado-files so you can start your code organized from the beginning

Jun 25, 2019
2 min

Working with GitHub and Stata

Stata

How to configure Stata’s adopath to automatically load all your ado-files from GitHub working directories

Jun 12, 2019
4 min

Dependencies: making sure your ado/do-files run in any computer

Stata
programming

A code snippet to automatically install and update required SSC commands at the beginning of your do-files

May 30, 2019
2 min

Stata profile.do: nice tips

Stata

How to configure Stata’s profile.do for a productive workflow: shortcuts, globals, and automatic adopath setup

Apr 12, 2019
5 min

Export results to Tableau or Excel from Stata

Stata
handbook

How to arrange Stata results in long (tidy) format using matrices or postfiles so they can be directly imported by Tableau or Excel

Aug 1, 2018
9 min

Naming Variables

Stata
handbook

12 principles and conventions for naming Stata variables that improve code readability and team workflow

Jul 2, 2018
5 min

Working with Loops

Stata
handbook

Tips and deeper understanding on using while, foreach, and forvalues loops in Stata, including common pitfalls with decimal ranges

May 2, 2018
9 min

My Stata editor: NotePad++

Stata
handbook

A complete guide to setting up NotePad++ as your Stata editor, including syntax highlighting and useful keyboard shortcuts

Mar 15, 2018
4 min
No matching items

© 2026 R. Andrés Castañeda Aguilar

External writing · Talks · Updates