mathisve

{
  "annotations": {
    "list": [
      {
        "builtIn": 1,
        "datasource": {
          "type": "grafana",
          "uid": "-- Grafana --"
        },
        "enable": true,

mathisve

--DROP MATERIALIZED VIEW tick1mcagg, tick10mcagg, tick30mcagg, tick1hcagg, tick6hcagg, tick12hcagg, tick1dcagg, tick7dcagg, tick14dcagg, tick30dcagg;
--DROP MATERIALIZED VIEW fl1mcagg, fl10mcagg, fl30mcagg, fl1hcagg, fl6hcagg, fl12hcagg, fl1dcagg, fl7dcagg, fl14dcagg, fl30dcagg;

--tickcaggs
CREATE MATERIALIZED VIEW tick1mcagg WITH (timescaledb.continuous) AS                                                                                                           
SELECT time_bucket('1m', time) as time, avg(price) as price, symbol
FROM crypto_ticks                                                                                                                          
GROUP BY time_bucket('1m', time), symbol WITH NO DATA;

CREATE MATERIALIZED VIEW tick10mcagg WITH (timescaledb.continuous) AS

mathisve

## works for ubuntu
## source: https://www.linuxtechi.com/install-kubernetes-on-ubuntu-22-04/

sudo swapoff -a
sudo sed -i '/ swap / s/^\(.*\)$/#\1/g' /etc/fstab

sudo tee /etc/modules-load.d/containerd.conf <<EOF
overlay
br_netfilter
EOF

mathisve

Keybase proof

I hereby claim:

• I am mathisve on github.
• I am mathisve (https://keybase.io/mathisve) on keybase.
• I have a public key whose fingerprint is BBBB E77F DD61 2E0E F4F5 2FE4 8DAF 8B0A FA8E CCAB

To claim this, I am signing this object:

mathisve

#!/bin/bash

aws ec2 describe-addresses \
    --filters "Name=tag-key,Values=Static" | jq -r '.Addresses[] | .PublicIp'

mathisve

name: React publish

on:
  push:
    branches: [ master ]

jobs:
  build:
    runs-on: ubuntu-20.04

mathisve

#!/usr/bin/env bash

# https://elinux.org/Bringing_CAN_interface_up

# Installing can-utils
sudo sudo apt-get install can-utils

# Creating vcan0 interface
sudo ip link add dev vcan0 type vcan
sudo ip link set up vcan0

mathisve

package main

import (
  "fmt"
  "math"
)

func main() {
  var acceleration, velocity, displacement, time float64

mathisve

package main

import (
  "fmt"
  "math"
)

type rectangle struct {
  width float64
  height float64

mathisve

#!/usr/bin/env bash

# pip3 install --target ./package Pillow

cd package
zip -r9 ${OLDPWD}/archive.zip .
cd $OLDPWD
zip -g archive.zip main.py chromedriver
echo "UPLOADING archive.zip to AWS"
aws lambda update-function-code --function-name pythontest --zip-file fileb://archive.zip