Daniel Romaschin

Software Developer & Systems Tinkerer

Notes on programming, high-throughput DuckDB pipelines, web development, and minimalist software architecture without unnecessary abstraction.

Write Software on Your Phone

I am an active guy. I learned a long time ago that a day consisting of digging up the yard, cycling 30 kilometers and lifting weights for me is a good day. In the past this clashed with my aspirations of building software. If you want to get good at anything you have to do it a lot and so I spent a lot of time in front of the screen not only learning programming languages, frameworks and how to build good software (which you still should do today in my view) but also just typing the code.

These days however you can build great software from your phone. Sure you could type code before on your phone but that was very slow and cumbersome at best. I am talking about using Claude to build from your phone. Since Opus 5.5 my reservations about AI and the quality of code it is capabable of producing have vanished. This model is just awesome. So I decided to make the process portable.

The Setup

Claude Code has this feature called remote sessions. Basically you can start a code session anywhere and then connect to it through the Claude app on your phone. I set up a small VPS on Hetzner, set up mise to install tools and ran Claude Code as a non-sudo user on this VPS. It has its own git user on my self-hosted Forgejo. If I am building web apps I can expose the development server through Tailscale. Great! I can build a feature with Claude, review it through Tailscale and then push it to Forgejo - all from my phone! One piece however was missing.

Forgejo CLI

There is no real forgejo CLI in a sense of the dreaded GitHub CLI. There is no way to for example open a PR from the command line. The only thing that kind of seems to fit is the Gitea CLI - which was the original project forgejo was forked from. I have doubts about compatibility though. Thus, I had Claude build my own. You can find it here.

Now my phone-based software engineering setup is complete. I can open a PR through the CLI, review it on forgejo and then merge it. I build a lot of Rails applications lately and have configured my Forgejo workflows to auto-deploy on merge to main via Kamal.

DuckDB Query Editor

I use DuckDB a lot. It is fast and just works well for a lot of tasks. However, I have been struggling to find a good editor. The plugins for vscode are not good plus they clash with other plugins I have to use. Jetbrains editors increasing feel to heavy. So I whipped out Gemini Argon 4 and vibe-coded a native Windows editor for DuckDB sql in Rust. The editor uses VIM motions. I got into it recently and never looked back. Once you get used to them it is hard to edit text the regular way. If you want to check it out: QueryDuck

Keyboard Phones are Back - Unihertz Titan 2 Elite

Titan 2 Elite

A couple of days ago I started an experiment. After years on the iPhone I switched to a Unihertz Titan 2 Elite. Not my first Android phone but my first phone with a physical keyboard and a smaller BlackBerry-ish kind of screen. I never owned a Blackberry so this is not about nostalgia. It is about using a device made for generating text and thus communicating efficiently. Most modern phones are made for creating and consuming video and sound content. The typing experience has actually gotten worse. To me that’s not efficient. I especially loathe voice messages on WhatsApp. It is inconvenient for me to type so I put the inconvenience of listening to me rambling on you the recipient of my message. When you forget a part of my message have fun searching for it in a 10 minute voice recording.

Continue reading →

PHP is actually awsome!

I am maintaining several Next.js applications at the moment. The number of dependencies and the vulnerabilities they bring are astonishing. For a while, I have been searching for something simpler—I don’t really use Next.js’s features for what I do anyway. Usually, the start page is static, and the remaining pages are client components. Or, everything is static.

Continue reading →

Max Beckmann - Leben zwischen den Welten

Trost ist der sichere Glaube an die Unrealität des Lebens hinter der vielleicht die wirkliche Wahrheit liegt. Und um sie zu finden, das heißt leben und sterben. Immer wieder aufs neue leben und sterben bis wir da angelangt sind, wo es keine Erfahrung mehr gibt nur noch absolutes Wissen. Je intensiver man zu sich selber kommt umso eher kommt man ihm oder dem Absoluten näher. Das ist das Ziel und der Trost.

Analyse CloudWatch Logs with DuckDB

I have about 8 years of AWS under my belt. I still really don’t like CloudWatch. The fact that someone at AWS thought it is a good idea to design a custom query language for logs is astonishing to me. And I know you can use SQL now or let AI generate the query for you - still it’s not great. The UI is horrible. You get stuck with it however especially if budget is tight and custom solutions are out of the question. Or maybe you are using another AWS service like ECS Fargate to host your application. CloudWatch is deeply embedded in the AWS ecosystem. 

I do like DuckDB, though. It is a very capable file-based analytics database which just wants to plow through gigabytes of JSON logs on your laptop. Thus, I decided to make use of some of my free time and write my own command line tool cw-to-duck that exports CloudWatch logs directly into a DuckDB file. All you need to do is install AWS CLI, log in to your account with a role that has sufficient permissions to access your logs and run cw-to-duck. It also provides parsers for certain AWS services such that next to the logs_raw table the resulting DuckDB file will contain a handy logs_parsed table ready for analysis.

Don't be an idiot...

Don’t have a Windows PC but want to install Windows on a laptop currently running Linux from a bootable USB drive? The only other computer you have is a MacBook? Don’t be an idiot like me and spend 5 hours chatting with AI attempting things. Just follow option B in this guide. It worked. At least until Microsoft changes something again.

SEO for lazy people

Although I have been dabbling in web development for a while I have never gotten into SEO. I guess I am more of a developer than I am an entrepreneur because once the technical challenge is solved, I tend to lose interest. If you want to earn money however people need to know about your solution in addition to it being useful, fairly priced and excel in many other aspects. It is part of the game.

Continue reading →

Deploy a complex Next.js app with Kamal - BetterAuth, Drizzle and Postgres

Last change: 2025-10-06

  • Next.js version: 15.4.7
  • Ruby version 3.4.5
  • Kamal version: 2.7.0

Introduction

This builds on my previous post which describes how to deploy a relatively simple Next.js application with Kamal to a VPS. Simple meaning that there weren’t any environment variables and not database. This post describes how to deploy a more complete Next.js application using BetterAuth for authentication, Drizzle ORM and a Postgres database. We are deploying to a single beefier VPS on Hetzner (ARM 4 vCPU, 8GB RAM, 10GB Volume). In contrast to the other post we are also using Docker Hub instead of the Scaleway Docker repository as I found it unreliable on my mobile connection.

Continue reading →
11 essays indexed