jziggas

CREATE OR REPLACE FUNCTION drop_all_policies_on_table(
    target_schema text,
    target_table_name text
) RETURNS void LANGUAGE plpgsql AS $$
DECLARE 
    policy_name text;
    sql_text    text;
BEGIN 
    FOR policy_name IN (
        SELECT policyname 

jziggas

openapi: 3.0.1
info:
  title: gateway.marvel.com
  version: Cable
servers:
- url: http://gateway.marvel.com/
tags:
- name: public
paths:
  /v1/public/characters:

jziggas

Redshift specific

Models

Show status of a model

show model <name>;

List all models

jziggas

• brew services stop mysql
• sudo pkill mysqld
• sudo rm -rf /usr/local/var/mysql/ # NOTE: this will delete your existing database!!!
• brew postinstall mysql
• brew services restart mysql
• mysql -u root

https://stackoverflow.com/questions/32858216/error-1045-28000-access-denied-for-user-rootlocalhost-using-password-n

jziggas

// in your repo first run `npm ls -all -json true > PATH/TO/THIS/FILE/deps.json`
// run `node index.js`

const _ = require('lodash');
const fs = require('fs');
const axios = require('axios');

const file = fs.readFileSync('deps.json');
const json = JSON.parse(file);

jziggas

npm ls -all -parseable true | grep -oP '^.*\/\K.*$' | sort -u

jziggas

Mac OSX:
listening () {
	lsof -Pni | grep '(LISTEN)' | awk 'BEGIN {printf "%-15s %5s %21s\n", "Command", "PID", "PORT"} {printf "%-15s %5s %21s\n", $1,$2,$9}'
}

Linux (if you want non-you processes that are listening):
listening () {
	sudo lsof -Pni | grep '(LISTEN)' | awk 'BEGIN {printf "%-15s %5s %21s\n", "Command", "PID", "PORT"} {printf "%-15s %5s %21s\n", $1,$2,$9}'
}

jziggas

module.exports = function(Proj4js){
Proj4js.defs["EPSG:3819"] = "+proj=longlat +ellps=bessel +towgs84=595.48,121.69,515.35,4.115,-2.9383,0.853,-3.408 +no_defs";
Proj4js.defs["EPSG:3821"] = "+proj=longlat +ellps=aust_SA +no_defs";
Proj4js.defs["EPSG:3824"] = "+proj=longlat +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +no_defs";
Proj4js.defs["EPSG:3889"] = "+proj=longlat +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +no_defs";
Proj4js.defs["EPSG:3906"] = "+proj=longlat +ellps=bessel +towgs84=682,-203,480,0,0,0,0 +no_defs";
Proj4js.defs["EPSG:4001"] = "+proj=longlat +ellps=airy +no_defs";
Proj4js.defs["EPSG:4002"] = "+proj=longlat +ellps=mod_airy +no_defs";
Proj4js.defs["EPSG:4003"] = "+proj=longlat +ellps=aust_SA +no_defs";
Proj4js.defs["EPSG:4004"] = "+proj=longlat +ellps=bessel +no_defs";

jziggas

Angular Peformance Guidelines

Runtime strategies

These are the strategies we can use while the application is running in the browser.

Avoid function calls in view templates

Angular's zone can perform change detection every time there is a user interaction on the document, such as during a click, mouse move, timer tick, or http call. Therefore function calls in the template get invoked and recalculated each time this happens. This can add a lot of unnecessary overhead during runtime especially with complex logic or multiple function calls

jziggas

cat << EOF > ~/.gnupg/gpg-agent.conf
enable-ssh-support
pinentry-program /usr/local/bin/pinentry
default-cache-ttl 600
max-cache-ttl 7200
default-cache-ttl-ssh 1800
max-cache-ttl-ssh 7200
EOF