Skip to content

Instantly share code, notes, and snippets.

@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

@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 / 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 / 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 / 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 / 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 / php.ini
Created February 24, 2021 12:01
Optimized php.ini
[PHP]
;;;;;;;;;;;;;;;;;;;
; About php.ini ;
;;;;;;;;;;;;;;;;;;;
; PHP's initialization file, generally called php.ini, is responsible for
; configuring many of the aspects of PHP's behavior.
; http://php.net/engine
engine = On
@zkenstein
zkenstein / PushNotifications.php
Created November 24, 2020 10:57 — forked from joashp/PushNotifications.php
Simple PHP script to send Android Push Notification, iOS Push Notification and Windows Phone 8 Push Notification
<?php
// Server file
class PushNotifications {
// (Android)API access key from Google API's Console.
private static $API_ACCESS_KEY = 'AIzaSyDG3fYAj1uW7VB-wejaMJyJXiO5JagAsYI';
// (iOS) Private key's passphrase.
private static $passphrase = 'joashp';
// (Windows Phone 8) The name of our push channel.
private static $channelName = "joashp";
@zkenstein
zkenstein / docker-compose.yml
Created October 23, 2019 09:11 — forked from mikkelkrogsholm/docker-compose.yml
example docker-compose.yml for kong, postgres and konga
version: "3"
networks:
kong-net:
driver: bridge
services:
#######################################
# Postgres: The database used by Kong