Alex B. LOOKY ablooky

🎯

Focusing

R, Python and SQL coder | Areas of interest: environmental toxicology, pharmacology, data science, informatics including bioinformatics.

ablooky / server.R

Created April 8, 2020 13:21 — forked from trestletech/server.R

A Shiny app combining the use of dplyr and SQLite. The goal is to demonstrate a full-fledged, database-backed user authorization framework in Shiny.


	library(shiny)
	library(dplyr)
	library(lubridate)

	# Load libraries and functions needed to create SQLite databases.
	library(RSQLite)
	library(RSQLite.extfuns)
	saveSQLite <- function(data, name){
	path <- dplyr:::db_location(filename=paste0(name, ".sqlite"))

ablooky / passport.js

Created January 9, 2019 01:06 — forked from manjeshpv/passport.js

Passport.js using MySQL for Authentication with Express

	// config/passport.js

	// load all the things we need
	var LocalStrategy = require('passport-local').Strategy;

	var mysql = require('mysql');

	var connection = mysql.createConnection({
	host : 'localhost',
	user : 'root',