Skip to content

Instantly share code, notes, and snippets.

View nandilugio's full-sized avatar
🤖
Having state

Fernando Stecconi nandilugio

🤖
Having state
View GitHub Profile

Don Ramon Songs

1ra

cuándo cambia a reaguee?

--         x2
B F# G E   canto, solo, canto (acaba en G)
@nandilugio
nandilugio / random_bu.md
Created January 6, 2023 09:45
Random notes from BU

SQL

Histogram queries

select
  (age/10)*10 as from_age, -- Bucket unique
 ((age/10)*10)+10 as to_age,
---------------------------------------
-- SQL Training 2/4 hands-on session --
---------------------------------------
-- Customers
drop table if exists customers cascade;
create table customers (
id serial primary key,
name text not null
);
create or replace function value_or_raise(
anyelement,
if boolean,
else_raise text
)
returns anyelement
language plpgsql
immutable
as $function$
Recruitment interview ideas
===========================
You
---
One interesting challenge
difficult feature?
difficult bug?
Any personal projects?
# This is a debugging tool for flaky ruby/rack (rails) browser tests not properly
# waiting for potentially slow server responses (eg. with Capybara). Its a Rack
# middleware that adds a delay to every response, thus making the problem
# evident.
#
# In Rails, add the following to the end of your Application class definition in
# `config/application.rb`, AND REMOVE AFTER DEBUGGING!!!
#
# # TODO: REMOVE!!
# require("slow_requests_for_debugging")
# Dependencies =================================================================
err_unless_executable () {
if ! [ -x "$(command -v $1)" ]; then
echo "Program '$1' is required. Please install it and make it available in your \$PATH. Aborting." >&2
exit 1
fi
}
# TODO: can we expect curl these deps to be installed in all target machines?
Life of your developers
Dev receives a feature request
Add calculator to app
Dev designs the solution
Your average dev
- Calculator.Form
- Calculator.FormController
- calculate
- add
- subtract
positional_args=()
while [ $# -gt 0 ]; do  # While there are still arguments
  if getopts "nh" option; then
    case $option in
    n)
      something_with_an_n=yes
      ;;
    h)
 show_usage && exit 0