The Death of the Mind

Designing a database schema, whether for a new application or a new feature, always raises a lot of questions. The choices you make can have a big impact on how well your database performs and how easy it is to maintain and scale. Whether you’re just getting started with PostgreSQL or consider yourself a seasoned pro, it’s easy to rely on old habits or outdated advice. In this article, I want to take a fresh look at one of those topics that often sparks debate: the use of ENUMs in PostgreSQL.
I have to admit, not so long ago, I would advise “don’t use ENUMs” without thinking about it too much. Relying only on random articles and…

External feed Read More at the Source: https://postgr.es/p/6CK

On September 6, the Nevada Supreme Court voted 5-2 to remove the Green Party from the ballot. Nevada State Democratic Party v Nevada Green Party, 24 OC 00107.1B. The lower court had kept the party on the ballot. Here is the 18-page opinion.
When the Green Party began its petition drive, the Nevada Secretary of State furnished a sample form. But, the Nevada Secretary of State sent an incorrect version. The petition blank should have contained a sentence saying the circulator attests that, to his or her belief, all the signatures were of registered voters. The petition blank for initiatives does not have such a requirement. Furthermore the requirement that this sentence be included is not mentioned…

External feed Read More at the Source: https://ballot-access.org/2024/09/07/nevada-supreme-court-removes-the-green-party-from-the-ballot/

This is going to be something different, and maybe to explain where I’ve been the last month. Setting myself up for failure Back in 2012, I had been laid off, but during my exit interview, something odd happened, the company that had bought us out to crush us had their entire networking group walk. The directory apparently got a good offer, but in the DEC tradition, he’d told them that he was going to take everyone with him. Everyone from the engineers, the team manager, to even the cable runners. The entire group walked. I can’t corroborate this, but during my exit interview the HR people reading over my roles, had taken a keen interest…

External feed Read More at the Source: https://virtuallyfun.com/2024/09/07/finding-a-job-in-this-modern-era/

The New York Times reports that an exhaustive study of election results in 2022 finds almost half of all partisan races only had one candidate on the ballot. See the article here. … Continue reading →

External feed Read More at the Source: https://ballot-access.org/2024/09/04/exhaustive-study-shows-almost-half-of-partisan-races-in-2022-had-only-one-candidate-on-the-ballot/

In the battle between Elon Musk and Brazilian Supreme Court Justice Alexandre de Moraes, the biggest losers are Brazilians. They are now at risk of being stripped of VPNs while facing massive fines if they somehow get around a countrywide ban on ExTwitter.
Yesterday, I wrote about the standoff between Elon Musk and Brazil, and how neither side comes out of it looking very good. Where it was left was that Brazilian Supreme Court Justice Alexandre de Moraes was (1) freezing Starlink assets and (2) threatening to ban ExTwitter entirely from the country.
As we noted, there was nothing particularly new about the second point. Brazil has done this in the past with WhatsApp and Telegram. The freezing…

External feed Read More at the Source: https://www.techdirt.com/2024/08/30/brazil-bans-extwitter-in-battle-with-musk-takes-vpns-users-down-with-it/

Enlarge / A recall notice is posted next to Boar’s Head meats that are displayed at a Safeway store on July 31, 2024, in San Rafael, California. (credit: Getty | Justin Sullivan)
Federal inspections found 69 violations—many grisly—at the Boar’s Head meat facility at the center of a deadly, nationwide Listeria outbreak that has now killed nine people, sickened and hospitalized a total of 57 across 18 states, and spurred the nationwide recall of more than 7 million pounds of meat.
The Jarratt, Virginia-based facility had repeated problems with mold, water leaks, dirty equipment and rooms, meat debris stuck on walls and equipment, various bugs, and, at one point, puddles of blood on the floor,…

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

It is with great sadness that I find myself penning the hardest news post I’ve ever needed to write here at AnandTech. After over 27 years of covering the wide – and wild – word of computing hardware, today is AnandTech’s final day of publication. For better or worse, we’ve reached the end of a long journey – one that started with a review of an AMD processor, and has ended with the review of an AMD processor. It’s fittingly poetic, but it is also a testament to the fact that we’ve spent the last 27 years doing what we love, covering the chips that are the lifeblood of the computing industry. A lot of things…

External feed Read More at the Source: https://www.anandtech.com/show/21542/end-of-the-road-an-anandtech-farewell

Crunchy Data is pleased to announce a new open source
pgMonitor Extension.
Crunchy Data has worked on a pgMonitor tool for several years as part of our
Kubernetes
and
self-managed Postgres
deployments and recently we’ve added an extension to the tool set.
Two primary scenarios motivated the creation of the pgMonitor extension :

Quicker Metrics: Monitoring metrics often need quick response times to
allow for frequent updates. We’ve noticed that certain metrics become slower
as the database grows. This impacts not only common metrics but also more
complex business metrics that could require several minutes to generate.
Version Compatibility: New PostgreSQL versions can break existing metrics
due to changes in the catalogs. Managing different metric sets for various
PostgreSQL versions is tedious and can be challenging.

Benefits of the pgMonitor extension
The…

External feed Read More at the Source: https://postgr.es/p/6Cc