151 karma · joined March 9, 2010
Emby. Network media streaming.
qBittorrent with the web server enabled. Downloading Linux ISOs.
Airsonic. Music library streaming, though I find myself using Emby for this more often.
All running on Ubuntu 20.04 on an Intel NUC with 16GB RAM.
One thing I've found to help is growing some plants indoors. I have a few grow lights on 12h timers that keep me a little grounded to the rhythm of the Earth. However nothing beats the energy you get from a natural view.
[1] https://github.com/bslassey/ip-blindness/blob/master/near_pa...
e.g. https://www.nrel.gov/gis/images/solar/solar_ghi_2018_usa_sca... but on the daily.
Only adding indexes with good use of EXPLAIN/EXPLAIN ANALYZE on expected usage patterns yielded good results. Often we'd just blow the indexes away and fiddle until we added the correct one to enable an index scan / index only scan.
Other big boons for us have been using ENUM types where necessary (small known dataset for a column) -- now your column takes 4 bytes instead of N bytes for a string. I find them a bit easier to work in than foreign keys for this optimization because of their direct string mapping.
We've had really good mileage with Datadog's APM tools, RDS performance insights and pghero as you mentioned.
As I own no other Apple products, it helps having an Mac in house to run the occasional Mac only software.
Here's a guide [1] with a matrix on how to install it on other NUC models.
[1] http://www.tonymacx86.com/threads/guide-el-capitan-on-the-in...
So should Outlook.com be considered insecure if the US government can access it at any time without you knowing? Microsoft should be able to inform you whether or not your information has been leaked. I hope Microsoft wins.
That and the tooling is almost here with MIDI.js[1], Web Audio[2] and Web MIDI[3] as a working draft.
[1] https://github.com/mudcube/MIDI.js/
[2] https://developer.mozilla.org/en-US/docs/Web/API/Web_Audio_A...