yvoderatskyi

skip 1

fields date, counterparty, description, category, iban_acc, bank, product, amount, _, card_number

date-format %Y-%-m-%-d

currency €

description %counterparty | %description

yvoderatskyi

# Requires https://csvkit.readthedocs.io/en/latest/ and https://hledger.org/

.PRECIOUS : csv/Transactions_%.csv
csv/Transactions_%.csv : raw/Transactions_%.csv
	@echo "Converting encoding from cp1251 to utf-8"
	in2csv $< -e cp1251 > $@

journal/%.journal : csv/Transactions_%.csv deutschebank.rules
	@echo "Converting to journal"
	hledger print --rules-file $(word 2,$^) --file $< > $@

yvoderatskyi

@startuml
' uncomment the line below if you're using computer with a retina display
' skinparam dpi 300
!define Table(name,desc) class name as "desc" << (T,#FFAAAA) >>
' we use bold for primary key
' green color for unique
' and underscore for not_null
!define primary_key(x) <b>x</b>
!define unique(x) <color:green>x</color>
!define not_null(x) <u>x</u>

yvoderatskyi

{"title": "Multimedia Big Data Computing for IoT Applications", "book_page": "https://link.springer.com/book/10.1007/978-981-13-8759-3", "download_pdf": "https://link.springer.com/content/pdf/10.1007/978-981-13-8759-3.pdf", "download_epub": "https://link.springer.com/download/epub/10.1007/978-981-13-8759-3.epub", "page": "page-1.html"}
{"title": "Foundations of Behavioral Health", "book_page": "https://link.springer.com/book/10.1007/978-3-030-18435-3", "download_pdf": "https://link.springer.com/content/pdf/10.1007/978-3-030-18435-3.pdf", "download_epub": "https://link.springer.com/download/epub/10.1007/978-3-030-18435-3.epub", "page": "page-1.html"}
{"title": "Quick Start Guide to Verilog", "book_page": "https://link.springer.com/book/10.1007/978-3-030-10552-5", "download_pdf": "https://link.springer.com/content/pdf/10.1007/978-3-030-10552-5.pdf", "download_epub": "https://link.springer.com/download/epub/10.1007/978-3-030-10552-5.epub", "page": "page-1.html"}
{"title": "Perceptual Organization", "book_page": 

yvoderatskyi

Keybase proof

I hereby claim:

• I am yvoderatskyi on github.
• I am yvoderatskyi (https://keybase.io/yvoderatskyi) on keybase.
• I have a public key ASCBABo4j8L_kZNiaTHv7n-cQvVpfY4-nOj1tYCfIIieBwo

To claim this, I am signing this object:

yvoderatskyi

-- show running queries (pre 9.2)
SELECT procpid, age(query_start, clock_timestamp()), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(query_start, clock_timestamp()), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'