Steven Lee alitrack

Installing Apache Superset on Windows 10

⚠️ WARN: This doc might be outdated. Use with caution. Only tested with Python v3.7

🙋‍♂️ INFO: If you have fixes/suggestions to for this doc, please comment below.

🌟 STAR: This doc if you found this document helpful.

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)

	#coding=utf8
	import itchat
	# tuling plugin can be get here:
	# https://github.com/littlecodersh/EasierLife/tree/master/Plugins/Tuling
	from tuling import get_response

	@itchat.msg_register('Text')
	def text_reply(msg):
	if u'作者' in msg['Text'] or u'主人' in msg['Text']:
	return u'你可以在这里了解他：https://github.com/littlecodersh'

	# rm -r /tmp/hmda

	install.packages("MonetDBLite")
	library(DBI)

	dbdir <- "/tmp/hmda"
	con <- dbConnect(MonetDBLite::MonetDBLite(), dbdir)

	# download at http://homepages.cwi.nl/~hannes/hmda.rds
	dd <- readRDS("/tmp/hmda.rds")

	http://www.joeconway.com/presentations/plr-PGConfNYC2014.pdf

	sudo apt-get install postgresql-9.4-plr

	---------------------------------------------------
	CREATE EXTENSION plr;

	CREATE OR REPLACE FUNCTION r_lib_paths ()
	RETURNS text AS '
	.libPaths()