cpursley

PostgreSQL is Enough

• Simplify: move code into database functions
• Just Use Postgres for Everything
• Just use Postgres
• PostgreSQL is the worlds’ best database
• Postgres is eating the database world
• Hacker News discussion

Background and Cron Jobs

malakka

// Licence: Robert Koch-Institut (RKI), dl-de/by-2-0
const newCasesApiUrl = `https://services7.arcgis.com/mOBPykOjAyBO2ZKk/arcgis/rest/services/RKI_COVID19/FeatureServer/0/query?f=json&where=NeuerFall%20IN(1%2C%20-1)&returnGeometry=false&spatialRel=esriSpatialRelIntersects&outFields=*&outStatistics=%5B%7B%22statisticType%22%3A%22sum%22%2C%22onStatisticField%22%3A%22AnzahlFall%22%2C%22outStatisticFieldName%22%3A%22value%22%7D%5D&resultType=standard&cacheHint=true`;

const incidenceUrl = (location) => `https://services7.arcgis.com/mOBPykOjAyBO2ZKk/arcgis/rest/services/RKI_Landkreisdaten/FeatureServer/0/query?where=1%3D1&outFields=GEN,last_update,cases,cases7_per_100k&geometry=${location.longitude.toFixed(3)}%2C${location.latitude.toFixed(3)}&geometryType=esriGeometryPoint&inSR=4326&spatialRel=esriSpatialRelWithin&returnGeometry=false&outSR=4326&f=json`

const saveIncidenceLatLon = (location) => {
 let fm = FileManager.iCloud()
 let path = fm.joinPath(fm.documentsDirectory(), "covid19latlon.json")
 fm.writeStrin

SimonSimCity

#!/bin/bash
#
# Notify of Homebrew updates via Notification Center on Mac OS X
#
# Author: Chris Streeter http://www.chrisstreeter.com
# Requires: terminal-notifier. Install with:
#   brew install terminal-notifier

TERM_APP='/Applications/Terminal.app'
BREW_EXEC='/usr/local/bin/brew'

xavierlacot

$ cd /System/Library/QuickLook
$ sudo wget http://trinity.neooffice.org/downloads/neopeek.qlgenerator.tgz | tar xzvf

nemf

#!/bin/sh

# chkconfig:   - 85 15

### BEGIN INIT INFO
# Version  : 0.2
# Author : Fabrice MARCHAL
# Provides:          sparkleshare
# Short-Description: SparkleShare Dashboard
# Description:       Launches the SparkleShare Dashboard as service.

Rathgore

MAIL_SERVER = ''
USERNAME = ''
PASSWORD = ''
MAILBOX = 'Spam'
MAX_DAYS = 7 # Deletes messages older than a week

import imaplib
import datetime

today = datetime.date.today()

stevenhaddox

Two ways to do it, but only worked for me so I'll put it first and the second for reference:

$ openssl pkcs12 -export -in hostname.crt -inkey hostname.key -out hostname.p12
$ openssl pkcs12 -in hostname.p12 -nodes -out hostname.pem

Other options for this method in comments below:

# Note, the -certfile root.crt appends all CA certs to the export, I've never needed these so it's optional for my personal steps
$ openssl pkcs12 -export -in hostname.crt -inkey hostname.key -certfile root.crt -out hostname.p12

Note, I've always had my hostname.crt as part of my .pem, so I keep my certs but apparently you may not have to, hence the nocerts flag being an extra option in this sample

Chris927

# add repos and update apt
sudo add-apt-repository ppa:git-core/ppa
sudo add-apt-repository ppa:warp10/sparkleshare
sudo apt-get update

# install it
sudo apt-get install sparkleshare