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.
Last time around [https://zblesk.net/blog/ghost-learning-nginx-on-ubuntu/] 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
So the time finally came: Ghost 1.0
[https://github.com/TryGhost/Ghost/releases/tag/1.0.0] is out. My setup is a
little more complex than the vanilla one: on this
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'
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.