gvenzl

LOCATION=$(curl -s https://api.github.com/repos/<YOUR ORGANIZTION>/<YOUR REPO>/releases/latest \
| grep "zipball_url" \
| awk '{ print $2 }' \
| sed 's/,$//'       \
| sed 's/"//g' )     \
; curl -L -o <OUTPUT FILE NAME> $LOCATION

for example:

gvenzl

Latency Comparison Numbers (~2012)
----------------------------------
L1 cache reference                           0.5 ns
Branch mispredict                            5   ns
L2 cache reference                           7   ns                      14x L1 cache
Mutex lock/unlock                           25   ns
Main memory reference                      100   ns                      20x L2 cache, 200x L1 cache
Compress 1K bytes with Zippy             3,000   ns        3 us
Send 1K bytes over 1 Gbps network       10,000   ns       10 us
Read 4K randomly from SSD*             150,000   ns      150 us          ~1GB/sec SSD

gvenzl

#!/usr/bin/python3
# Press [Ctrl]+[C] to terminate the program
import seeed_dht
sensor = seeed_dht.DHT(seeed_dht.DHT.DHT_TYPE["DHT22"], 12) # DHT type 22, pin 12
try:
    while True:
        humi, temp = sensor.read()
        print('DHT{0}, humidity {1:.1f}%, temperature {2:.1f}C'.format(sensor.dht_type, humi, temp))
except KeyboardInterrupt:
    print("Exiting program.")

gvenzl

#!/usr/bin/python3
# Press [Ctrl]+[C] to terminate the program
from grove.grove_air_quality_sensor_v1_3 import GroveAirQualitySensor
air_quality_sensor = GroveAirQualitySensor(0) # Pin 0 for A0
try:
    while True:
        # pollution ratio: 0(0.0% and best air quality) - 1000(100.0% worst air quality)
        value = air_quality_sensor.value
        pollution_percent = value / 10
        print("Air pollution at {0:.1f}%".format(pollution_percent))

gvenzl

Test Database Setup

Container creation

Podman run

Test database and user creation

• MySQL
• Postgres
• Oracle
• SQL Server

gvenzl

List of all open source databases on GitHub in alphabetical order

Database	Database Type	GitHub repository
4store	RDF	https://github.com/4store/4store
abhot	Time Series	https://github.com/quqiangsheng/abhot
Accumulo	Key/Value	https://github.com/apache/accumulo
AceDB	Genome	https://github.com/richarddurbin/acedb
ActorDB	Distributed Relational	https://github.com/biokoda/actordb
Aerospike	Key/Value	https://github.com/aerospike/aerospike-server

gvenzl

Current date
Describe
Explain plans
Get type of expression
Run scripts
Show all tables
Show parameters
Truncate table
Run AWRs for Oracle

gvenzl

Print a nice little Christmas tree with recursive SQL and some UNION ALL:

set heading off;
set feedback off;

WITH tree(lev, xmas) AS (
  SELECT 1 lev, RPAD(' ', 10, ' ')
   || '*' xmas
    FROM   dual

gvenzl

sql() {
  # REMOTE source this script
  #
  # . <(curl -s https://gist.githubusercontent.com/krisrice/fec43fd9f53e4286e5cc360b554e3c0f/raw/62ec382d7511c7cc44703a9a2f75a4a7f233efe2/sqlcl.sh)

  # Set the stage directory
  STAGE_DIR=/var/tmp

  # Check whether internet connection exists
  if ping -c 1 -W 3 download.oracle.com > /dev/null; then

gvenzl

git rev-list --objects --all |
  git cat-file --batch-check='%(objecttype) %(objectname) %(objectsize) %(rest)' |
  sed -n 's/^blob //p' |
  sort --numeric-sort --key=2 |
  cut -c 1-12,41- |
  $(command -v gnumfmt || echo numfmt) --field=2 --to=iec-i --suffix=B --padding=7 --round=nearest