djuber

#!/bin/sh

# This script will migrate schema and data from a SQLite3 database to PostgreSQL.
# Schema translation based on http://stackoverflow.com/a/4581921/1303625.
# Some column types are not handled (e.g blobs).

SQLITE_DB_PATH=$1
PG_DB_NAME=$2
PG_USER_NAME=$3

djuber

Keybase proof

I hereby claim:

• I am djuber on github.
• I am djuber (https://keybase.io/djuber) on keybase.
• I have a public key ASDYVL4vUJ523jHOtHJsnv_O7VbMnPJB3BiP7TM63ZSuIwo

To claim this, I am signing this object:

djuber

#!/bin/bash

if [[ "$#" = "0" ]]
then
  echo "usage: $0 \$infile  \$outfile"
  echo "expects an xml infile, optionally write output to outfile, default is write to stdout"
else
  if [[ "$#" = "1" ]]
  then
    cat "$1" | xmllint --format  -

djuber

class Array
  # group elements by their identity, and count each distinct item
  def counts
    group_by(&:itself).map {|k,v| [k, v.count] }
  end
end

djuber

##
## A stegosaur with a top hat?
##
$the_cow = <<EOC;
$thoughts                             .       .
 $thoughts                           / `.   .' "
  $thoughts                  .---.  <    > <    >  .---.
   $thoughts                 |    \\  \\ - ~ ~ - /  /    |
         _____          ..-~             ~-..-~
        |CRUFT|   \\~~~\\.'                    `./~~~/

djuber

Rails, Webpacker, Postgresql on Docker (DEV setup)

Create Rails app with docker

$ docker run --rm -it -v ${PWD}:/usr/src -w /usr/src ruby:2.7 sh -c 'gem install rails:"~> 6.0.3" && rails new --database=postgresql <app_name>'

Create Docker files

1. cd into project directory

djuber

# step should have NODE_VERSION and YARN_VERSION environment variables declared 

      - run:
          name: Download NodeJS things
          command: |
            mkdir -p nodejs-downloads/
            cd nodejs-downloads/
            [ -f node-v${NODE_VERSION}-linux-x64.tar.xz ] || curl -O https://nodejs.org/dist/v${NODE_VERSION}/node-v${NODE_VERSION}-linux-x64.tar.xz
            [ -f yarn-v${YARN_VERSION}.tar.gz ] || curl -O -L https://yarnpkg.com/downloads/${YARN_VERSION}/yarn-v${YARN_VERSION}.tar.gz

djuber

;; Thanks @bschmeck

(defun shmk/ivy--regex-dashes (str)
  "Build a regex sequence from STR.
Insert .* before each -."
  (let ((subs (split-string str "-")))
    (if (= (length subs) 1)
        (ivy--regex str)
      (ivy--regex (concat "^" (string-join subs "[[:alnum:]]*-"))))))

djuber

(defun de-ansify ()
  "apply ansi color codes in currently selected region"
  (interactive)
  (ansi-color-apply-on-region
   (region-beginning)
   (region-end)))

djuber

Asciinema

{% embed https://asciinema.org/a/330532 %}

Codepen

{% embed https://codepen.io/elisavetTriant/pen/KKvRRyE %}

Gist