Skip to content

Instantly share code, notes, and snippets.

View buonzz's full-sized avatar

Darwin Biler buonzz

View GitHub Profile
@buonzz
buonzz / google-play.md
Last active January 29, 2025 13:21
google play app store checklist
  • App name
  • Short description - 80 chars
  • Full description - 400 chars
  • App icon - Your app icon must be a PNG or JPEG, up to 1 MB, 512 px by 512 px
  • Feature graphic - must be a PNG or JPEG, up to 15 MB, and 1,024 px by 500 px
  • Video - Add a video by entering a YouTube URL. This video must be public or unlisted, ads must be turned off, and it must not be age restricted.
  • Phone screenshots - Upload 2-8 phone screenshots. Screenshots must be PNG or JPEG, up to 8 MB each, 16:9 or 9:16 aspect ratio, with each side between 320 px and 3,840 px
  • 7-inch tablet screenshots - Upload up to eight 7-inch tablet screenshots. Screenshots must be PNG or JPEG, up to 8 MB each, 16:9 or 9:16 aspect ratio, with each side between 320 px and 3,840 p
  • 10-inch tablet screenshots - Upload up to eight 10-inch tablet screenshots. Screenshots must be PNG or JPEG, up to 8 MB each, 16:9 or 9:16 aspect ratio, with each side between 1,080 px and 7,680 px
@buonzz
buonzz / pdf.md
Last active December 5, 2024 12:18
pdf

Two standards

  • Acrobat Forms or AcroForms
  • XFA Forms (sometimes called Designer Forms)

AcroForms

  • Internally AcroForms are annotations or fields applied to a PDF document.
  • AcroForms are filled using a Forms Data Format (FDF) file
@buonzz
buonzz / awesome-windows.md
Last active April 20, 2024 13:17
Awesome Windows
@buonzz
buonzz / aws_api_gateway.md
Last active February 18, 2024 16:21
AWS API Gateway

REST vs HTTP API

Choose REST APIs if you need features such as API keys, per-client throttling, request validation, AWS WAF integration, or private API endpoints. Choose HTTP APIs if you don't need the features included with REST APIs

HTTP Proxy Integrations w/ API key

  • Create new resource: method is ANY resource with {proxy+} as path
  • In method details, choose HTTP
  • in http method: ANY
  • in Endpoint URL: https://yourapi.example.com/path/{proxy} note that you cannot use root path here /, it has to be some subpath
  • ensure "HTTP proxy integration" is checked
  • click Save
@buonzz
buonzz / json_extract_mysql_5.6.sql
Created July 11, 2022 04:07
json extract mysql 5.6
DELIMITER $$
DROP function if exists json_extract_c$$
CREATE FUNCTION json_extract_c(
details TEXT,
required_field VARCHAR (255)
) RETURNS TEXT CHARSET utf8mb4
DETERMINISTIC
NO SQL
BEGIN
DECLARE search_term, val TEXT;
@buonzz
buonzz / sample-data-temp.json
Created November 19, 2020 14:48
sample data temp
{
"_embedded": [
{
"id": "RPT200090",
"created": "2020-07-22T14:45:37Z",
"modified": "2020-07-22T15:53:04Z",
"startDate": "2020-07-31",
"endDate": "2020-08-30",
"status": "arranging",
"agentRole": "managed",
@buonzz
buonzz / flutter_cheatsheet.md
Last active December 14, 2024 15:19
flutter cheatsheet

Installation

clone

git clone https://github.com/flutter/flutter.git -b stable

add the flutter/bin to your PATH variable

run flutter doctor

@buonzz
buonzz / aws-acm.md
Last active May 29, 2020 01:33
AWS Certificate Manager
  • X.509 - format of certificate for public and private keys
  • CMK - customer master key, to encrypt the private key
  • CA - certificate authority, entity that issues digital certificates. this is set in DNS record CAA to allow a CA to issue certificate for that domain
  • https://crt.sh/?q=darwinbiler.com. - lets you see the certificates issued to your domain (certificate transparency log). browsers used this to detect any anomaly in certificate
  • SCT - Signed Certificate Timestamp, ACM submits the certificate to at least two certificate transparency log servers. These servers add the certificate to their public databases and return a signed certificate timestamp (SCT) to the Amazon CA. it is then included in your X.509 certificate
  • TLD - rightmost label in the domain name, like .com .edu .gov
  • Apex domain - domain name + TLD example.com
  • FQDN - complete DNS name
@buonzz
buonzz / xdebug_cheatsheet_macos.md
Last active May 10, 2020 07:56
xdebug cheatsheet for MacOS

Profiling

is where you can find the profiling info generated by xdebug

xdebug.profiler_output_dir = /var/tmp

profile the page you visited when the XDEBUG_PROFILE variable is present in cookie/POST/GET

@buonzz
buonzz / install_jenkins.sh
Created May 2, 2020 02:24
Install Jenkins
wget -q -O - https://pkg.jenkins.io/debian-stable/jenkins.io.key | sudo apt-key add -
sudo apt-add-repository "deb https://pkg.jenkins.io/debian-stable binary/"
apt-get update
apt-get install jenkins