Skip to content

Instantly share code, notes, and snippets.

Avatar

Karolis Kazlauskis kazlauskis

View GitHub Profile
@kazlauskis
kazlauskis / mdb2sqlite.sh
Created Sep 8, 2016
Transforms MS Access MDB file to sqlite database using mdbtools
View mdb2sqlite.sh
#!/bin/bash
# Inspired by
# https://www.codeenigma.com/community/blog/using-mdbtools-nix-convert-microsoft-access-mysql
# USAGE
# Rename your MDB file to migration-export.mdb
# run ./mdb2sqlite.sh migration-export.mdb
# wait and wait a bit longer...
mdb-schema migration-export.mdb sqlite > schema.sql
@kazlauskis
kazlauskis / Instructions.md
Last active Nov 5, 2020
Extract Kindle vocabulary words to CSV
View Instructions.md

This was done mainly to upload it to Anki.

  • Mount kindle
  • cd Kindle/system/vocabulary
  • sqlite vocab.db
sqlite> .headers on
sqlite> .mode csv
sqlite> .output data.csv
@kazlauskis
kazlauskis / pass2KeePass.sh
Created Jul 13, 2017
Export Password Store (aka pass) passwords to a KeePass compatible imports file
View pass2KeePass.sh
#!/bin/bash
#
# Export Password Store (aka pass) passwords to a KeePass compatible imports file.
# Note: this does not respect the folder structure (yet). Also, multiline notes are not exported correctly.
#
# Author: Karolis Kazlauskis
# 2017
entries='' # pass entries found
@kazlauskis
kazlauskis / create_labels.sh
Last active Mar 14, 2016 — forked from omegahm/create_labels.sh
Create Gtihub labels from Bash
View create_labels.sh
#!/usr/bin/env bash
# Colours picked from https://robinpowered.com/blog/best-practice-system-for-organizing-and-tagging-github-issues/
###
# Label definitions
###
declare -A LABELS
# Platform