Skip to content

Instantly share code, notes, and snippets.

Avatar
🏠
Working from home

Sukma Saputra ombak

🏠
Working from home
View GitHub Profile
View mysql_export_table_menjadi_csv_file_2.sql
SELECT iso, name, nicename, iso3, numcode, phonecode
FROM countries
INTO OUTFILE '/var/lib/mysql-files/countries01.csv'
FIELDS ENCLOSED BY ''
TERMINATED BY ','
ESCAPED BY ''
LINES TERMINATED BY '\r\n';
View mysql_export_table_menjadi_csv_file_1.sql
SELECT @@global.secure_file_priv;
-- karena saya menggunakan linux Debian 9, hasilnya adalah sebagai berikut
-- /var/lib/mysql-files
View artikel_docker_machine.sh
curl -L https://github.com/docker/machine/releases/download/v0.16.2/docker-machine-`uname -s`-`uname -m` >/tmp/docker-machine && chmod +x /tmp/docker-machine && sudo cp /tmp/docker-machine /usr/local/bin/docker-machine
View ten_command_line_tools_untuk_data_analisis_di_linux_1.sh
tail -n 3 jan2017articles.csv
tail -n 3 jan2017articles.csv
# 02 Jan 2017,Article,Scott Nesbitt,3 tips for effectively using wikis for documentation,1,/article/17/1/tips-using-wiki-documentation,"Documentation, Wiki",710
# 02 Jan 2017,Article,Jen Wike Huger,The Opensource.com preview for January,0,/article/17/1/editorial-preview-january,,358
# 02 Jan 2017,Poll,Jason Baker,What is your open source New Year's resolution?,1,/poll/17/1/what-your-open-source-new-years-resolution,,186
View ten_command_line_tools_untuk_data_analisis_di_linux_2.sh
head -n 1 jan2017articles.csv
#Post date,Content type,Author,Title,Comment count,Path,Tags,Word count
View ten_command_line_tools_untuk_data_analisis_di_linux_4.sh
grep -i "security" jan2017articles.csv
#30 Jan 2017,Article,Tiberius Hefflin,4 ways to improve your security online right now,3,/article/17/1/4-ways-improve-your-online-security,Security and encryption,1242
#28 Jan 2017,Article,Subhashish Panigrahi,How communities in India support privacy and software freedom,0,/article/17/1/how-communities-india-support-privacy-software-freedom,Security and encryption,453
#27 Jan 2017,Article,Alan Smithee,Data Privacy Day 2017: Solutions for everyday privacy,5,/article/17/1/every-day-privacy,"Big data, Security and encryption",1424
#04 Jan 2017,Article,Daniel J Walsh,50 ways to avoid getting hacked in 2017,14,/article/17/1/yearbook-50-ways-avoid-getting-hacked,"Yearbook, 2016 Open Source Yearbook, Security and encryption, Containers, Docker, Linux",2143
View ten_command_line_tools_untuk_data_analisis_di_linux_7.sh
cat jan20only.tsv
#20 Jan 2017 Article Kushal Das 5 ways to expand your project's contributor base 2 /article/17/1/expand-project-contributor-base Getting started 690
#20 Jan 2017 Article D Ruth Bavousett How to write web apps in R with Shiny 2 /article/17/1/writing-new-web-apps-shiny Web development 218
#20 Jan 2017 Article Jason Baker "Top 5: Shell scripting the Cinnamon Linux desktop environment and more" 0 /article/17/1/top-5-january-20 Top 5 214
#20 Jan 2017 Article Tracy Miranda How is your community promoting diversity? 1 /article/17/1/take-action-diversity-tech Diversity and inclusion 1007