Skip to content

Instantly share code, notes, and snippets.

@TheColdPrince
TheColdPrince / WikiFeed - Wikipedia Blogger Template
Last active April 23, 2024 17:39
Wikipedia Blogger Template - Blogger theme with a strong Wiki-style. WikiFeed is suitable for encyclopedic websites. The theme helps you to create an encyclopedia out of your blog! With the help of Blogger, we can now create our own Wikipedia. Code that is easy to use and alter, as well as clean and understandable. WikiFeed is a content-focused …
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE html>
<html b:responsive='true' b:version='2' class='v2' expr:dir='data:blog.languageDirection' xmlns='http://www.w3.org/1999/xhtml' xmlns:b='http://www.google.com/2005/gml/b' xmlns:data='http://www.google.com/2005/gml/data' xmlns:expr='http://www.google.com/2005/gml/expr'>
<head>
<meta content='width=device-width, initial-scale=1.0' name='viewport'/>
<!-- Meta Title -->
<meta content='WikiFeed-Blogger' property='og:title'/>
<meta content='WikiFeed-Blogger' property='og:image:alt'/>
<meta content='WikiFeed-Blogger' name='twitter:title'/>
<meta content='WikiFeed-Blogger' name='twitter:image:alt'/>
@arikfr
arikfr / saas_metrics.sql
Last active February 20, 2022 14:57
SaaS Metrics Query
/*
Explanation of what's going on in this query can be found in this blog post: https://blog.redash.io/sql-query-to-calculate-saas-metrics-dd25d72a0521.
*/
WITH v_charges AS (
SELECT org_id,
date_trunc('month', start_date) AS month,
coalesce((extra::json->>'amount')::float, (extra::json->>'charged_amount')::integer/100) as total
FROM charges
WHERE extra::json->>'months' = '1'
@colmcoughlan
colmcoughlan / extract_encrypted_zip_file.md
Last active May 2, 2022 10:58
Extract an encrypted zip file with a password using Python 3

Extract files from an encrpyted zip file with python3

Take care, python3's zipfile only supports encrypted zip files that use CRC-32 based encryption This seems to be the default for the "zip" program on linux, but this doesn't work for AES encryption, or for many Windows based zip solutions See https://github.com/python/cpython/blob/3.6/Lib/zipfile.py for more details

from zipfile import ZipFile
@koorukuroo
koorukuroo / news_rss.py
Last active May 16, 2024 14:01
Korean News RSS URLs
### 출처
# http://blog.opid.kr/427
# 400, 403, 404 에러가 없는 url만 간추림
### 언론사 리스트
# 중앙일보 | 구글뉴스 | 에이빙뉴스 | 중부매일 | 에버뉴스 |
# 경향닷컴 | 데이터넷 | 세계일보 | 뉴스위드 | 뉴스포스트 |
# 르몽드 디플로마티크 | 컨슈머타임스 | MBC | 한국아이닷컴 | 노컷뉴스 |
# K모바일 | 탑라이더 | 한국경제 | 동아닷컴 | 엑스포저널 |
@kwmiebach
kwmiebach / pytest.md
Last active June 4, 2024 06:29 — forked from amatellanes/pytest.sh
pytest cheat sheet

Usage

(Create a symlink pytest for py.test)

pytest [options] [file_or_dir] [file_or_dir] ...

Help: