gitlink
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67

Press enter to submit commands
 
> git init
 

Initialized empty Git repository in /.git/

Success!

$ git status
 

# On branch master
#
# Initial commit
#
nothing to commit (create/copy files and use "git add" to track)

Success!

$ git status
 

# On branch master
#
# Initial commit
#
# Untracked files:
#   (use "git add <file>..." to include in what will be committed)
#
# octocat.txt
nothing added to commit but untracked files present (use "git add" to track)

Success!

$ git add octocat.txt
 



Nice job, you've added octocat.txt to the Staging Area

$ git status
 

# On branch master
#
# Initial commit
#
# Changes to be committed:
#   (use "git rm --cached <file>..." to unstage)
#
# new file:   octocat.txt
#

Success!

$ git commit -m "Add cute octocat story"
 

[master (root-commit) 20b5ccd] Add cute octocat story
 1 file changed, 1 insertion(+)
 create mode 100644 octocat.txt

Success!

$ git add '*.txt'
Design

I started reading In the Bubble: Designing in a Complex World by John Thackara, and half way through the first chapter, I thought to myself, “I gotta share this content, because well shoot, we’re screwed.” That is if we don’t rethink the way we make products and live our lives.

The sustainability challenge is a significant design issue since eighty percent of a product, service, or system’s environmental impact is determined at the design stage.

The internet did not lead to a lighter economy and a cleaner environment as expected. We supposed that an information society would replace the industrial one, when in fact, we’ve only added to it. When computers could talk to printers, paper use in offices rose eightfold after we thought we had “gone digital”.

Read on →
Excel

A problem i usually run into when using excel is adding multiple values on the numpad and having to type [kbd]=[/kbd] on the keyboard. Kinda killing the flow.

Did you know there’s a numpad shortcut that allows you to keep your hand on the numpad completely when entering a values into a column instead of having.

The secret is the + key

Instead of typing this to parse arithmetic in excel =5+6+7+1+4+2 + hitting return

This works way faster:

1

+5+6+7+1+4+2 <kbd>enter</kbd>

Allowing you to keep you hand in the numpad the whole time

Database, Oracle, SQL

Today i’ve accomplished something so small yet so significant in my industry. I created my first query. Though i dabbled in MySQL when installing CMS for clients in the past, I never really been hands on with anything DB related.

This query ive made in oracle pulls a set amount of shipments from three joined tables and displays them in a neat concatenated statement.

In absence of INNER JOIN, i used aliases as attributes to columns to join them.

Oracle SQL 
1
2
3
4

SELECT 'Did you know Shipment (#'|| es.shipment_id||') is a '|| ewt.work_type|| ' work type which printed in Export Batch (#'|| es.exporting_batch_id ||'). This was exported on '||es.date_exported
FROM exporting_shipments es, exporting_flags ef, exporting_work_type ewt
WHERE  es.shipment_id = ef.shipment_id AND ef.work_type_id = ewt.id
and es.shipment_id < 04339740 AND es.shipment_id > 04339700