Skip to content

Instantly share code, notes, and snippets.

View ombak's full-sized avatar
🎯
Focusing

Sukma Saputra ombak

🎯
Focusing
25 followers · 28 following
View GitHub Profile
@ombak
ombak / bubblesort_dengan_python.py
Last active May 30, 2020 14:30
# -*- coding: utf-8 -*-
def bubbleSort(mylist):
# outer loop
for i in range(len(mylist)-1, 0, -1):
# inner loop
for j in range(i):
if mylist[j] > mylist[j+1]:
# swap the value
temp = mylist[j]
@ombak
ombak / mysql_export_table_menjadi_csv_file_1.sql
Last active May 28, 2020 00:47
SELECT @@global.secure_file_priv;
-- karena saya menggunakan linux Debian 9, hasilnya adalah sebagai berikut
-- /var/lib/mysql-files
@ombak
ombak / mysql_export_table_menjadi_csv_file_2.sql
Last active May 28, 2020 00:47
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';
@ombak
ombak / artikel_docker_machine.sh
Created May 28, 2020 01:23
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
@ombak
ombak / ten_command_line_tools_untuk_data_analisis_di_linux_1.sh
Created May 28, 2020 01:41
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
@ombak
ombak / ten_command_line_tools_untuk_data_analisis_di_linux_2.sh
Last active May 28, 2020 01:59
head -n 1 jan2017articles.csv
#Post date,Content type,Author,Title,Comment count,Path,Tags,Word count
@ombak
ombak / ten_command_line_tools_untuk_data_analisis_di_linux_3.sh
Created May 28, 2020 02:00
wc -l jan2017articles.csv
# 93 jan2017articles.csv
@ombak
ombak / ten_command_line_tools_untuk_data_analisis_di_linux_4.sh
Created May 28, 2020 02:01
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
@ombak
ombak / ten_command_line_tools_untuk_data_analisis_di_linux_5.sh
Created May 28, 2020 02:02
grep -i "security" jan2017articles.csv | wc -l
# 4
@ombak
ombak / ten_command_line_tools_untuk_data_analisis_di_linux_6.sh
Created May 28, 2020 02:03
grep "20 Jan 2017" jan2017articles.csv | tr ',' '\t' > jan20only.tsv