The COPY command in DuckDB and MotherDuck is a versatile tool for importing and exporting data. This guide provides a concise overview of how to use COPY both from the DuckDB CLI (SQL only) and from Python, including workflows with Ibis and pandas. Use this as a quick reference for your data engineering tasks!...
Continue reading...Building a Complete DuckLake Solution: From Local Development to Cloud Production
Introduction DuckLake is revolutionizing the lakehouse architecture by combining the simplicity of DuckDB with the power of modern data lake formats. In this comprehensive guide, I’ll walk you through building a complete DuckLake solution in two parts: first creating a local development environment, then scaling it to a cloud-based production...
Continue reading...How to Set Up a Powerful, Free Forever Server on Oracle Cloud (Caddy Edition)
Earlier in 2025, I signed up for Oracle’s “Free Forever” cloud offer. It was, and still is, one of the most generous free tiers available, especially for developers and hobbyists. I wrote a post to document my setup, and today I’m updating it with a more modern, simpler stack and...
Continue reading...A SysAdmin’s Tale: From a “Simple” Sync Error to a Full Server Health Check
This is the story of how I fixed a broken file sync. Except, it wasn’t just about the file sync. It was about what the sync error was hiding: a server at 93% disk capacity, applications silently crashing, and gigabytes of space being wasted by runaway logs. Join me as...
Continue reading...The Ultimate Guide to Installing and Using Gemini CLI on Windows, Linux, and VS Code
In the fast-paced world of software development, efficiency is everything. What if you could bring the power of a cutting-edge AI directly into your terminal, ready to answer questions, explain code, and generate commands without ever leaving your command line? That’s exactly what the Gemini CLI offers. It’s a powerful...
Continue reading...