StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

USkev
primarykey
Id
348785
data
Age
CreationDate
2010-05-24T09:03:30.193
DownVotes
13
LastAccessDate
2018-09-01T10:06:22.460
Reputation
98016
UpVotes
431
Views
3090
AccountId
141612
DisplayName
kev
EmailHash
text
Location
Taiwan
AboutMe
<blockquote> <p>Simplicity is the ultimate sophistication. <em>— Leonardo Da Vinci</em> </p> </blockquote> <h2>less is more</h2> <ul> <li>The basic problem is actually very complicated.</li> <li>It's amazing that computers only use <code>0s</code> and <code>1s</code>.</li> </ul> <hr> <h2>handy tools</h2> <pre><code># download bigfile $ aria2c -c -k1M -{x,j,s}16 --checksum=md5=dccff28314d9ae4ed262cfc6f35e5153 http://mirrors.zju.edu.cn/ubuntu-releases/14.04/ubuntu-14.04-desktop-amd64.iso # backup txt files $ rsync -avzm --include '*/' --include '*.txt' --exclude '*' source/ remote:target/ # transfer file at 100kB/s $ rsync -hP --bwlimit 100 remote:file . # convert json to csv $ jq -r '[.field1,.field2,.field3]|@csv' input.json > output.csv # convert socks5 to http $ delegate -P8080 SERVER=http SOCKS=1.2.3.4:1080 ADMIN=admin@datageek.info # convert socks5 to http with auth $ delegated -f -P8080 SERVER=http FORWARD=socks://user:pass@1.2.3.4:1080 ADMIN=admin@datageek.info # zero-padding file names $ rename 's/^\d+/sprintf("%02d", $&)/e' [0-9]* # concat video parts $ printf "file '%s'\n" part*.mp4 | ffmpeg -f concat -i - -c copy all.mp4 # scan raspberry pi $ sudo nmap -n -sP 192.168.1.0/24 -oX - | xmlstarlet sel -t -m '//host[address[contains(@vendor, "Raspberry Pi")]]/address[@addrtype="ipv4"]/@addr' -v . -n | ssh-keyscan -t rsa -f - | sort -u - ~/.ssh/known_hosts -o ~/.ssh/known_hosts # upgrade all outdated python packages $ pip list --outdated | awk '{print $1}' | xargs -tn1 pip install # generate birthday wordlist for aircrack-ng $ python > birthday.txt -c ' > from datetime import datetime as dt > for i in range(dt(1970, 1, 1).toordinal(), dt(2016, 1, 1).toordinal()): > print(dt.fromordinal(i).strftime("%Y%m%d")) > ' # install python on raspberry pi $ ansible pi --limit pi2 -e ansible_user=alarm --ask-pass --su --ask-su-pass -m raw -a 'pacman -Sy --noconfirm python2' # resize sdcard for raspberry pi $ echo -e 'p\nd\n2\nn\np\n2\n\n\np\nw' | fdisk /dev/mmcblk0 $ reboot $ resize2fs /dev/mmcblk0p2 # authorized key initialization $ sshpass -p xxxxxx ssh-copy-id -o StrictHostKeyChecking=no user@server # open google chrome in full-screen mode $ open -a 'Google Chrome' --args --kiosk https://github.com/ # customized hostname $ curl --resolve 'httpbin:80:23.22.14.18' http://httpbin/headers # add ssh pubkey to multiple servers $ ansible rpi -m authorized_key -a 'user=pi key="ssh-rsa ..."' </code></pre>
WebsiteUrl
https://blog.easypi.pro/
plurals
PostsLastEditorUserIdLastEditDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
3. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostsOwnerUserIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. POHow can i convert between F# List and F# Tuple?
  singulars
  PostTypePostTypeId
  PTQuestion
3. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesUserIdCreationDate
CommentsUserIdCreationDate

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.