varungpt

Install

• sudo apt-get update
• cd
• wget https://codeload.github.com/pgmodeler/pgmodeler/tar.gz/v0.9.2
• tar -xvzf v0.9.2
• mv pgmodeler-0.9.2/ pgmodeler
• cd pgmodeler
• git clone https://github.com/pgmodeler/plugins assuming git is already installed
• install postgresql (how to install in different guide)
• sudo apt-get install make g++ qt5-qmake libxml2-dev libpq-dev pkg-config libqt5svg5-dev qttools5-dev

jlacko

# make certain jsonlite is available
if(!require(jsonlite, quietly = TRUE)) {
  install.packages("jsonlite")
  library(jsonlite)
}

# get the path to settings file
path <- if (Sys.info()[["sysname"]] == "Windows") {
  paste0(Sys.getenv('APPDATA'), "\\RStudio\\rstudio-prefs.json")
} else {

PurpleBooth

Features

• Automatically bump SemVer
• Update a personal homebrew tap
• Keep that pesky version in the Cargo.toml up to date
• (From dependabot) Get new versions out as soon as possible

Assumptions

• You don't want a changelog

ca057

command line tools for working with images to json

Extract all exif data as list into a json file:

exiftool -j -q dir > data.json

Sort the exif data by the original creation time:

jq 'sort_by(.DateTimeOriginal)' data.json

tomhicks

/*
Copy this into the console of any web page that is interactive and doesn't
do hard reloads. You will hear your DOM changes as different pitches of
audio.

I have found this interesting for debugging, but also fun to hear web pages
render like UIs do in movies.
*/

const audioCtx = new (window.AudioContext || window.webkitAudioContext)()

dlime

cmake_minimum_required(VERSION 3.5)

project(example LANGUAGES CXX)

set(CMAKE_CXX_STANDARD 11)
set(CMAKE_CXX_STANDARD_REQUIRED ON)

find_package(GTest REQUIRED)
include_directories(${GTEST_INCLUDE_DIRS})

reegnz

Implementing a jq REPL with fzf

Update: I created jq-zsh-plugin that does this.

One of my favourite tools of my trade is jq. It essentially enables you to process json streams with the same power that sed, awk and grep provide you with for editing line-based formats (csv, tsv, etc.).

Another one of my favourite tools is fzf.

raveenb

Connecting to an Android device over SSH

Initial Setup

Install Android App Termux from APKPure or AppStore. If the app exists, just delete and re-install it to get the latest version, The APK can be downloaded from https://apkpure.com/termux/com.termux/ Install the APK using by running

adb install ~/Downloads/Termux_v0.73_apkpure.com.apk

JamesChevalier

An area ID in Overpass is the OSM relation ID + 3600000000

This information is kind of buried in the Overpass API wiki page documenting the available filters: https://wiki.openstreetmap.org/wiki/Overpass_API/Overpass_QL#By_area_.28area.29

The OSM relation ID can be seen in two places:

• Visit https://www.openstreetmap.org and search for the city
• Click on its entry and you will be taken to a https://www.openstreetmap.org/relation/SOME_NUMBER_HERE page
• The relation ID is in the URL as "SOME_NUMBER_HERE" in the bullet point above
• The relation ID will also be in parentheses next to the city name in the left column

mdouchin

#Requires -RunAsAdministrator

<#
.Synopsis
   Download the OSGeo4W installer then download and install QGIS LTR (through the 'full' meta-package).
.DESCRIPTION
   This script will:
      1. change the current directory to the user downloads folder
      2. download the OSGeo4W installer
      3. launch it passing command-line parameters to DOWNLOAD packages required to QGIS LTR FULL