Skip to content

Instantly share code, notes, and snippets.

View beaudierman's full-sized avatar

Beau Dierman beaudierman

2 followers · 0 following
View GitHub Profile
@beaudierman
beaudierman / update-pip-packages.py
Created February 15, 2018 14:14
Update pip packages with a simple Python script, answer from https://stackoverflow.com/a/5839291
import pip
from subprocess import call
packages = [dist.project_name for dist in pip.get_installed_distributions()]
call("pip2 install --upgrade " + ' '.join(packages), shell=True)
@beaudierman
beaudierman / Pull-and-Sync-Data-Between-Google-Doc-Spreadsheet-and-MySQL.gs
Created April 19, 2018 18:10
You can pull data from MySQL database to Google doc spreadsheet auto with just click of a button or scheduled time. This is great use for retrieving data in spreadsheet format.
// MySQL to Google Spreadsheet By Pradeep Bheron
// Support and contact at pradeepbheron.com
function myMySQLFetchData() {
var conn = Jdbc.getConnection('jdbc:mysql://127.0.0.1:3306/employee_db', 'username', 'pass'); // Change it as per your database credentials
var stmt = conn.createStatement();
var start = new Date(); // Get script starting time
@beaudierman
beaudierman / keybase.md
Created May 23, 2022 15:49

Keybase proof

I hereby claim:

  • I am beaudierman on github.
  • I am beaudierman (https://keybase.io/beaudierman) on keybase.
  • I have a public key whose fingerprint is F501 39AA D307 41ED 6293 9F41 1503 B071 252D E1B2

To claim this, I am signing this object: