Bart de Water bdewater

In my application every time I send a newsletter to a User, I create a NewsletterDelivery record. I frequently want to be able to query, for each user, what is the most recent newsletter delivery record. This is called a "last n per group" query and a LATERAL JOIN is the best way to do it imo. But the query I've been using (and I've told people to use, and seen blogged about) is not very good, because the conditions don't get pushed down into the subselect which means that the query ends-up lateral-joining all the records before it applies the conditions for the association.

Instead of doing subselect_table.* the better query does association.id AS assocation_id, subselect_table.id, subselect_table.title, .... and enumerates over all of the columns. This allows the association query, which Active Record tacks on at the end as WHERE association_id = $1 or WHERE association_id IN ($1, $2, $3, ...) to be pushed down c

Brew Bundle Brewfile Tips

Copyright & License

Unless otherwise noted (either in this file or in a file's copyright section) the contents of this gist are Copyright ©️2020 by Christopher Allen, and are shared under spdx:Creative Commons Attribution Share Alike 4.0 International (CC-BY-SA-4.) open-source license.

Sponsor

If you more tips and advice like these, you can become a monthly patron on my GitHub Sponsor Page for as little as $5 a month; and your contributions will be multipled, as GitHub is matching the first $5,000! This gist is all about Homebrew, so if you like it you can support it by donating to them or becoming one of their Github Sponsors.

Unofficial Bash Strict Mode

Sometimes a programming language has a "strict mode" to restrict unsafe constructs. E.g., Perl has use strict, Javascript has "use strict", and Visual Basic has Option Strict. But what about bash? Well, bash doesn't have a strict mode as such, but it does have an unofficial strict mode:

set -euo pipefail

set -e

Presto Specific

Don’t SELECT *, Specify explicit column names (columnar store)
Avoid large JOINs (filter each table first)
- In PRESTO tables are joined in the order they are listed!!
- Join small tables earlier in the plan and leave larger fact tables to the end
- Avoid cross joins or 1 to many joins as these can degrade performance
Order by and group by take time
- only use order by in subqueries if it is really necessary
When using GROUP BY, order the columns by the highest cardinality (that is, most number of unique values) to the lowest.

This script uses openssl to mock a TPM 2.0 manufacturer's [Endorsement Key credentials][r4] enough to use in acceptance tests starting with fresh EKs from a newly-instantiated [TPM 2.0 simulator][tpm2sim].

Usage

bash -e  tpm2_ekcert_sign.sh  [public.ek.portion.cer]

Input

Deconstruct 2017 Bibliography

Here are all of the resources mentioned by Deconstruct 2017 speakers, along with who recommended what. Please post a comment if I missed something or have an error!

DC 2017 Speakers' Choice Gold Medalist

Seeing Like a State by James Scott

Books

Public Opinion by Walter Lippmann (Evan Czaplicki)
A Pattern Language by Christopher Alexander (Brian Marick)
Domain Driven Design by Eric Evans (Brian Marick)

NOTE: This is outdated. Check the comments below for more up-to-date forks of this gist.

Improved YARD CHEATSHEET http://yardoc.org

forked from https://gist.github.com/chetan/1827484 which is from early 2012 and contains outdated information.

	#!/usr/bin/env ruby

	# Place in your project (don't forget to chmod +x):
	# bin/autoload-check

	# Allow these files to be fixed later
	allowlist = [
	"ExampleClass" # why?
	]

	// Remove all drafts from your drafts view
	// Navigate to drafts
	// F12 to raise dev console
	// Paste the below
	(async function(x) {
	for (let e = document.querySelector('[type="trash"]'); e != null; e = document.querySelector('[type="trash"]')) {
	e.click();
	await new Promise(resolve => setTimeout(resolve, 500))
	document.querySelector('[data-qa="drafts_page_draft_delete_confirm"]').click();
	await new Promise(resolve => setTimeout(resolve, 1500))

	# Compresses all .js and .css files under the assets path.
	namespace :deploy do
	# It is important that we execute this after :normalize_assets because
	# ngx_http_gzip_static_module recommends that compressed and uncompressed
	# variants have the same mtime. Note that gzip(1) sets the mtime of the
	# compressed file after the original one automatically.
	after :normalize_assets, :gzip_assets do
	on release_roles(fetch(:assets_roles)) do
	assets_path = release_path.join('public', fetch(:assets_prefix))
	within assets_path do