Pinned

1. Using JSON in Postgres by example Using JSON in Postgres by example

   1

   # PostgreSQL JSON Cheatsheet

   2

   3

   Using JSON in Postgres by example.

   4

   5

   ## Quick setup via Docker

2. Using cec-client on a Raspberry Pi t... Using cec-client on a Raspberry Pi to control TV power and inputs via HDMI

   1

   # Using cec-client on a Raspberry Pi

   2

   3

   Most modern HDMI connected devices support [Consumer Electronics Control](https://en.wikipedia.org/wiki/Consumer_Electronics_Control) (CEC). It allows devices to send commands to each other, typically to get the TV to switch input and control volume. If you have ever turned on a Game Console and had your TV automatically change input to that device you have seen CEC in action. It is very convenient and useful, sort of a universal remote that works.

   4

   5

   Every manufacturer seems to have it’s own branding of CEC (e.g. Samsung Anynet+, LG SimpLink, Sharp Aquos Link) but it may need to be enabled. Check your manual for details.