Skip to content

Instantly share code, notes, and snippets.

View mandrean's full-sized avatar

Sebastian Mandrean mandrean

  • Stockholm, Sweden
View GitHub Profile
v*[0-9].*[0-9].*[0-9]*(-rc*(.*[0-9]))

Keybase proof

I hereby claim:

  • I am mandrean on github.
  • I am mandrean (https://keybase.io/mandrean) on keybase.
  • I have a public key ASAFCcBYbsLUCrT0LXwZt_Kvgs0jKfrLstasWmhHP_P5nwo

To claim this, I am signing this object:

@mandrean
mandrean / cloud-config-controller
Created October 28, 2016 13:09
kube-aws fluentd/elastic search/kibana logging for kubernetes
# ...
write_files:
- path: /opt/bin/install-kube-system
permissions: 0700
owner: root:root
content: |
#!/bin/bash -e
# ...
# Custom replication controllers
@mandrean
mandrean / fix_csv_encoding_mac.md
Created September 1, 2015 14:15
Fix broken CSV encoding in Excel for Mac

Fix broken CSV encoding in Excel for Mac

Problem

Excel for Mac can't handle UTF-8 encoded CSV files. Official statement by Microsoft:

Excel for Mac does not currently support UTF-8. If this is a feature you’d like to see in future versions of Office for Mac, be sure to send your feedback by clicking “Help” > “Send Feedback” [...]

Solution

Convert the UTF-8 file to UTF-16 Little Endian by running this one-liner in Terminal:

( printf "\xff\xfe" ; iconv -f utf-8 -t utf-16le INPUT_UTF8_FILE.csv ) > OUTPUT_UTF16_FILE.csv
@mandrean
mandrean / app-store-ratings.php
Last active September 1, 2015 13:35 — forked from kentbye/app-store-ratings.php
Scrape iOS app review data from iTunes
<?php
/**
* Scrape the number of app reviews from iTunes.
*
* Set the iOS app id, and it creates a {$app_id}-reviews.csv file. Automatically scrapes all pages.
*
* @author Sebastian Mandrean <sebastian.mandrean@gmail.com>
* Modified and extended from Kent Byhas_e's gist at https://gist.github.com/kentbye/3740357
* Original gist by Sean Murphy at https://gist.github.com/1878352
*/

Each of these commands will run an ad hoc http static server in your current (or specified) directory, available at http://localhost:8000. Use this power wisely.

Discussion on reddit.

Python 2.x

$ python -m SimpleHTTPServer 8000
Download the following ZIPs:
ARM Translation Installer v1.1 (http://www.mirrorcreator.com/files/0ZIO8PME/Genymotion-ARM-Translation_v1.1.zip_links)
Download the correct GApps for your Android version:
Google Apps for Android 5.1 (https://www.androidfilehost.com/?fid=96042739161892865 - gapps-L-4-21-15.zip)
Google Apps for Android 5.0 (https://www.androidfilehost.com/?fid=95784891001614559 - gapps-lp-20141109-signed.zip)
Google Apps for Android 4.4.4 (https://www.androidfilehost.com/?fid=23501681358544845 - gapps-kk-20140606-signed.zip)
Google Apps for Android 4.3 (https://www.androidfilehost.com/?fid=23060877490000124 - gapps-jb-20130813-signed.zip)
Google Apps for Android 4.2 (https://www.androidfilehost.com/?fid=23060877490000128 - gapps-jb-20130812-signed.zip)