AMD's Ryzen 7 is the budget X3D chip to get at just $300

A 3 ms ALTER can stall Postgres: how to migrate a 5-billion-row table with no downtime

An ALTER TABLE that takes 3 ms can still stall every query on the table. In my first demo it took 3 ms. In a second one, on real Postgres, a long transaction held the table, so a similar ALTER waited…

• 3 ms ALTER statement delays all queries on affected table.
• ALTER took 3 seconds after long-running transaction blocked table.
• Migration method minimizes downtime for 5-billion-row table.

1h ago ·dev.to

OnBlink: Communicate with minimal movement

This is a submission for the Presage SmartSpectra SDK Challenge What I Built OnBlink lets someone speak a phrase or open an app using only their eyes and a regular webcam. A blink signal opens a menu.

• OnBlink enables communication via minimal eye movements
• Uses SmartSpectra to detect double blinks, long blinks
• Customizable menu with phrases or app opening

1h ago ·dev.to

Commerce Dept. Chip Inquiry Was Halted After Nvidia Intervention

An anonymous reader quotes a report from The New York Times: Investigators at the Commerce Department were deep into a monthslong investigation of a Singaporean company that they suspected of…

1h ago ·tech.slashdot.org