Skip to content

Instantly share code, notes, and snippets.

View alitrack's full-sized avatar
💭
job hunting

Steven Lee alitrack

💭
job hunting
View GitHub Profile
@mark05e
mark05e / apache-superset-on-windows10.md
Last active May 7, 2024 09:18
Installing Apache Superset on Windows 10

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.


@zhiyzuo
zhiyzuo / Install-Rattle-on-macOS.md
Last active May 17, 2020 12:17
A brief note on how to install rattle/RGtk2 on macOS
@youfou
youfou / ad_urls.json
Last active September 9, 2023 14:50
响应好友请求 / 自动聊天 / 限制频率 / 邀请入群 / 远程群管理 / 新人欢迎消息 / 关键词问答 / 发心跳 / 远程命令 / 远程执行代码
{
"xiaohongshu.com": "小红书",
"vip.com": "唯品会",
"douguo.com": "豆果美食",
"youshu.cc": "有书",
"missfresh.cn": "每日优鲜",
"qnr.io": "去哪儿",
"kaola.com": "网易考拉",
"waimai.meituan.com": "美团外卖",
"qcs.meituan.com": "美团打车",
@littlecodersh
littlecodersh / main.py
Last active April 14, 2024 08:22
Main script behind itchat robot
#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")
@ermolaev
ermolaev / PostgreSQL with R
Last active May 25, 2017 23:55
PostgreSQL with R
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()
@Kartones
Kartones / postgres-cheatsheet.md
Last active May 7, 2024 17:48
PostgreSQL command line cheatsheet

PSQL

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)