Home
About
SK blog
Rapture in Everything
Posts tagged "cli"
2022 Dec 13
2022 Dec 13
csv-to-sqlite 2.1.3 - security update
Over on GitHub, the Dependabot opened several PRs/notifications about security-compromised dependencies in my tool for guessing the types of data in your CSV files and importing them into a SQLite DB. I noticed it's really been quite a while since the last update, so I went ahead and fixed that. Dependabot warned that some of the updates can't be done automatically because there were larger version bumps to overcome, but I wasn't bothered - the script is quite simple, and the trivial functional...
csv-to-sqlite
cli
tools
2020 Apr 18
2020 Apr 18
csv-to-sqlite 2.1 - script support, encodings and brackets
Version 2.1 of csv-to-sqlite [https://pypi.org/project/csv-to-sqlite/] was just released. There are a few new things, suggested in GitHub [https://github.com/zblesk/csv-to-sqlite] 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-sqlite As an aside: if you're...
tools
python
csv-to-sqlite
2019 Apr 24
2019 Apr 24
csv-to-sqlite 2.0 - memory improvements
My csv-to-sqlite script got some updates - most importantly it now requires far less memory....
tools
python
open source
2017 Aug 08
2017 Aug 08
Ghost: making me learn nginx on Ubuntu
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 site, there are two blogs next to one another: one here at /blog [https://zblesk.net/blog], and a separate one at /sk [https://zblesk.net/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 th...
how-to
blogs
tech
2017 Feb 08
2017 Feb 08
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...
programming
powershell
cli
Older