Rapture in Everything

Posts tagged "programming"

Tinkering with Transposit (beta) and AirTable

Transposit is an interesting new service that aims to help when you're trying to connect various apps (or, more specifically, their APIs) together. But it does it in a novel way: it lets you query various data sources as if they were SQL objects. That is an ingenious idea: most of us already know SQL and it maps quite well to what we're trying to achieve with many of the APIs. To illustrate: Transposit lets you treat various services as SQL schema and query them; not only that, it lets you perform joins and other operations and mix them with...

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...

Migrating history from TFS to Git with git-tfs

Maybe you've found yourself stuck with a codebase in the TFS Version Control System and would like to move it, along with its entire history, into Git. If so, this article explains how to do it. Even if you don't plan to move, you might want to check out git-tfs - a bridge between TFS and Git, that allows you to work with your codebase in TFS as if it were a Git repository. I'd been using git-tfs for multiple projects, and since now the TFS server itself directly supports Git, it's about time to migrate it.[1] If you...

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 the programming language. I can’t say I have much experience with community-organized dev events, but the organizers clearly did their homework. I’m not exactly an avid tweeter, but I couldn’t resist: It was obvious immediately after entering #PyConSK that I hadn't seen this many nerds in one place in quite a while. I've missed it. — zblesk (@zblesk) March 11, 2016 That was prompted by...