cpursley

PostgreSQL is Enough

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

Background and Cron Jobs

KonradLinkowski

name: Build and Deploy
on:
  push:
    branches:
      - main # change to your desired branch name
jobs:
  build-and-deploy:
    runs-on: ubuntu-latest
    steps:
      - uses: actions/checkout@v2

zas

#!/bin/bash

cd

wget https://01.org/sites/default/files/downloads/intelr-graphics-linux/sklgucver61.tar.bz2 && \
tar xvjf sklgucver61.tar.bz2 && cd skl_guc_ver6_1/ && sudo ./install.sh

cd

wget https://01.org/sites/default/files/downloads/intelr-graphics-linux/kbldmcver101.tar.bz2 && \

TomAugspurger

Nemitek

import pandas as pd  
from random import random

flow = (list(range(1,10,1)) + list(range(10,1,-1)))*1000  
pdata = pd.DataFrame({"a":flow, "b":flow})  
pdata.b = pdata.b.shift(9)  
data = pdata.iloc[10:] * random()  # some noise  

import numpy as np

wordpressandphpdeveloper

<?php
//open database connection
$mysqli = new mysqli(<host>,<username>,<password>,<schema>);

//Display error message
if ($mysqli->connect_error) {
    die('Error : ('. $mysqli->connect_errno .') '. $mysqli->connect_error);
}

$sql="SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = '<schema name>'";

akras14

Git Cheat Sheet

Commands

Getting Started

git init

or

aneilbaboo

# save this file in the top level directory of your project as ".rvmrc"
# the virtualenv will be created/activated when you cd into the dir
if hash mkvirtualenv 2>/dev/null; then
    virtualenv_name=$(basename `git rev-parse --show-toplevel`)
    workon "$virtualenv_name"
    if [ "$?" != "0" ]; then
       mkvirtualenv "$virtualenv_name"
       echo "\"pip install -r requirements.txt\" to install libraries"
    fi
fi

bsweger

Useful Pandas Snippets

A personal diary of DataFrame munging over the years.

Data Types and Conversion

Convert Series datatype to numeric (will error if column has non-numeric values)
(h/t @makmanalp)

arngarden

import theano
from pylearn2.models import mlp
from pylearn2.training_algorithms import sgd
from pylearn2.termination_criteria import EpochCounter
from pylearn2.datasets.dense_design_matrix import DenseDesignMatrix
import numpy as np
from random import randint


class XOR(DenseDesignMatrix):