Skip to content

Instantly share code, notes, and snippets.

@zkenstein
zkenstein / EthereumNodeGCP.md
Created May 21, 2021 18:47 — forked from learner-long-life/EthereumNodeGCP.md
How to Run an Ethereum (Geth Light) Node on GCP

How to Run an Ethereum Node in GCP

NOTE: This doc was created in 2018 and is no longer being kept up-to-date. There are some useful updates and Q&A in the comments, and Google has since disallowed cryptocurrency nodes explicitly in their Terms of Service. While I work on an updated how-to-run-a-node tutorial, you are welcome to join our ETH developer chat and share what you'd like to work on.

https://matrix.to/#/#invisible-college/cryptocoin:matrix.org?via=matrix.org&via=t2bot.io

@zkenstein
zkenstein / aws-point-domain
Created September 2, 2021 08:01 — forked from EmadAdly/aws-point-domain
Setup bitnami lamp stack point domain and vhost
## Point Domain to Amazon Web Services (AWS) EC2 Instance
1. Open the Amazon Route 53 console at [https://console.aws.amazon.com/route53/](https://console.aws.amazon.com/route53/).
2. If you are new to Amazon Route 53, you see a welcome page; choose **Get Started Now** for **DNS Management**. Otherwise, choose **Hosted Zones** in the navigation pane.
3. Choose **Create Hosted Zone**.
4. For **Domain Name**, type your domain name.
5. Choose **Create**.
6. Click the Hosted Zone, edit record set.
@zkenstein
zkenstein / imap-gmail
Created March 4, 2022 17:21 — forked from aikchun/imap-gmail
IMAP PHP gmail attachment extractor
<?php
/**
*
* Gmail attachment extractor.
*
* Downloads attachments from Gmail and saves it to a file.
* Uses PHP IMAP extension, so make sure it is enabled in your php.ini,
* extension=php_imap.dll
@zkenstein
zkenstein / GetCoordinates.xml
Created March 4, 2022 17:37 — forked from shobhit-ilfs/GetCoordinates.xml
Excel add-in script for geocoding address to geographical coordinates in MS Excel
Option Explicit
Function GetCoordinates(Address As String) As String
'-----------------------------------------------------------------------------------------------------
'This function returns the latitude and longitude of a given address using the Google Geocoding API.
'The function uses the "simplest" form of Google Geocoding API (sending only the address parameter),
'so, optional parameters such as bounds, key, language, region and components are NOT used.
'In case of multiple results (for example two cities sharing the same name), the function
'returns the FIRST OCCURRENCE, so be careful in the input address (tip: use the city name and the
@zkenstein
zkenstein / gmap.php
Created September 20, 2022 13:44 — forked from cam-gists/gmap.php
PHP: GMAP distance Class
<?php
/**
* @package Distance
* @license GPL
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
@zkenstein
zkenstein / cloud_sql_flags.md
Created January 8, 2024 06:47 — forked from stfeng2/cloud_sql_flags.md
Cloud SQL Flags Tuning

Important Notice

  • ❗ All flags and settings described here are subject to change without any notice.
  • Last update: September 2017

Introduction

This document describes a set of MySQL flags that have been tuned in Google Cloud SQL (Second Generation) to make the out-of-box experience better on Google Cloud. This is for your reference only, with the hope that some of the settings might also be useful outside the Google Cloud environment.

innodb_buffer_pool_size