Skip to content

Instantly share code, notes, and snippets.

View Lysak's full-sized avatar
🎯
Focusing

Dmytrii Lysak

🎯
Focusing
21 followers · 72 following
View GitHub Profile
@Lysak
Lysak / friGate3_site_list.txt
Last active October 29, 2020 20:28
friGate3 site list for Ukraine
ip.fri-gate.org
*.2ip.ru [RU]
*.1tvcrimea.ru
*.2ch.hk
*.adfox.ru
*.antifashist.com
*.antimaydan.info
*.apiok.ru
*.attachmail.ru
*.auto.ru
@ianare
ianare / country.sql
Last active June 28, 2021 16:01
Import countries to PostgreSQL from geonames data
DROP TABLE "country";
CREATE TABLE "country" (
"iso" character(2) NOT NULL,
"iso3" character(3) NOT NULL,
"iso_numeric" character(3) NOT NULL,
"fips" character(2),
"name" character varying(128) NOT NULL,
"capital" character varying(128),
"area" float,
@cheshirrrcat
cheshirrrcat / remove-from-git-index
Created December 22, 2014 13:51
Удалить файл из индекса git-репозитория без его физического удаления
Для удаления файла из git-репозитория без его физического удаления:
git rm --cached mylogfile.log
Для удаления папки (рекурсивно) можно сделать так:
git rm -r --cached folderName
А для того, чтобы ситуация не повторялась, лучше добавьте файл или папку в .gitignore.
@TrevorJTClarke
TrevorJTClarke / ChromeEmulatorDeviceList.js
Created August 18, 2015 17:34
Chrome Emulator Device List and Properties
var emulatorDeviceList = [
{ name: 'Amazon Kindle Fire HDX', width: 2560, height: 1600, ratio: 2 },
{ name: 'Apple iPad', width: 1024, height: 768, ratio: 2 },
{ name: 'Apple iPad Mini', width: 1024, height: 768, ratio: 1 },
{ name: 'Apple iPhone 4', width: 320, height: 480, ratio: 2 },
{ name: 'Apple iPhone 5', width: 320, height: 568, ratio: 2 },
{ name: 'Apple iPhone 6', width: 375, height: 667, ratio: 2 },
{ name: 'Apple iPhone 6 Plus', width: 414, height: 736, ratio: 3 },
{ name: 'BlackBerry PlayBook', width: 1024, height: 600, ratio: 1 },
{ name: 'BlackBerry Z30', width: 360, height: 640, ratio: 2 },
@SerafimArts
SerafimArts / example-1.php
Last active April 17, 2022 10:47
phpwtf-1
<?php
$variable = 23;
[$query, $params] = sql(fn() => <<<SQL
SELECT * FROM users WHERE id = ${yield $variable} OR id = ${yield 42}
SQL);
var_dump($query, $params);
//
@certainlyakey
certainlyakey / functions.php
Last active December 5, 2022 02:08
Add metabox with key-value custom fields dynamically added by user
<?php
//Add metabox with dynamically added key-value (with more values possible) custom fields
//Based on http://wordpress.stackexchange.com/questions/19838/create-more-meta-boxes-as-needed/19852#19852
// Caution, there're 2 set of options below
//Variables used in the following functions should be mentioned in the 'global' statement of each of them appropriately
//=======Options 1=======
$dmb_post_type = 'tribe_events';
$dmb_metabox_label = 'Other information';
$dmb_cf_name = 'tribe_events_miscinfo';
@whour
whour / Sublime Text Licence Key Build 3156
Created December 12, 2017 02:49 — forked from dr3772/Sublime Text Licence Key Build 3156
Sublime Text Dev Build 3156 Serial Key
----- BEGIN LICENSE -----
eldon
Single User License
EA7E-1122628
C0360740 20724B8A 30420C09 6D7E046F
3F5D5FBB 17EF95DA 2BA7BB27 CCB14947
27A316BE 8BCF4BC0 252FB8FF FD97DF71
B11A1DA9 F7119CA0 31984BB9 7D71700C
2C728BF8 B952E5F5 B941FF64 6D7979DA
B8EB32F8 8D415F8E F16FE657 A35381CC
@brandonsimpson
brandonsimpson / osx_uninstall_mysql_install_mariadb_homebrew.md
Last active August 19, 2023 22:55
OSX How To: Uninstall native MySQL and install MariaDB via Homebrew

OSX How To: Uninstall native MySQL and install MariaDB via Homebrew

This is a short overview on how to completely remove any old mysql server installs in OSX and upgrade to MariaDB without conflicts. Things can get a bit weird when you have various old installs of MySQL server floating around, and utilizing homebrew to install and upgrade MariaDB as a drop in replacement for MySQL has worked well, especially if you're used to managing MySQL installs via yum in linux.

First: Backup Your Data!

Backup all of your current databases with mysqldump

This isn't a tutorial on backups, and there are many ways to do it. You should know how to backup your data anyway. For this example, we'll do a full backup of our InnoDB databases.

@ba11b0y
ba11b0y / installing-postman.md
Last active August 31, 2023 19:21
Installing Postman on Ubuntu/Gnome

Since Chrome apps are now being deprecated. Download postman from https://dl.pstmn.io/download/latest/linux

Although I highly recommend using a snap

sudo snap install postman

Installing Postman

tar -xzf Postman-linux-x64-5.3.2.tar.gz
@azhe403
azhe403 / ESD Windows 10 All Language (OS Build 16299.64)
Last active October 14, 2023 11:22
ESD Windows 10 All Language (OS Build 16299.64)
📢ESD -> Windows 10, Version 1709, Refresh November 2017, #Redstone_3 aka #FallCreatorsUpdate or #FCU are now available via WSUS/WU!
📌what is it Refresh? #RTM Refresh #FCU build 16299.15.rs3_release.170928-1534 + #CumulativeUpdate #KB4048955 = OS Refresh RTM-GDR Build 10.0.16299.64.rs3_release_svc.171024-1647
📌URL source-> https://download.microsoft.com/download/1/8/4/1842B01F-2F6F-481C-A86F-0B62E14B259E/ProductsRS311202017.xml
📌DownLoad ESD decrypt-multi-release (v171022): https://rg-adguard.net/dl-decrypt
by @rgadguard/WZT/Azhe403
http://fg.ds.b1.download.windowsupdate.com/d/Upgr/2017/11/16299.0.171109-1522.rs3_release_svc_refresh_clientconsumer_ret_x64fre_ar-sa_5fb06ecc3bb7015893799db672e64f05909de114.esd
http://fg.ds.b1.download.windowsupdate.com/d/Upgr/2017/11/16299.0.171109-1522.rs3_release_svc_refresh_clientconsumer_ret_x86fre_ar-sa_85d00eda8b717d0fff5f5332919f3853c82056bd.esd