It’s finally here

My HexBright Flex arrived yesterday after waiting 1 year 7 months and 7 days from when the HexBright kickstarter project was funded. On the bright side (no pun intended), I only donated the $35 that qualified me for the low-end version of the HexBright, but since the vast majority of the supporters donated $60 for the Flex, they just upgraded all the the $35 donors for free. I can’t imagine how much longer it would have taken to develop and produce another version of the flashlight. The HexBright now retails for $99.

Here is a picture of it next to my mini Maglite.
HexBright Flex next to mini Maglite

Here is a picture of it unscrewed from the housing.
HexBright unscrewed

It has a rechargeable battery that you plug in with a micro-usb cord. The flashlight can be programmed with Arduino development tools. I didn’t order the Flex to begin with since I don’t expect to have ever time to reprogram a flashlight. The default behavior of the endcap button is click for low/medium/high/off or from the off hold down the button for three seconds to have the light start flashing.

The high mode is 500 lumens, and the battery is supposed to last for about an hour. For comparison, a 60 watt incandescent bulb is typically 850 lumens, but of course that light is focused at all. The HexBright gets noticeably warm when on the high setting, but the heat spreads out pretty evenly, so it is never painful to touch. According to the documentation, it has a heat sensor, so that it will shut off if it is left on inside a backpack. It is definitely is much brighter than my 69 lumen LED mini Maglite, but it doesn’t seem seven times as bright.

pg_reorg to the rescue

Let’s say you have a huge table in postgres and the table file on disk is bloated because it contains old versions of rows or deleted rows. You really want to run VACUUM FULL to reclaim that space. However, you can’t afford a maintenance window so that the exclusive lock from VACUUM FULL won’t block queries on that table. pg_reorg brilliantly creates a new table without the bloat, and it swaps into place without blocking a bunch of queries.