Rapture in Everything

Posts tagged "open source"

Trying out Passbolt (with Docker)

A step-by-step guide for getting from a clean Ubuntu 18.04 LTS to a running Passbolt instance with a simplistic Docker setup....

csv-to-sqlite 2.0 - memory improvements

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

Wallabag - with MySQL and RabbitMQ

How I discovered Wallabag and made it run on Ubuntu with MySQL and RabbitMQ for Imports. Everything I needed to do should be here,...

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

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