Rapture in Everything

Posts tagged "open source"

Hosting a .NET Core 2 app on Ubuntu

A few months ago I'd started a fun side-project of moving my personal web apps from various Windows-based services to a single Ubuntu VM because of the release of Ghost 1.0. Later, I'd managed to replace my Bonobo Git Server with Gitea. The last piece was to move a custom app - which was written in .NET and needed to be re-written to run on Ubuntu. (And it took forever to find time to do that.) So after I had my app re-written with .NET Core 2[1] MVC, using Vue, Bulma, TypeScript and some arcane Webpack stuff that...

Running a git repo site on nginx on Ubuntu

Last time around I wrote about migrating my webs to an Ubuntu VM. One of the few things that were left to migrate was my private git repo hosting site. I'd used Bonobo Git Server and had always been satisfied with it. Since it doesn't target .Net Core, I didn't see any reasonable way to run it on Ubuntu. After some searching, I'd fortunately stumbled upon Gitea. To get it up and running for the first time wasn't that difficult. I just had to: sudo useradd -m gitea wget https://dl.gitea.io/gitea/1.1.3/gitea-1.1.3-linux-amd64...

Ghost: making me learn nginx on Ubuntu

So the time finally came: Ghost 1.0 is out. My setup is a little more complex than the vanilla one: on this site, there are two blogs next to one another: one here at /blog, and a separate one at /sk. I also have other Ghost blogs in different places and domains. This post documents the stuff I had to learn, and what I ended up using, in case I need a refresher. For various reasons, I run them in Azure. Setting it up was never easy - I'd wasted many, many hours on failed attempts and ended up...

Scripts for repeatable SSIS package deployment

Instead of writing manuals with a lot of pictures for a customer's admin, I prefer to write a script that does the deployment by itself when ran. Several times I'd needed to deploy SSIS packages and configure them with SQL scripts, which is a pain to do manually, since it involves a lot of clicking and SQL editing. Of course, another advantage of using scripts is that your deployments are repeatable, quick, and can be shared with your colleagues via your VCS of choice. All of the components used here should be present on any SQL server you are deploying...

csv-to-sqlite - copying from CSV files to a SQLite database

csv-to-sqlite is a command line tool that **takes CSV files and dumps their contents into a SQLite database**. The basic gist: for each file, the script creates a database table with the same name, tries to guess the data type, then copies all the data into the database....