Kartones

Keyboard shorcuts

• CTRL + SHIFT + p: Command panel
• CTRL + p: File search
• CTRL + r: Method search inside current file
• CTRL + g: Go to line #
• CTRL + SHIFT + [: Fold code
• CTRL + SHIFT + ]: Unfold code
• ALT + SHIFT + 2: Double column/file mode
• ALT + SHIFT + 1: Single column/file mode

ianjuma

worker_processes  5;

error_log  /var/log/nginx/error.log;
pid        /var/log/nginx/nginx.pid;
worker_rlimit_nofile 8192;


events {
  worker_connections  4096;
  use epoll;

mockra

 server {
  listen   80;

  root /var/www/yourdomain.com/public;
  index index.html index.htm;

  server_name yourdomain.com;
  
  location / {
   default_type "text/html";

mderazon

/*
 * script to export data in all sheets in the current spreadsheet as individual csv files
 * files will be named according to the name of the sheet
 * author: Michael Derazon
*/

function onOpen() {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  var csvMenuEntries = [{name: "export as csv files", functionName: "saveAsCSV"}];
  ss.addMenu("csv", csvMenuEntries);

vincent178

SQLite3 Cheat Sheet

Info

Download from: http://www.sqlite.org/download.html Getting Started: http://www.sqlite.org/sqlite.html Documentation: http://www.sqlite.org/docs.html

labnol

Learning Google Apps Script

Find the best resources for learning Google Apps Script, the glue that connects all Google Workspace services including Gmail, Google Drive, Calendar, Google Sheets, Forms, Maps, and more.

A good place to learn more about Google Apps Script is the official documentation available at developers.google.com. Here are other Apps Script resources that will help you get up to speed.

1. Google Apps Script Code Samples by Amit Agarwal
2. Google Apps Script Development - Create Google Apps Script projects locally inside VS Code - video tutorial
3. Awesome Google Scripts by Amit Agarwal
4. Google Developer Experts - Follow Apps Scr

Kartones

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

LeCoupa

# NPM CheatSheet.
# Super easy intall: npm comes with node now.
# To create your own npm package: https://www.npmjs.org/doc/misc/npm-developers.html
# More: https://www.npmjs.org/doc/


# 1. NPM Command Lines.
# Local mode is the default.
# Use --global or -g on any command to operate in global mode instead.

dustintheweb

###Setting up a Google Cloud Git Repo // now with SourceTree bonus!
*Note: this guide is relavent only to repos natively hosted on Google Cloud

---

**Prereq:** - OSX - SourceTree - git - A Google App Engine / Cloud project

Zearin

NOTE: This is a question I found on StackOverflow which I’ve archived here, because the answer is so effing phenomenal.

---

Q: How can I make a chain of function decorators in Python?

---

If you are not into long explanations, see [Paolo Bergantino’s answer][2].