Skip to content

Instantly share code, notes, and snippets.

View calumhalcrow's full-sized avatar

Calum Halcrow calumhalcrow

View GitHub Profile
class WarBastard < RTanque::Bot::Brain
NAME = 'WAR BASTARD'
include RTanque::Bot::BrainHelper
@direction = true
def tick!
command.speed = 8
@direction = !@direction if rand(200) < 2
class WarBastard < RTanque::Bot::Brain
NAME = 'WAR BASTARD'
include RTanque::Bot::BrainHelper
@direction = true
def tick!
command.speed = 8
@direction = !@direction if rand(200) < 2

Installs ruby-2.0.0-p247 on ubuntu via checkinstall so it's in your package manager and you can remove it.

Quick install:

curl -Lo- https://gist.github.com/parasquid/5624732/raw/install-ruby-2-ubuntu.sh | bash
@calumhalcrow
calumhalcrow / hivekind_engineer_skills_test.md
Last active March 10, 2022 22:49 — forked from nickmarden/senior_eng_skills_test.md
Hivekind Engineer skills test

NOTE: Please send your answers to [email protected] rather than post them publicly in another Gist or in comments on this Gist.

1. Voting

Each voter can vote in zero or more referenda. Each referendum has one or more questions, and each question is a yes/no vote. Write the simplest normalized schema to describe this in generic SQL statements or as an entity-relationship diagram. Point out where the indexes would be if you want to quickly know the results of a given referendum question, but you never expect to query a single voter's voting record.

2. Availability on AWS

Your client plans to host their web application on AWS. When would you advise (a) deployment in a single availability zone, (b) deployment in multiple availability zones in a single region (c) deployment in multiple regions? What operational difficulty or complexity, if any, is added as you go from (a) to (b) to (c)?

@calumhalcrow
calumhalcrow / rapid_river_frontend_engineer_skills_test.md
Last active November 26, 2018 05:30
Rapid River Front-end Engineer skills test

PLEASE NOTE: We'd prefer you send your answers to [email protected] rather than post them publicly in another Gist, or in comments on this Gist ;-)

1. JavaScript

What is the JavaScript build tool of your choice? Explain why.

Take a look at the following:

function *foo(x) {
@calumhalcrow
calumhalcrow / data_warehouse_engineer_skills_test.md
Last active November 26, 2018 05:30 — forked from nickmarden/database_engineer_skills_test.md
Rapid River Data Warehouse Engineer skills test

PLEASE NOTE: We'd prefer you send your answers to [email protected] rather than post them publicly in another Gist, or in comments on this Gist ;-)

1. Voting

Each voter can vote in zero or more referenda. Each referendum has one or more questions, and each question is a yes/no vote. Write the simplest normalized schema to describe this in generic SQL statements or as an entity-relationship diagram. Point out where the indexes would be if you want to quickly know the results of a given referendum question, but you never expect to query a single voter's voting record.

2. Cursors

Explain the difference between explicit and implicit cursors in PL/SQL. Give an example in which an explicit cursor can be used to solve a problem that cannot be solved (or cannot be solved easily) using implicit cursors.

PLEASE NOTE: We'd prefer you send your answers to [email protected] rather than post them publicly in another Gist, or in comments on this Gist ;-)

Enterprise Data Warehouse Engineer Skills Test

The following is a series of questions related to skills that we commonly use in our enterprise data warehouse (EDW).

This is not a timed or monitored test, and you may use any print or online resources you would like to assist you in your work.

Please submit your answers in the form of text, markdown, or other lightweight data formats. Please indicate clearly which parts of your response correspond to which question. If your answers span multiple files, please attach them as a zip file.

@calumhalcrow
calumhalcrow / rapid_river_data_engineer_skills_test.md
Last active November 26, 2018 05:30
Rapid River Data Engineer skills test

PLEASE NOTE: We'd prefer you send your answers to [email protected] rather than post them publicly in another Gist, or in comments on this Gist ;-)

1. Voting

Each voter can vote in zero or more referenda. Each referendum has one or more questions, and each question is a yes/no vote. Write the simplest normalized schema to describe this in generic SQL statements or as an entity-relationship diagram. Point out where the indexes would be if you want to quickly know the results of a given referendum question, but you never expect to query a single voter's voting record.

2. Cursors

Explain the difference between explicit and implicit cursors in PL/SQL. Give an example in which an explicit cursor can be used to solve a problem that cannot be solved (or cannot be solved easily) using implicit cursors.

@calumhalcrow
calumhalcrow / rapid_river_tpm_skills_test.md
Last active February 12, 2019 07:46
Rapid River's talent test for Technical Project Manager applicants.

PLEASE NOTE: We'd prefer you send your answers to [email protected] rather than post them publicly in another Gist, or in comments on this Gist ;-)

Part 1: Project Management

The following questions all describe specific problematic project management situations, and ask you how you'd deal with them.

1. Estimations and Timelines

You have recently joined a software team and have been asked to provide project management guidance. The team consists of four developers, and is quite well "gelled". To date, the team has been following a Kanban & Release Train style approach to completing tasks. They are reasonably productive, and project stakeholders are generally happy with the team's output.

@calumhalcrow
calumhalcrow / engineer_skills_test.md
Created May 8, 2019 08:54 — forked from denied404/engineer_skills_test.md
An engineer skills test for RRSoft

PLEASE NOTE: We'd prefer you send your answers to [email protected] rather than post them publicly in another Gist, or in comments on this Gist ;-)

Engineer Skills Test

The following is a series of questions related to skills that we commonly use in our projects.

This is not a timed or monitored test, and you may use any print or online resources you would like to assist you in your work.

Please submit your answers in the form of text, markdown, or other lightweight data formats. Please indicate clearly which parts of your response correspond to which question. If your answers span multiple files, please attach them as a zip file.