MohamedAlaa

tmux shortcuts & cheatsheet

start new:

tmux

start new with session name:

tmux new -s myname

kimus

First of all, it just seems like doing anything with Oracle is obnoxiously painful for no good reason. It's the nature of the beast I suppose. cx_oracle is a python module that allows you to connect to an Oracle Database and issue queries, inserts, updates..usual jazz.

Linux

Step 1:

sudo apt-get install build-essential unzip python-dev libaio-dev

Step 2. Click here to download the appropriate zip files required for this. You'll need:

backpackerhh

-- 1. Find the titles of all movies directed by Steven Spielberg.

SELECT title
FROM Movie
WHERE director = 'Steven Spielberg';


-- 2. Find all years that have a movie that received a rating of 4 or 5, and sort them in increasing order.

SELECT DISTINCT year

xluffy

Docker Cheat Sheet

• Why
• I just want a dev environment
• Prerequisites
• Installation
• Containers
• Images
• Registry and Repository

itbakery

##Linux Server Professional Certification LPIC-1 : Exam 101 ###Topic 101: สถาปัตยกรรมระบบ System Architecture ####101.1 การระบุและปรับแต่งฮาร์ดแวร์ (Determine and configure hardware setting) มีวัตถุประสงค์เพื่อการเรียนรู้เกี่ยวกับการกำหนดค่าของ hardware ซึ่งเป็นพื้นฐานสำคัญของการศึกษาระบบปฎิบัติการ Linux

1. HAL, dbus, udev
2. /sys, /proc , /dev
3. lsmod, lsusb, lspci และเรียนรู้เกี่ยวกับการกำหนดค่าต่างๆ ที่เกี่ยวข้องกับ Linux
4. set device ID
5. kernel module

vegaasen

SQL Cheat Sheet

Information

Dialects

Postgres

Show slow queries per database

IamAdiSri

First install pip for Python2. Download the get-pip.py file from https://bootstrap.pypa.io/get-pip.py
$ cd <download location>
$ sudo -H python ./get-pip.py

Installing pip also installs Python3
To run Python3
$ python3

Install pip3 by just executing the same file as in the step above, but this time using Python3
$ sudo -H python3 ./get-pip.py

fchollet

'''This script goes along the blog post
"Building powerful image classification models using very little data"
from blog.keras.io.
It uses data that can be downloaded at:
https://www.kaggle.com/c/dogs-vs-cats/data
In our setup, we:
- created a data/ folder
- created train/ and validation/ subfolders inside data/
- created cats/ and dogs/ subfolders inside train/ and validation/
- put the cat pictures index 0-999 in data/train/cats

fntlnz

Create Root CA (Done once)

Create Root Key

Attention: this is the key used to sign the certificate requests, anyone holding this can sign certificates on your behalf. So keep it in a safe place!

openssl genrsa -des3 -out rootCA.key 4096

barbietunnie

How to download your Udemy course videos using youtube-dl

$ youtube-dl --list-extractors | grep udemy

Steps

1. Get link to the course to download. e.g. https://www.udemy.com/course-name/
2. Login into udemy website, save the cookie from chrome using Chrome (Cookie.txt)[1] export extension. Save it to file udemy-cookies.txt
3. Get the link of the video that you want to download. usually in format. Use the command provided below where you have to replace the {course_link} and {path_to_cookies_file} with respective paths.

$ youtube-dl {course_link} --cookies {path_to_cookies_file}