-
Note: mysql
# do not use utf8, its not "real utf8"May 3, 2017 at 2:09:48 PM GMT+2 * - permalink -
CREATE DATABASE `foo` DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;
# use this :
# https://mathiasbynens.be/notes/mysql-utf8mb4#utf8-to-utf8mb4
CREATE DATABASE `foo` DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_unicode_ci;
CREATE USER 'foo'@'%' IDENTIFIED BY "password";
GRANT ALL ON `foo`.* TO "foo"@"%";
convert :
# For each database:
ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;
# For each table:
ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
# For each column:
ALTER TABLE table_name CHANGE column_name column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
# (Don’t blindly copy-paste this! The exact statement depends on the column type, maximum length, and other properties. The above line is just an example for a `VARCHAR` column.)
-
https://links.infomee.fr/?kmGPew
-
Note: s3 enpoint
May 2, 2017 at 9:51:18 AM GMT+2 - permalink -If you enable s3 enpoint in your route table, it's kind of tricky to know if the endpoint is really working. Two things to validate:
1) traceroute tcp before and after (traceroute -T s3-us-west-1.amazonaws.com 443)
You will see more hope when endpoint not activated
2) try an s3 sync cross region with enpoint activated : it should failed since it's not supported (yet @ 2017-05-02)
-
https://links.infomee.fr/?1wF2Kg
-
Fugitive.vim - exploring the history of a git repository
April 27, 2017 at 3:10:31 PM GMT+2 - permalink -:Glog
:clist
:cprev
:cnext
:cfirst
:clast
-
http://vimcasts.org/episodes/fugitive-vim-exploring-the-history-of-a-git-repository/
-
![thumbnail]()
-
Stupid Python Tricks: The KeyboardInterrupt Exception
catching all exception in pythonApril 21, 2017 at 4:19:03 PM GMT+2 * - permalink -
import traceback
for record in database:
try:
blabla
except (KeyboardInterrupt, SystemExit):
raise
except Exception as e:
# report error and proceed
print(type(e).__name__)
print(e)
print(traceback.format_exc())
Ne pas oublier de raise si on veut re-raise
-
http://effbot.org/zone/stupid-exceptions-keyboardinterrupt.htm
-
Configuring the AWS Command Line Interface - AWS Command Line Interface
April 21, 2017 at 12:01:30 PM GMT+2 - permalink -Pratique quand on doit jongler entre différents comptes AWS
et l'équivalent pour s3cmd : http://mikesisk.tumblr.com/post/8703449578/s3cmd-and-multiple-accounts
-
http://docs.aws.amazon.com/cli/latest/userguide/cli-chap-getting-started.html#cli-multiple-profiles
-
Note: Firefox fishing
April 21, 2017 at 9:33:37 AM GMT+2 - permalink -about:config
punycode
-
https://links.infomee.fr/?9ZMn_Q
-
![thumbnail]()
-
![thumbnail]()
-
![thumbnail]()
-
![thumbnail]()
-
Note: jq sort example
April 12, 2017 at 9:26:21 AM GMT+2 - permalink -|jq -r '.ApplicationVersions|sort_by(.DateCreated)|.[]|.VersionLabel'|tail -1
-
https://links.infomee.fr/?9B1NEQ
-
Welcome to Mastodon · Aldarone.fr
April 2, 2017 at 6:05:38 PM GMT+2 - permalink -C'est pas le 1er Twitter like décentralisé, est ce que ça va prendre ?
Via Skunnyk
-
https://aldarone.fr/welcome-to-mastodon/
-
![thumbnail]()
-
Note: diff -r overview
March 31, 2017 at 2:47:01 PM GMT+2 - permalink -diff -r folder1 folder2 | grep -P '(^diff|^Only)'
diff -r folder1 folder2 | grep -P '(^diff|^Only)' | sed -r 's/^diff -r /vimdiff /'
-
https://links.infomee.fr/?Gc4iwQ
-
![thumbnail]()
s3fs-fuse/s3fs-fuse: FUSE-based file system backed by Amazon S3
March 30, 2017 at 9:47:14 AM GMT+2 - permalink -I may have to use this one, but issue number is freaking me out
-
https://github.com/s3fs-fuse/s3fs-fuse
