Postgresql: style guide for DataGrip
Place it into xml file and import into DataGrip or another jetbrains’ product
PostgreSQL: using indices on json fields
It’s obviously a really bad idea. But if you really need it, that’s what you can do.
Postgresql: show all locked queries
WITH RECURSIVE l AS ( SELECT pid, locktype, mode, granted, ROW(locktype,database,relation,page,tuple,virtualxid,transactionid,classid,objid,objsubid) obj FROM pg_locks ), pairs AS ( SELECT w.pid waiter, l.pid locker, l.obj, l.mode FROM l w JOIN l ON l.obj IS NOT DISTINCT FROM w.obj AND l.locktype=w.locktype AND NOT l.pid=w.pid AND l.granted WHERE NOT w.granted ), tree AS ( SELECT l.locker pid, l.locker …
Smart Home systems
There are quite a lot of that systems: MajorDoMo OpenHab Iobroker Domoticz HomeAssistant The most interesting ones are: Iobroker (Node.js-based) HomeAssistant (based on Python 3)
Install exact version via brew
For instance, we’re looking for kubernetes-helm@2.9 helm 2.9 git -C «$(brew —repo homebrew/core)» fetch —unshallow cd «$(brew —repo homebrew/core)» git log Formula/kubernetes-helm.rb # searching for 2.9.0 with a command /2\.9\.0 and copying hash like «7ade79f13b4bbcc6126803245594d97b2abbe2fa» git checkout -b kubernetes-helm@2.9.0 7ade79f13b4bbcc6126803245594d97b2abbe2fa HOMEBREW_NO_AUTO_UPDATE=1 brew install kubernetes-helm Now we have needed version of helm. If you see an …
docker-compose example for ceph, kafka, postgres cluster
That is how it can be done:
Setting zsh on you mac
This gist is great: https://gist.github.com/kevin-smets/8568070 I just added these line at the bottom: plugins=(zsh-autosuggestions git) DEFAULT_USER=… POWERLEVEL9K_SHORTEN_DIR_LENGTH=2 source /usr/local/share/zsh-syntax-highlighting/zsh-syntax-highlighting.zsh List of embedded plugins: https://github.com/robbyrussell/oh-my-zsh/tree/master/plugins Custom plugins are installed here — ~/.oh-my-zsh/custom/plugins (actually, $ZSH_CUSTOM/plugins). Like this: git clone https://github.com/zsh-users/zsh-autosuggestions ${ZSH_CUSTOM:-~/.oh-my-zsh/custom}/plugins/zsh-autosuggestions
CO2 sensor DIY
Article says how to make your own CO2 sensor with Arduino and visualize data with Grafana. It’s in Russian. https://ovcharov.me/2018/10/21/co2-sensor-mh-z19b/
Spectacle for fullscreen apps on mac
It can make your app fullscreen and also manage your apps positioning. http://www.spectacleapp.com/ You could also try http://magnet.crowdcafe.com/ Now they suggest to use https://rectangleapp.com/ instead of spectacular.
Free video editor — Davinci Resolve
https://www.blackmagicdesign.com/ru/products/davinciresolve/