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

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

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

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

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

Test Database Setup

Container creation

Podman run

Test database and user creation

• MySQL
• Postgres
• Oracle
• SQL Server

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

#!/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

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

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: