theothermattm

/* based on https://stackoverflow.com/a/17268740/288935 */
CREATE PROCEDURE insert_test_data()
BEGIN
  DECLARE i INT default 1;
  DECLARE mydate DATE DEFAULT NOW();
  
  SET mydate = DATE_ADD('2017-05-01 00:01:00', INTERVAL FLOOR(RAND() * 700) DAY);

  WHILE i < 1000000 DO
    INSERT INTO `telemetry_test` (`humidity`, `temperature`, `sql_insert`, `sql_update`)

theothermattm

Thanks to @kevlarr for this info... Saving it myself for reference.

The easiest way to get started is via pyenv and virtualenv.

• Install pyenv via brew install pyenv
• Add eval "$(pyenv init -)" to your bash, etc. profile if you want to enable autocomplete (hint: you do),
• Install project Python version via pyenv install 3.6.8¹

¹ If you are running Mojave and are having issues building (looking at you, zlib), you likely need to install C header files

theothermattm

# this chains them to make the regex easier to follow

sed -n -e 's/^${FIRSTPATTERN}//p' test.txt | sed -n -e 's/${SECONDPATTERN}//p'

theothermattm

Node debugging with chrome

See this article first.

Use node --inspect

Most of the time it should give you a chrome URL. If not, go to about:inspect in chrome and you should see a target to inspect

Using mocha

theothermattm

How to set CA certs in node

(I always forget this!)

https://stackoverflow.com/questions/29283040/how-to-add-custom-certificate-authority-ca-to-nodejs

export NODE_EXTRA_CA_CERTS=[your CA certificate file path]

theothermattm

Some of the greatest info I've seen on creating a healthy engineering courtesy of Spotify:

Spotify Engineering Culture Part 1

TODO make notes on this one

Spotify Engineering Culture Part 2

• 0:50 - "We aim to make mistakes faster than anyone else" - Fail Fast and Improve Fast.
• 1:30 - "Fail Friendly Environment" - Encourage sharing of failures so everyone can learn from them. Some teams have "Fail walls" showing off their failures.

theothermattm

# original source based on: https://github.com/fabiohbarbosa/docker-healthcheck-oracle/blob/master/assets/healthcheck.sh

CHECK=$(${ORACLE_HOME}/bin/sqlplus -s ${HEALTHCHECK_USER}/${HEALTHCHECK_PASSWORD}@localhost/${HEALTHCHECK_SERVICE_NAME} as sysdba <<END
  --set pagesize 0 feedback off verify off heading off echo off;
  -- the simplest type of health check
  --select count(*) from dual;
  -- this will check if a 
  SELECT count(*) FROM V\$INSTANCE where INSTANCE_NAME = 'xe' and DATABASE_STATUS = 'ACTIVE';
  exit;
END

theothermattm

-- https://stackoverflow.com/questions/1690404/how-to-drop-all-user-tables

BEGIN
   FOR cur_rec IN (SELECT object_name, object_type
                     FROM user_objects
                    WHERE object_type IN
                             ('TABLE',
                              'VIEW',
                              'PACKAGE',
                              'PROCEDURE',

theothermattm

Tom Chi - Learning Through Prototyping

()[https://www.youtube.com/watch?v=kuqgrvUPc5g]

• Better to reason with experience/data than guesses
  • Find the quickest path to experience
  • Doing is the best kind of thinking.
• Smart people will always have good defenses of their guesses
• "Am I hearing a guess, or am I hearing direct experience?"
  • We want experience

theothermattm

rsync -azP --delete --filter=":- .gitignore" . targethost:/targetdirectory