hengstchon

MongoDB Cheat Sheet

show dbs

User timeline: https://m.weibo.cn/container/getIndex?type=uid&value={uid}&containerid=107603{uid}&page={pagenum} e.g. https://m.weibo.cn/container/getIndex?type=uid&value=3053424305&containerid=1076033053424305&page=1
Status details: https://m.weibo.cn/statuses/show?id={status_mid} e.g. https://m.weibo.cn/statuses/show?id=4154099588849643
Status comments: https://m.weibo.cn/api/comments/show?id={status_mid}&page={pagenum} e.g. https://m.weibo.cn/api/comments/show?id=4154099588849643&page=1
Status reposts: https://m.weibo.cn/api/statuses/repostTimeline?id={status_mid}&page={pagenum}

Instuctions available (moved) at REMOTE ORIGIN website: Extract Subtitles From mkv

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

-E: will describe the underlaying queries of the \ commands (cool for learning!)
-l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

People

	import React from 'react';
	import videojs from 'video.js';
	import 'video.js/dist/video-js.css';

	// video.js player from the docs: https://github.com/videojs/video.js/blob/master/docs/guides/react.md

	class VideoPlayer extends React.Component {
	componentDidMount() {
	// instantiate Video.js
	this.player = videojs(this.videoNode, this.props, function onPlayerReady() {

	# This script may use ~8 MiB Memory, it is fast and safe

	def find_IP(dns_ser, domain, timeout = 2):
	import dns.resolver, sys
	try:
	T = dns.resolver.Resolver(); T.nameservers = [dns_ser, ]; T.timeout = T.lifetime = timeout
	answers = T.query(domain, raise_on_no_answer=False)
	return [rdata for rdata in answers]
	except Exception as e:
	if e.__class__.__base__ == dns.exception.DNSException: