Tyler Littlefield tylerlittlefield

## Dockerfile
FROM yandex/clickhouse-server:${CLICKHOUSE_VERSION:-latest}

USER root
ARG UBUNTU_NAME=focal
ARG UBUNTU_VERSION=20.04

RUN echo "Begin ODBC install" && \
    #MySQL repo
    wget -qO- "http://keyserver.ubuntu.com/pks/lookup?op=get&search=0xa4a9406876fcbd3c456770c88c718d3b5072e1f5" | apt-key add - && \
    echo "deb http://repo.mysql.com/apt/ubuntu/ ${UBUNTU_NAME} mysql-8.0" >/etc/apt/sources.list.d/mysql-oracle.list && \

## 00_explanation.md

      
              6 files
            
          
              1 fork
            
          
              1 comment
            
          
              2 stars
            
          
                MattNickodemus
                / 00_explanation.md
            
            
              Last active
              October 29, 2020 14:29
            
              
                Configure macOS Catalina to connect to Oracle DB using RStudio and odbc library
              
          
    Setting up RStudio for Oracle pull using odbc on maxOS Catalina


install unixodbc using homebrew

You can install homebrew here. Once that is done, run this in the terminal.
brew install unixodbc

Download instant client from Oracle


## programming-as-theory-building.md

      
              1 file
            
          
              31 forks
            
          
              3 comments
            
          
              306 stars
            
          
                onlurking
                / programming-as-theory-building.md
            
            
              Last active
              April 19, 2024 22:31
            
              
                Programming as Theory Building - Peter Naur
              
          
    Programming as Theory Building

Peter Naur


Peter Naur's classic 1985 essay "Programming as Theory Building" argues that
a program is not its source code. A program is a shared mental
construct (he uses the word theory) that lives in the minds of the people who
work on it. If you lose the people, you lose the program. The code is merely a
written representation of the program, and it's lossy, so you can't reconstruct


## shiny-oauth.r
library(shiny)
library(httr)

# OAuth setup --------------------------------------------------------

# Most OAuth applications require that you redirect to a fixed and known
# set of URLs. Many only allow you to redirect to a single URL: if this
# is the case for, you'll need to create an app for testing with a localhost
# url, and an app for your deployed app.

## filters.R
library(shiny)

columnFilterUI <- function(id) {
  ns <- NS(id)
  uiOutput(ns("filter_container"))
}

columnFilter <- function(input, output, session, df, col_num, choice_filter) {
  # This renders a selectInput and only re-renders when the selected data
  # frame changes. (i.e. it doesn't re-render when filters change state.)

## read-access.sql
-- Create a group
CREATE ROLE readaccess;

-- Grant access to existing tables
GRANT USAGE ON SCHEMA public TO readaccess;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;

-- Grant access to future tables
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;

## GIF-Screencast-OSX.md

      
              2 files
            
          
              666 forks
            
          
              78 comments
            
          
              5314 stars
            
          
                dergachev
                / GIF-Screencast-OSX.md
            
            
              Last active
              May 2, 2024 05:55
            
              
                OS X Screencast to animated GIF
              
          
    OS X Screencast to animated GIF

This gist shows how to create a GIF screencast using only free OS X tools: QuickTime, ffmpeg, and gifsicle.

Instructions

To capture the video (filesize: 19MB), using the free "QuickTime Player" application:

  
## gist:1885435

      
              1 file
            
          
              867 forks
            
          
              187 comments
            
          
              2991 stars
            
          
                CristinaSolana
                / gist:1885435
            
            
              Created
              February 22, 2012 14:56
            
              
                Keeping a fork up to date
              
          
    1. Clone your fork:

git clone git@github.com:YOUR-USERNAME/YOUR-FORKED-REPO.git

2. Add remote from original repository in your forked repository:

cd into/cloned/fork-repo
git remote add upstream git://github.com/ORIGINAL-DEV-USERNAME/REPO-YOU-FORKED-FROM.git
git fetch upstream
	FROM yandex/clickhouse-server:${CLICKHOUSE_VERSION:-latest}

	USER root
	ARG UBUNTU_NAME=focal
	ARG UBUNTU_VERSION=20.04

	RUN echo "Begin ODBC install" && \
	#MySQL repo
	wget -qO- "http://keyserver.ubuntu.com/pks/lookup?op=get&search=0xa4a9406876fcbd3c456770c88c718d3b5072e1f5" \| apt-key add - && \
	echo "deb http://repo.mysql.com/apt/ubuntu/ ${UBUNTU_NAME} mysql-8.0" >/etc/apt/sources.list.d/mysql-oracle.list && \
	library(shiny)
	library(httr)

	# OAuth setup --------------------------------------------------------

	# Most OAuth applications require that you redirect to a fixed and known
	# set of URLs. Many only allow you to redirect to a single URL: if this
	# is the case for, you'll need to create an app for testing with a localhost
	# url, and an app for your deployed app.
	library(shiny)

	columnFilterUI <- function(id) {
	ns <- NS(id)
	uiOutput(ns("filter_container"))
	}

	columnFilter <- function(input, output, session, df, col_num, choice_filter) {
	# This renders a selectInput and only re-renders when the selected data
	# frame changes. (i.e. it doesn't re-render when filters change state.)
	-- Create a group
	CREATE ROLE readaccess;

	-- Grant access to existing tables
	GRANT USAGE ON SCHEMA public TO readaccess;
	GRANT SELECT ON ALL TABLES IN SCHEMA public TO readaccess;

	-- Grant access to future tables
	ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT SELECT ON TABLES TO readaccess;