Rapture in Everything

Posts tagged "cli"

csv-to-sqlite 2.1 - script support, encodings and brackets

 Version 2.1 of csv-to-sqlite was just released. There are a few new things, suggested in GitHub issues: you can now specify that you do not want brackets around your column names, you can specify the encoding your files (the default still is UTF-8) and it's now easier to use csv-to-sqlite in scripts. If you wish to do that, simply install it as a dependency: pip install csv-to-sqliteAs an aside: if you're not using Pipenv yet, take a look at it. It's great.Then import it and call write_csv(). import csv_to_sqlite # all the usual options are supported...
python csv-to-sqlite open source

csv-to-sqlite 2.0 - memory improvements

 My csv-to-sqlite script got some updates - most importantly it now requires far less memory....
python open source cli

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...
how-to blogs tech

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...
ssis powershell cli

Moving a VHD (disk image) between Azure Storage accounts with x-plat CLI

 I’ve discovered I’ve accidentally created a VHD in a Premium storage account, so I wanted to migrate it into a standard one. (Premium data are stored on SSDs and much more expensive.) I’ve found a way to do it using the Powershell commands, but I like the xplat CLI more. (It, too, is developed by Microsoft, built on Node.js and available via npm.) So I set to exploring. Here is what’s worked for me; I can’t guarantee it being the best possible way to do it, but it works. :) Basically, first I find all...
how-to cli tech