tech

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.

PyCon SK 2016

The famous PyCon came to Slovakia for the first time. Quite frankly: I’m impressed. For those who don’t know: PyCon means Python Conference, and it’s meant for anyone interested in

Twitter keeps crashing Firefox?

I use Firefox daily on all of my devices, both at home and at work. And only on one of them it always crashed whenever I accessed twitter.com. I’ve tried everything

Manipulate MSMQ with PowerShell

I´ve recently published an open source MSMQ component for the SQL Server Integration Services [https://zblesk.net/blog/2015/02/08/msmq-reader-component-for-ssis/]. While working on its implementation (and other, related things), I’

MSMQ reader component for SSIS

Last year I had to use SQL Server Intergration Services package to read some data from a MSMQ queue and pump them into a database. It sounded easy enough, but I quickly ran