Ziggy Jonsson ZJONSSON

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.

Hey everyone - this is not just a one off thing, there are likely to be many other modules in your dependency trees that are now a burden to their authors. I didn't create this code for altruistic motivations, I created it for fun. I was learning, and learning is fun. I gave it away because it was easy to do so, and because sharing helps learning too. I think most of the small modules on npm were created for reasons like this. However, that was a long time ago. I've since moved on from this module and moved on from that thing too and in the process of moving on from that as well. I've written way better modules than this, the internet just hasn't fully caught up.

@broros

otherwise why would he hand over a popular package to a stranger?

If it's not fun anymore, you get literally nothing from maintaining a popular package.

One time, I was working as a dishwasher in a restu

Keys for obtaining US Driver's license data

Standard for US Driver's Licenses defines 9 different barcode standards (AAMVA versions) with over 80 different fields encoded inside a barcode. Some fields exist on all barcode standards, other exist only on some. To standardize the API, we have structured the fields in the following sections:

Determining AAMVA version
Keys existing on all barcode versions
- Mandatory values
  - Personal data
  - License data
- Optional values

It seems that Chrome finally found a way to let us convert from svg to canvas to png without the tainted canvas security feature/bug.

Fun with vector maps

A goofy slippy map of various vector tile data sources. With some fun colours, greetz to Aaron and Mike and Mike and the whole Prettymaps crew.

Sacramento, CA • SF bay area, CA • New Orleans, LA • Boulder, CO •

Collections

each(array)

Underscore example:

_.each([1, 2, 3], function(num) { alert(num); });

	/* requires AWS creds to be updated.
	* if they aren't, update using AWS.config.update() method before instatiing the client.
	*
	* import this module where you instantiate the client, and simply pass this module as the connection class.
	*
	* eg:
	* const client = new Client({
	* node,
	* Connection: AwsConnector
	* });

	Author,HyperlinksChanged,LinksUpToDate,AllowPNG,Version,Template,Revision,Company,LastSaved,Characters,Pages,Words,Created,Bytes,LastAuthor,Lines,AppVersion,CharactersWithSpaces,OfficeDocumentSettings,DocSecurity,ShareDoc,TotalTime,url,RelyOnVML,ScaleCrop,PixelsPerInch,Paragraphs,Keywords,LastPrinted
	Jakobína Sveinsdóttir,,,,10.2625,,2,Hæstiréttur Íslands,2003-03-29T12:44:00Z,4138,3,725,2003-03-29T12:44:00Z,16384,Gummi,34,,4854,,,,4,http://www.haestirettur.is/domar?nr=4,,,,9,,1999-01-12T10:23:00Z
	Jakobína Sveinsdóttir,,,,10.2625,,2,Hæstiréttur Íslands,2003-03-29T12:43:00Z,6308,3,1106,2003-03-29T12:43:00Z,19456,Gummi,52,,7400,,,,70,http://www.haestirettur.is/domar?nr=6,,,,14,,1999-01-11T13:36:00Z
	Ritari 2,,,,10.2625,,2,Hæstiréttur Íslands,2003-03-29T12:42:00Z,46891,19,8226,2003-03-29T12:42:00Z,69632,Gummi,390,,55007,,,,176,http://www.haestirettur.is/domar?nr=7,,,,110,,1999-01-14T08:38:00Z
	Skúli Magnússon,,,,10.2625,,2,Hæstiréttur,2003-03-29T12:40:00Z,5058,3,887,2003-03-29T12:40:00Z,25600,Gummi,42,,5934,,,,34,h

	<script src="https://cdnjs.cloudflare.com/ajax/libs/crossfilter/1.3.12/crossfilter.js"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/d3/3.5.6/d3.js"></script>
	<script src="https://cdnjs.cloudflare.com/ajax/libs/dc/2.0.0-beta.20/dc.js"></script>
	<script src="updatingCrossfilter.js"></script>
	<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/dc/2.0.0-beta.20/dc.css" />
	<div> DC Version: <span id="version"></span></div>
	<div id="timechart"></div>
	<div id="histogram"></div>
	<script>
	var getData = function (d) { return {ts: d, y: Math.random()* 2 -1 }; }, //get a data point

	<!-- ALL CREDIT FOR THE SCROLLING TEXT GOES TO
	Craig Buckler
	http://www.sitepoint.com/css3-starwars-scrolling-text/

	Blame me for the music via embedded video bit
	-->

	<div style="border:1px solid darkred;overflow:hidden; position:absolute; left:0; top:0; width:50px; height:25px;">
	<div style="margin-top:-290px;">
	<object width="420" height="315">