damon140

Windows Functions

Get the difference from the previews row, using the LAG an OVER keywords which are part of window functions. This is the first time I've seen this but I'm sure I'm going to need it sometime. From Julia Evans on twitter

sql tips: get the difference from the previous row

damon140

Windows Functions

Get the difference from the previews row, using the LAG an OVER keywords which are part of window functions. This is the first time I've seen this but I'm sure I'm going to need it sometime. From Julia Evans on twitter

sql tips: get the difference from the previous row

damon140

CSS

Web Design in 4 minutes minimal CSS to create a simple modern web page, with design explanations.

HTML

Guide to HTML 5 Head Elements provides good rules and explanations especially about the order of elements to be effective.

damon140

-- show running queries, oldest first (postgres 10.5)
SELECT pid, age(clock_timestamp(), query_start), usename, state, query
FROM pg_stat_activity 
WHERE state != 'idle' AND query NOT ILIKE '%pg_stat_activity%' 
ORDER BY age desc;