Skip to content

Instantly share code, notes, and snippets.

@bbock
bbock / README.md
Last active March 19, 2024 21:14
A PostgresSQL function to merge TeslaMate drives in the database

A PostgresSQL function to merge TeslaMate drives and charges in the database

Please note that the functions are only capable to merge a continuous range of drives/charges.

Make sure that all drives that shall be merged are terminated (how to terminate drives manually is described in the documentation.

Create the function by executing the file with e.g.

docker-compose exec database psql teslamate teslamate < teslamate_merge_drives.sql
@bbock
bbock / find_auto_updates.sh
Created September 23, 2019 07:46
find all homebrew casks that to application-side auto updates
for cask in $(brew cask list); do brew cask cat $cask | grep -q 'auto_updates true' && echo $cask ; done
@bbock
bbock / keybase.md
Created November 18, 2016 12:18
Keybase proof

Keybase proof

I hereby claim:

  • I am bbock on github.
  • I am bernhardbock (https://keybase.io/bernhardbock) on keybase.
  • I have a public key whose fingerprint is 05E8 7C6E 93C8 9830 2EA2 9E2F FB22 D6D4 3C0C A24F

To claim this, I am signing this object: