Skip to content

Instantly share code, notes, and snippets.

View antonydevanchi's full-sized avatar
💭
I may be slow to respond.

Anton Piskunov antonydevanchi

💭
I may be slow to respond.
View GitHub Profile
@antonydevanchi
antonydevanchi / cloudflare-cdn-routing-anomaly-detailed-test.md
Created April 4, 2023 21:21 — forked from isaumya/cloudflare-cdn-routing-anomaly-detailed-test.md
Cloudflare CDN Routing Anomaly detailed test across multiple DNS resolvers

Cloudflare CDN Routing Anomaly Detailed Test Across Multiple DNS Resolvers

Here are some key details about my testing location and ISP:

Important Note: Keep an eye on the value of colo on the following response. As that value will show exactly from which Cloudflare CDN edge the data is getting served from. Moreover these 3 letter colo values are basically the IATA airport code on that city. So, you can use a website like World Airport Codes to find out the exact City and Country Name.

@antonydevanchi
antonydevanchi / postgresql_cheat_sheet.sql
Created March 9, 2023 13:15 — forked from krisiye/postgresql_cheat_sheet.sql
Useful queries for postgresql for monitoring queries and disk usage
-- Temporary file usage by database
SELECT datname AS "database", temp_files AS "Temporary files", temp_bytes
AS "Size of temporary files"
FROM pg_stat_database;
-- Cache Hit Ratio. Anything greater than 90% is always good
SELECT sum(blks_hit)*100/sum(blks_hit+blks_read) AS hit_ratio FROM pg_stat_database;
-- Top Queries
SELECT substr(query, 0, 250), calls,
#!/bin/bash
#
# 実行方法
#
# Mac のターミナルで以下を入力して実行
# sh -c "$(curl -fsSL https://gist.github.com/blendthink/5ca7dd072db6b0ebe5af8189d2cc5aad/raw)"
#
# 公式のドキュメントは以下
# https://developer.apple.com/documentation/technologies
@antonydevanchi
antonydevanchi / gist:8d6fce3f034e77a83ff0b2904d8fa50f
Created August 15, 2021 19:52
Flavor c6.6xlarge.2 is sold out
Terraform used the selected providers to generate the following execution plan.
Resource actions are indicated with the following symbols:
+ create
Terraform will perform the following actions:
# sbercloud_compute_instance.ecs_vision[0] will be created
+ resource "sbercloud_compute_instance" "%removed%" {
+ access_ip_v4 = (known after apply)
@antonydevanchi
antonydevanchi / kolduvachestvo.sh
Created July 27, 2021 03:32
Как читать SMS с блядского USB-модема «Yota 4G LTE» через консоль
#!/usr/bin/env bash
# Ahalai-mahalai
FLAG="GET_RCV_SMS_LOCAL"
PAGE="1"
# Krible-krable
XMLRESPONSE=$(curl -sL -XPOST 'http://10.0.0.1/xml_action.cgi?method=set&module=duster&file=message' \
<link rel="stylesheet"href="https://cdn.jsdelivr.net/npm/@fancyapps/ui/dist/fancybox.css"><script src="https://code.jquery.com/jquery-3.6.0.min.js"></script><script>$(document).ready(function(){var a=$(".js-list .js-slide img.sb-image-crop");0<a.length&&(a.each(function(a,t){t.attributes.forEach(function(a){"data-src"==a.name&&$(t).parent().html('<a data-fancybox="single" href="'+a.nodeValue+'">'+t.outerHTML+"</a>")})}),jQuery.ajax({url:"https://cdn.jsdelivr.net/npm/@fancyapps/ui/dist/fancybox.umd.js",dataType:"script",async:!0}))})</script>
@antonydevanchi
antonydevanchi / get_gists.py
Last active September 24, 2021 18:33 — forked from selimslab/get_gists.py
Download all Gists for a specific user
#!/usr/bin/env python3
import os
import sys
import json
import hashlib
import requests
from subprocess import call
from concurrent.futures import ThreadPoolExecutor as PoolExecutor
@antonydevanchi
antonydevanchi / 01-simple.py
Created June 14, 2021 22:33
How to get MD5 sum of a string using python?
import hashlib
m = hashlib.md5()
m.update("whatever your string is")
print m.hexdigest()
# Code is awesome.
# You can do it in dozens different ways and always wrong.
@antonydevanchi
antonydevanchi / AccountService.java
Created May 29, 2021 22:00 — forked from Amrsatrio/AccountService.java
some epic/fortnite endpoints
package com.tb24.fn.network;
import com.google.gson.JsonObject;
import com.tb24.fn.model.account.*;
import retrofit2.Call;
import retrofit2.http.*;
import java.util.List;
import java.util.Map;
@antonydevanchi
antonydevanchi / wp-perf.md
Created April 8, 2021 02:32 — forked from Ruzgfpegk/wp-perf.md
WordPress Performance & Development tips