Prateek Sharma UnitedWithCode

Introduction

An introduction to curl using GitHub's API.

The Basics

Makes a basic GET request to the specifed URI

curl https://api.github.com/users/caspyin

How to "Schedule Automatic Backups" of your Google Sheets

This tutorial demonstrates how to use Google Apps Script to:

Create copies of the Google Sheet in the desired destination folder automatically at set intervals.
Append the time stamp with each backup file's name.
Adjust time trigger for backing up every day/hour/minute.

A List of Ephemeral File Sharing Services

Contributions welcome.

~ Prajjwal Singh

Service	CLI?	Max Size	Direct Access	Files Expire?	Can Limit Download Count?	Password Protection	HTTPS
c-v.sh	`curl -F`	4 GB	Yes	Yes, by Mister Alg.	No	No	Enforced
FileIO	Yes	5 GB	Yes	Optionally	Fixed @ 1	No	Yes

What is your folder-structure preference for a large-scale Node.js project?

0: Starting from Rails

This is the reference point. All the other options are based off this.

|-- app
|   |-- controllers
|   |   |-- admin

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

I know. Everyone knows.

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.

Bash Shortcuts

Moving

command	description
ctrl + a	Goto BEGINNING of command line

Overview

This collection of files serves as a simple static demonstration of how to post to a google spreadsheet from an external html <form> following the example by Martin Hawksey

Depreciation Warning: This code is not maintained, and should be seen as reference implementation only. If you're looking to add features or update, fork the code and update as needed.

Run example

You should be able to just open index.html in your browser and test locally.

	user web;

	# One worker process per CPU core.
	worker_processes 8;

	# Also set
	# /etc/security/limits.conf
	# web soft nofile 65535
	# web hard nofile 65535
	# /etc/default/nginx

	// Lists of countries with ISO 3166 codes, presented in various formats.
	// Last Updated: July 30, 2020

	// If you're using PHP, I suggest checking out:
	// https://github.com/thephpleague/iso3166
	// or Laravel: https://github.com/squirephp/squire
	//
	// JS developers can check out:
	// https://www.npmjs.com/package/iso3166-2-db
	//

	function exportSpreadsheet() {

	//All requests must include id in the path and a format parameter
	//https://docs.google.com/spreadsheets/d/{SpreadsheetId}/export

	//FORMATS WITH NO ADDITIONAL OPTIONS
	//format=xlsx //excel
	//format=ods //Open Document Spreadsheet
	//format=zip //html zipped