Failure and Success Navigating ‘Away From Keyboard’ Software Engineering
How I moved my agentic development workflow to a persistent VPS that I can use from a laptop, phone, or iPad.
bprp.xyz
A Brooklyn based software engineer and socialist passionate about the upcoming PostgreSQL release and surviving the 21st century.
Latest posts
Salience, Identity Formation, Field Tactics, and Political Strategy
A coherent theory of political campaigning effects through identity preservation and cognitive dissonance minimization
Marimo + DuckDB is a Reactive SQL Joy
A detailed exploration of using Marimo notebooks with DuckDB's Relational API for reactive SQL workflows
Using Codegen Targeting Postgres with Redshift
A workaround for using kysely-codegen with Redshift by dumping schema to local Postgres
Seeking Collaborators: Better Local Voice Document Editing
Using LLMs to extract document edits from chunks of speech for better voice-to-text workflows
Easy Optimistic Updates with Jotai and Immer
A comprehensive solution for implementing optimistic updates using the useAtomImmerSaga hook
Derived Atom with Immer
quick recipe I am very happy with for use with [Jotai](https://jotai.org/)
Software Design and The Structure of Political Organization
A talk exploring the influence of organizing software architecture and the resulting political organization
Postgres Query Toolkit
A collection of frequently used PostgreSQL diagnostic queries for monitoring and optimization
My Choices for Building Interactive Web Apps in September 2023
My preferred technology stack for building highly interactive single page applications
Previous Research Question
Towards a rigorous, practical, and faithfully optimistic collapsology - studying systems modeling for climate adaptation
Seeking Collaborators: An Ahead of Time Database
A database system that restricts queries to a specified set but guarantees specific performance claims
Seeking Collaborators: Cooking with Graphs (Fine Tuning an LLM + Graph Semantic Analysis)
A "What can I cook for dinner?" service using LLMs and graph databases
Seeking Collaborators: How to Blow Up Enough Pipelines
Exploring the strategic and financial aspects of fossil fuel infrastructure disruption
Seeking Collaborators: Structured Note Taking for Organizers
Making it easy to extract meaningful structured data from organizing conversations without burdening organizers
How to argue hot dogs aren't sandwiches
A linguistic analysis of the hot dog sandwich debate using intensional vs extensional definitions