May 102021
 

Having written over 600 blog entries, I thought I would have already covered the complexities of the
CLUSTER command, but it seems I have not, so let’s do that now.

CLUSTER is an unusual SQL command because, like non-unique CREATE INDEX, it only affects performance. In fact,
CLUSTER requires the existence of an index. So, what does CLUSTER do? Well, what does CREATE INDEX do? Let’s look at how storage works in Postgres.

User data rows are stored in heap files in the file system, and those rows are stored in an indeterminate order. If the table is initially
loaded in INSERT/COPY order, later inserts, updates, and deletes will cause rows to be added in unpredictable order in the heap…

External feed Read More at the Source: https://postgr.es/p/54g

 2021-05-10  Comments Off on Planet PostgreSQL – Bruce Momjian: Clustering a Table
May 102021
 

Earlier in the morning, 1,000 security forces stormed the al-Aqsa Mosque compound in East Jerusalem as worshippers were praying, firing stun grenades, tear gas and rubber bullets, while snipers took up positions on rooftops, injuring more than 330 Palestinians.

External feed Read More at the Source: http://www.wsws.org/en/articles/2021/05/11/isra-m11.html

 2021-05-10  Comments Off on World Socialist Web Site (en) – Israel kills 20 in Gaza, including children, as Netanyahu steps up provocations on Jerusalem Day
May 102021
 

If you’ve been following along with us, the past several months haven’t gone great for streaming platform Twitch. It all started with Twitch’s decision to simply nuke a bunch of streamer content as a result of a massive influx of DMCA notices it received. While Twitch streamers and some in the public went ballistic over this, the company decided to try to distract the world with bright shiny objects like emojis, only to continue to let the DMCApocalypse continue even after it apologized for its lack of transparency. Then Amazon, which owns Twitch, put on Twitch’s GlitchCon and spent a pretty penny on it, while streamers on the platform wondered why Amazon didn’t just spend that…

External feed Read More at the Source: https://www.techdirt.com/articles/20210505/11421146738/twitch-takes-steps-to-make-it-even-easier-to-issue-dmca-strikes-against-streamers.shtml

 2021-05-10  Comments Off on Techdirt. – Twitch Takes Steps To Make It Even Easier To Issue DMCA Strikes Against Streamers
May 092021
 

Older readers may remember the Stylophone, a small battery powered electric organ using conductive PCB pads and a stylus to create notes. The simple multivibrators in those instruments made them monophonic, but here in 2021 we can do better than that! [Sjm4306] has gone the extra mile with a PCB organ, by making a capacitive-touch instrument that boasts four-note polyphony.
At its heart is an ATmega328p whose software sports four tone generators that each emerge on a different pin. These are summed using a set of 100 Ω resistors and fed to a tiny speaker. Power comes from a CR2032 lithium cell, and he notes that a higher voltage delivers more volume.
The full story is detailed in…

External feed Read More at the Source: https://hackaday.com/2021/05/09/polyphony-on-a-tiny-scale/

 2021-05-09  Comments Off on Hackaday – Polyphony On A Tiny Scale
May 072021
 

The Labor Department reported just 266,000 new jobs in April, far below predictions of 1 million or more, evoking loud calls from Republicans for an end to pandemic relief measures.

External feed Read More at the Source: http://www.wsws.org/en/articles/2021/05/08/jobs-m08.html

 2021-05-07  Comments Off on World Socialist Web Site (en) – Weak US jobs reports sparks calls for elimination of pandemic aid
May 072021
 

I always thought it would be a great honor to be referenced in the hallowed pages of WIRED magazine. Like Mike, I’ve been reading it since its beginning, as a then student studying information technology and watching the Internet take hold in the world.

This week it finally happened, and ugh… My work was referenced in support of a terrible take on Section 230, which not only argued that Section 230 should be repealed (something that I spend a great deal of personal and professional energy trying to push back against) but masqueraded as a factual explanation of how there was no possible reasonable defense of the law and that therefore all its defenders (including me) are,…

