josemarcosrf

SQLite to Postgres

Extracting from SQLite

We have two options:

1. Create a dump:

josemarcosrf

black>=22.3.0
gitdb==4.0.9
itables~=1.1.2
ipython>=8.3.0
ipython-genutils==0.2.0
ipywidgets~=7.7.0
isort~=5.10.1
jupyter-client==7.3.0
jupyter-core==4.10.0
jupyter-server==1.17.0

josemarcosrf

# File to be found at: ~/.config/ngrok/ngrok.yml
# More info: https://ngrok.com/docs/ngrok-agent/config#config-ngrok

authtoken: <your-auth-token-here>

# To allow for transparent background
console_ui: true
console_ui_color: transparent

josemarcosrf

import json
import os
import tarfile
import numpy as np

import cv2

import matplotlib.pyplot as plt

from collections import defaultdict

josemarcosrf

# Version key/value should be on his own line
cat ./package.json | grep -m 1 version | sed 's/[^0-9.]//g'

echo $PACKAGE_VERSION

josemarcosrf

#!/usr/bin/env bash

set -e
set -o pipefail

say() {
 echo "$@" | sed \
         -e "s/\(\(@\(red\|green\|yellow\|blue\|magenta\|cyan\|white\|reset\|b\|u\)\)\+\)[[]\{2\}\(.*\)[]]\{2\}/\1\4@reset/g" \
         -e "s/@red/$(tput setaf 1)/g" \
         -e "s/@green/$(tput setaf 2)/g" \

josemarcosrf

/** 
 * Returns the URL of a hyperlinked cell, if it's entered with hyperlink command. 
 * Supports ranges
 * @param {A1}  reference Cell reference
 * @customfunction
 */
function linkURL(reference) {
  var sheet = SpreadsheetApp.getActiveSheet();
  var formula = SpreadsheetApp.getActiveRange().getFormula();
  var args = formula.match(/=\w+\((.*)\)/i);

josemarcosrf

This was tested on a ThinkPad P70 laptop with an Intel integrated graphics and an NVIDIA GPU:

lspci | egrep 'VGA|3D'
00:02.0 VGA compatible controller: Intel Corporation Device 191b (rev 06)
01:00.0 VGA compatible controller: NVIDIA Corporation GM204GLM [Quadro M3000M] (rev a1)

A reason to use the integrated graphics for display is if installing the NVIDIA drivers causes the display to stop working properly. In my case, Ubuntu would get stuck in a login loop after installing the NVIDIA drivers. This happened regardless if I installed the drivers from the "Additional Drivers" tab in "System Settings" or the ppa:graphics-drivers/ppa in the command-line.

josemarcosrf

#!/bin/bash

set -eu
set -o pipefail

say() {
 echo "$@" | sed \
         -e "s/\(\(@\(red\|green\|yellow\|blue\|magenta\|cyan\|white\|reset\|b\|u\)\)\+\)[[]\{2\}\(.*\)[]]\{2\}/\1\4@reset/g" \
         -e "s/@red/$(tput setaf 1)/g" \
         -e "s/@green/$(tput setaf 2)/g" \

josemarcosrf

#!/usr/bin/env bash

# set -e
# set -o pipefail


say() {
 echo "$@" | sed \
    -e "s/\(\(@\(red\|magenta\|yellow\|blue\|magenta\|cyan\|white\|reset\|b\|u\)\)\+\)[[]\{2\}\(.*\)[]]\{2\}/\1\4@reset/g" \
    -e "s/@red/$(tput setaf 1)/g" \