Skip to content

Instantly share code, notes, and snippets.

Building pgModeler in MacOS with Homebrew

The official installation instructions for pgModeler recommends installing Xcode and the Enterprise DB distribution of Postgres to fulfill its build requirements. Luckily, Homebrew's got us covered!

  1. Checkout the source

    git clone https://github.com/pgmodeler/pgmodeler.git
    
@anjesh
anjesh / pylogger.R
Last active June 20, 2021 10:27 — forked from jonathancallahan/pylogger.R
R script that wraps futile.logger to emulate python style logging for six levels: TRACE, DEBUG, INFO, WARN, ERROR, FATAL.
#' @name logger.setup
#' @export
#' @title Set Up Python-Style Logging
#' @param traceLog file name or full path where \code{logger.trace()} messages will be sent
#' @param debugLog file name or full path where \code{logger.debug()} messages will be sent
#' @param infoLog file name or full path where \code{logger.info()} messages will be sent
#' @param warnLog file name or full path where \code{logger.warn()} messages will be sent
#' @param errorLog file name or full path where \code{logger.error()} messages will be sent
#' @param fatalLog file name or full path where \code{logger.fatal()} messages will be sent
#' @return No return value.
@anjesh
anjesh / mturk-api.php
Last active August 9, 2022 00:01
Mturk working code for `GetAccountBalance` with signature generation
<?php
# adapted from http://usefulangle.com/post/34/aws-s3-upload-api-php-curl and works with Mturk
$headerBlacklist = [
'cache-control' => true,
'content-type' => true,
'content-length' => true,
'expect' => true,
'max-forwards' => true,
'pragma' => true,
@anjesh
anjesh / rc-bulk-publishing-katalon.html
Last active February 14, 2019 16:58
RC Bulk Publishing Using Katalon
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta content="text/html; charset=UTF-8" http-equiv="content-type" />
<title>RC Bulk Publishing Tool</title>
</head>
<body>
<table cellpadding="1" cellspacing="1" border="1">
<thead>
@anjesh
anjesh / rc-publishing-kantu.json
Created February 11, 2019 04:58
Kantu script for automating RC contracts publishing
{
"Name": "rc-auto-publishing",
"CreationDate": "2019-2-11",
"Commands": [
{
"Command": "csvRead",
"Target": "rc-contracts.csv",
"Value": ""
},
{
@anjesh
anjesh / _ municipality-wardwise geojson
Last active July 14, 2021 03:45
municipality-wardwise geojson
contains the wardwise geojson data for some municipalities of nepal
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@anjesh
anjesh / prep.sh
Last active April 9, 2018 07:17
Script to prepare the individual sheets from multiple excel files for PPTIN
## download data
mkdir -p data
curl http://ppip.gov.np/excel-download/2013 -o data/2013.xlsx
curl http://ppip.gov.np/excel-download/2014 -o data/2014.xlsx
curl http://ppip.gov.np/excel-download/2015 -o data/2015.xlsx
curl http://ppip.gov.np/excel-download/2016 -o data/2016.xlsx
curl http://ppip.gov.np/excel-download/2017 -o data/2017.xlsx
## prepare individual sheets from all the excel files
mkdir -p out
@anjesh
anjesh / readme.md
Created August 27, 2017 03:41
mysql source compiling
  • Download mysql source

  • Ran the following cmake command based on the documentation

cmake \
  -DCMAKE_INSTALL_PREFIX=/usr/local/mac-dev-env/mysql-5.7.18 \
  -DCMAKE_CXX_FLAGS="-stdlib=libstdc++" \
  -DDEFAULT_CHARSET=utf8 \
  -DDEFAULT_COLLATION=utf8_general_ci \