External feed Read More at the Source: https://www.techdirt.com/articles/20210507/08280746747/thanks-to-section-230-i-can-correct-wireds-portrayal-my-section-230-advocacy.shtml

 2021-05-07  Comments Off on Techdirt. – Thanks To Section 230, I Can Correct Wired’s Portrayal Of My Section 230 Advocacy
May 062021
 

For almost 15 years the website LiveLeak shocked and entertained the internet. If you wanted to see uncensored and horrifying footage of war and violence that YouTube wouldn’t allow, then LiveLeak would serve it up to you. In 2014, Business Insider called it “The Islamic State’s favorite site for beheading videos.” Now, LiveLeak is gone, replaced with a softer sounding video website called ItemFix that eschews the violence and gore that made LiveLeak a staple of the dark side of the internet. “Nothing lasts forever though and—as we did all those years ago—we felt LiveLeak had achieved all that it could and it was time for us to try something new and exciting,” LiveLeak co-founder Hayden…

External feed Read More at the Source: https://www.vice.com/en_us/article/qj88w7/liveleak-the-infamous-site-for-beheading-videos-is-gone

 2021-05-06  Comments Off on Motherboard – LiveLeak, the Infamous Site for Beheading Videos, Is Gone
May 062021
 

Cancel culture is at a crossroads, seems to me.  And I might as well be at the center of it.  If I wasn’t before, I appear to be now.
But what is cancel culture?  Isn’t that a rightwing term used to excuse bigoted behavior and avoid accountability for said behavior?  Yes, that’s how the right uses the concept — as a weapon against the rest of society.
And that’s all I’ll say about that.  Now to the left.  Cancel culture on the left also exists.  The people claiming otherwise are part of the left’s version of cancel culture.  (Note to anarchists:  when I use the term “left,” this includes you, too.  We can argue about the semantics of…

External feed Read More at the Source: https://www.counterpunch.org/2021/05/06/cancel-culture-conundrums/

 2021-05-06  Comments Off on CounterPunch.org – Cancel Culture Conundrums
May 062021
 

The attack on classical studies is part of a broader assault on the humanities, art and culture in American society.

External feed Read More at the Source: http://www.wsws.org/en/articles/2021/05/06/howa-m06.html

 2021-05-06  Comments Off on World Socialist Web Site (en) – Howard University students and educators protest elimination of classical studies department
May 062021
 

On May 5, the proponents of several Ohio initiatives filed this brief in U.S. District Court, in Thompson v DeWine, s.d., 2:20cv-2129. This is the case over petitioning relief for initiatives. Although the Sixth Circuit denied injunctive relief (and the U.S. Supreme Court refused to get involved), that doesn’t necessarily mean Ohio’s policy is constitutional. The proponents of the initiatives will seek a ruling that Ohio violates the First Amendment by its policy. Here is the brief.

External feed Read More at the Source: http://ballot-access.org/2021/05/05/ohio-initiative-proponents-will-seek-a-ruling-in-u-s-district-court-that-constitution-required-petitioning-relief-during-covid/

 2021-05-06  Comments Off on Ballot Access News – Ohio Initiative Proponents Will Seek a Ruling in U.S. District Court that Constitution Requires Petitioning Relief During Covid
May 062021
 

Enlarge / Before you tweet, you might be asked if you meant to be so rude. (credit: Getty Images / Sam Machkovech)
Want to know exactly what Twitter’s fleet of text-combing, dictionary-parsing bots defines as “mean”? Starting any day now, you’ll have instant access to that data—at least, whenever a stern auto-moderator says you’re not tweeting politely.
On Wednesday, members of Twitter’s product-design team confirmed that a new automatic prompt will begin rolling out for all Twitter users, regardless of platform and device, that activates when a post’s language crosses Twitter’s threshold of “potentially harmful or offensive language.” This follows a number of limited-user tests of the notices beginning in May of last year. Soon, any robo-moderated…

External feed Read More at the Source: https://arstechnica.com/?p=1762846

 2021-05-06  Comments Off on Ars Technica – Twitter’s latest robo-nag will flag “harmful” language before you post