Prateek Sharma UnitedWithCode

Things one can get used to for the V8 Google Apps Scripts engine

A bit of a monologue about various syntax changes and adjustments in learning and using the tool.

Logging is slooooooow

That's why I wrote a library that writes to a spreadsheet instead. Ever since I started using it I'm far more productive. I don't know how people are still putting with that god-awful lagging logger.

Run a python script forever

In this section, we are going to show how to run a python script as a systemd service, allowing you to boot it at the start of a Linux machine and to maintain it alive.

Test method: Telegram Bot

We are going to use a very basic Telegram bot in order to test that our script will:

Automatically start when the machine boot
Automatically restart when it crashes/exits for whichever reason

MongoDB Cheat Sheet

Show All Databases

show dbs

	/**
	* Loading Animation Snippet
	*/

	.loading {
	color: transparent;
	background: linear-gradient(100deg, #eceff1 30%, #f6f7f8 50%, #eceff1 70%);
	background-size: 400%;
	animation: loading 1.2s ease-in-out infinite;
	}

	function doGet(e) {
	Logger.log(e);
	var op = e.parameter.action;
	var ss = SpreadsheetApp.open(DriveApp.getFileById("YOUR_SPREADSHEET_ID"));
	var sn = "YOUR_SHEET_NAME";
	var sheet = ss.getSheetByName(sn);


	if (op == "insert")
	return insert_value(e, sheet);

	# Run the last command as root
	sudo !!
	# Serve current directory tree at http://$HOSTNAME:8000/
	python -m SimpleHTTPServer
	# Save a file you edited in vim without the needed permissions
	:w !sudo tee %
	# change to the previous working directory
	cd -
	# Runs previous command but replacing
	^foo^bar

	#!/bin/bash

	##############################################################################
	# An rclone backup script by Chris Tippett ([email protected])
	#
	# Originally adapted from the great work by Jared Males ([email protected])
	# https://gist.github.com/jaredmales/2f732254bb10002fc0549fa9aa0abdd7
	#
	# Copyright (C) 2020 Chris Tippett ([email protected])
	#

	Mute these words in your settings here: https://twitter.com/settings/muted_keywords

	ActivityTweet
	generic_activity_highlights
	generic_activity_momentsbreaking
	RankedOrganicTweet
	suggest_activity
	suggest_activity_feed
	suggest_activity_highlights
	suggest_activity_tweet

	FutureBuilder(
	future: future,
	builder: (BuildContext context, AsyncSnapshot<String> snapshot) {
	double width;
	switch(snapshot.connectionState) {
	case ConnectionState.none:
	case ConnectionState.waiting:
	case ConnectionState.active:
	width = 0;
	break;

	const MY_DOMAIN = "agodrich.com"
	const START_PAGE = "https://www.notion.so/gatsby-starter-notion-2c5e3d685aa341088d4cd8daca52fcc2"
	const DISQUS_SHORTNAME = "agodrich"

	addEventListener('fetch', event => {
	event.respondWith(fetchAndApply(event.request))
	})

	const corsHeaders = {
	"Access-Control-Allow-Origin": "*",