A Lovely 10Centuries Blog

@hazardwarning The duplicates are likely because you’re asking to see columns that have the same info for multiple rows. You might want to try SELECT DISTINCT.

Here’s an example of duplicate rows:

Table T has rows A and B where column C1 is A resp B and column C2 is 2 for both.

Select C2 from T will then show 2 and 2, since both rows are part of the result set, but the Select asked only to see column C2, which is identical for both of them.

To collapse duplicates, you can Select DISTINCT C2 from T. This will remove duplicates.

@hazardwarning I prefer a warmer light, so most of my house is lamped with 2700K LEDs.

The only full-spectrum bulb I have is a massive CFL that’s always at risk of tipping over any desk lamp I stick it in. ? Amazon were convinced I bought it as a grow light and started trying to sell me on baggies and lab scales.

/@c

@jussipekonen Most anything that involves a package manager as part of deployment seems prone to break. That apparently goes for distribution package managers and spinning up new hosts, from sysadmin war stories I’ve read.

It’s amazing anything ever works.

/@matigo @JeremyCherfas

@tewha Start going to bed at 8 pm now?

@hazardwarning Most daylight bulbs are just bright white. If you’re looking for a full-spectrum LED, watch out for that.

/@c

@JeremyCherfas An outdated system Ruby on shared hosting is the main problem mentioned. Ruby being annoying to set up reliably across machines is in part why I switched from Octopress to Hugo.

/@matigo

@matigo I hear you. I haven’t played clarinet since 6th grade. Breath support and embouchure are surely totally gone by this point.

@matigo Yeah, I wouldn’t take that bet against kid costs. They just need ALL the things ALL the time. And not even BS stuff - legit needs: they outgrow shoes and clothing every time you turn around. (It pays well to find a local second-hand ring.)

@matigo You’d be surprised. I have the Roku sitting on top of the alarm panel, and the power strip velcroed to the wall behind the TV. Nothing touches the floor.

ETA: The Roku was velcroed to the back of the TV. Then it melted the adhesive and fell down a couple times before I gave up and perched it atop the alarm panel.

/@mrshaiku

@matigo Feeling the sax appeal?