mjhea0

Jitbit's SQL interview questions

http://www.jitbit.com/news/181-jitbits-sql-interview-questions/

Schema

employees

• employee_id
• department_id
• boss_id
• name

meiamsome

/* Hacker News Search Script
 *
 * Original Script by Kristopolous:
 * https://gist.github.com/kristopolous/19260ae54967c2219da8
 *
 * Usage:
 * First, copy the script into your browser's console whilst on the Hacker News
 * jobs page. Then, you can use the query function to filter the results.
 *
 * For example,

githoov

Redshift Tables Used

pg_table_def, stl_query, stl_querytext, stl_tr_conflict, stl_explain, stl_alert_event_log, stl_ddltext, stl_scan, stl_save, stl_hashjoin, stl_hash, stl_plan_info, stl_return, and information_schema.table_constraints.

Queries to Extract Features

• execution time

select (endtime - starttime) as execution_time_in_ms 
from stl_query 
where query = QUERY_ID;

hiddentao

pragma solidity ^0.4.10;

contract RoleBasedAcl {
  address creator;
  mapping(address => mapping(string => bool)) roles;

  function RoleBasedAcl () {
    creator = msg.sender;
  }
  

monkeym4ster

#for not running docker, use save:
docker save <dockernameortag> | gzip > mycontainer.tgz

#for running or paused docker, use export:
docker export <dockernameortag> | gzip > mycontainer.tgz

#load
gunzip -c mycontainer.tgz | docker load

kconner

macOS Internals

Understand your Mac and iPhone more deeply by tracing the evolution of Mac OS X from prelease to Swift. John Siracusa delivers the details.

Starting Points

How to use this gist

You've got two main options: