Travis Horn - Data Scientist and Software Engineer

You don't need a bloated, expensive CI/CD platform to deploy your Node.js apps.

I manage a multi-purpose Linux server.

This guide helps you make sure your Debian server stays in a high integrity state by following the conf.d drop-in pattern.

Previously, I wrote about rendering Observable Plot server-side with SvelteKit.

I've found that having a consistent version control workflow is crucial, no matter if I'm working solo or with other contributors.

Both Flexbox and CSS Grid are powerful layout tools built into modern CSS.

Web apps have evolved beyond static documents, often relying on complex interfaces like dropdowns and modals built entirely with generic ` `s and …

For years, I relied on the official installer from python.org to manage my Python versions.

We all know DuckDB is fast.

If you manage reporting databases in PostgreSQL, you've probably worked with nightly rebuilding of summary tables.

If you've worked with SQLite before, you know how versatile a database system it can be.

With massive data, frontend visualization often means you either crush the browser with giant JSON payloads or get stuck waiting on slow API endpoints…

Here's a scenario: You have a dashboard open in two windows.

Efficiency is the name of the game when you've got massive data volumes that include cross-border and regional aggregations like those you might find …

When anyone makes a purchase, whether it's online or in a brick-and-mortar store, the cardholder's bank (the issuer) and the merchant's bank (acquirer…

A query that works perfectly on a small development dataset can still bring the production database to a halt as data volumes scale.

Schools need accurate enrollment forecasting for stability and success.

Most developers are used to spinning up a single instance of their database system and calling it a day.

One of the most common yet complex challenges in application development is the "zone lookup" problem.

I recently ran into a frustrating caching issue with Apache.

Imagine you need to run a report showing every student enrolled during the academic year.

When picking a primary key for a table in a database, sometimes there is an obvious choice.

Recognizing data types is a foundational concept in statistics and data science because the type of data you have dictates the appropriate statistical…

Git is a powerful tool, but it can also be a source of frustration when things go wrong.

DuckDB is an incredibly versatile, in-process database.

I love the free and open-source software (FOSS) community.

Data is the lifeblood driving innovation in many industries, including healthcare.

I've been playing around with how ML techniques can be applied to logistics and e-commerce.

Cursor, the AI-first code editor, significantly speeds up my development workflow, especially when working with modern web frameworks.

While powerful tools like virtualenv, pipenv, conda, and Poetry exist to provide extra advantages for dependency management, I've found a simple syste…

ESLint is a tool for "linting" your code.

libsql Migrate is a database migration and seed management tool for libsql with configurable options, written in JavaScript and available as an npm pa…

As you develop software, having a development database that mirrors your production data is a game-changer.

Every system administrator would be wise to keep a close eye on the health and performance of their server infrastructure.

Building dynamic applications often involves connecting to a database to store and retrieve data.

Ensuring the safety and integrity of data in your database management system should be one of the highest priorities.

MariaDB is a great open-source relational database management system.

Today, online security is paramount.

Firewalls are an essential part of network security, and nftables is a powerful tool for configuring them.

Reverse proxying with nginx is a powerful way to manage and distribute web traffic.

Continuous deployment involves frequently integrating code changes into a shared repository.

Using a web application framework like SvelteKit opens up possibilities to bring your data visualizations to life on the server side before sending th…

Node.js is a popular runtime environment for building scalable and high-performance applications.

In this tutorial, we will explore the process of serving Next.js apps on a Linux server.

Installing Node.js is a crucial step for developers looking to leverage its powerful features and vast ecosystem.

Recently, while working on a project, I needed to add a feature to allow users to upload a file and save it on the server.

If you're looking for a reliable and secure way to host your Git repositories, setting up your own server can be a great solution.

Staying up-to-date with software updates and security patches is important for a secure computing experience.

Public key authentication is a fundamental aspect of secure and efficient communication in the realm of server administration.

VirtualBox is as a powerful tool to create and manage virtual machines.