Chris Ellis @intrbiz@bergamot.social
Admin
PostgreSQL, Linux, Java, and more. Lover of computers, electronics and Open Source. European. Lib Dem. Lead Technical Strategist nexteam.co.uk
Joined Nov 2022
Chris Ellis
boosted
75 years ago today, European nations signed this Convention, so the Holocaust could not be repeated. Beware those who want this to end.
Chris Ellis
boosted
Chris Ellis
boosted
@lproven I've read a lot of compelling arguments about how these LLMs will not achieve AGI. However the goal is AGI and the world is currently throwing about twenty percent of GDP at that goal. It's basically a modern day Manhattan project. With that said I would not bet against achieving AGI at some time in the near future.
Chris Ellis
boosted
How AGI became the most consequential conspiracy theory of our time (MIT Technology Review)
The idea that machines will be as smart as—or smarter than—humans has hijacked an entire industry. But look closely & you’ll see it’s a myth that persists for many of the same reasons conspiracies do.
In PostgreSQL we could do:
CREATE TABLE t (a int, b int);
INSERT INTO t VALUES (1, 2), (3, 4), (5, 6);
SELECT t.*
FROM t
JOIN (
VALUES (1, 2), (3, 4)
) v(a, b)
ON (t.a = v.a AND t.b = v.b);
a | b
---+---
1 | 2
3 | 4
Another approach would be an array for a and b:
SELECT *
FROM t
WHERE a = ANY(ARRAY[1, 3])
AND b = ANY(ARRAY[2, 4]);
If you really wanted the 2d array, then there are ways to unpack that and join against it.
Chris Ellis
boosted
After three years and more than 3,100 miles (5,000 kilometers) of sailing in a Viking replica vessel, archaeologist Greer Jarrett from Lund University in Sweden has authored a trailblazing report on Viking seafaring. His work, published in the Journal of Archaeological Method and Theory, suggests that the Viking trade routes were more extensive, decentralized, and offshore than previously believed.
© Archaeology News
@azonenberg EVs seem to get quoted at about 75% efficiency.
Not sure about the charging losses, but I suspect at higher rates it's not that good.
As good as EVs are getting, the energy density of Petrol is likely still an order of magnitude greater.
Would be nice to see more battery swap approaches to rapid charging, admittedly mechanically complicated.
Standard petrol pump can do about 50 litres per minute.
Energy in 1 litre of petrol is about 33MJ.
My basic maths would ~27MW of energy transferred each second.
Assume 30% engine efficiency, still talking say 9MW.
Which seems at least an order of magnitude over the best EV charger.
Chris Ellis
boosted
For the first time since I started attending FOSDEM in 2010, there will be no PostgreSQL Devroom in 2026. Feels unbelievable for one of the defining open source projects of the last decade.
At least there's #FOSDEMPGDay.
#PostgreSQL #Postgres #FOSDEM #Devroom #Community #OpenSource #FOSDEM2026
@ChrisMayLA6 first time I saw The War Game was in Hack Green Nuclear Bunker, which only made it more poignant.
Admin
PostgreSQL, Linux, Java, and more. Lover of computers, electronics and Open Source. European. Lib Dem. Lead Technical Strategist nexteam.co.uk
Joined Nov 2022
