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
The simple case is just a cross join of your A and B groups, eg:
SELECT * FROM
(SELECT e FROM l WHERE e LIKE 'A%') a
CROSS JOIN
(SELECT e FROM l WHERE e LIKE 'B%') b;
For the more complex case I think all approaches you try will run into the output columns need to be known and can't be dynamically materialised, ie with crosstab.
Likely you can do it in a function which computes the groups, builds a dynamic query and returns JSON.
Chris Ellis
boosted
https://www.bbc.co.uk/news/articles/c5y6r9rdxygo - I am beyond furious about this bit of news.
The Lovell Telescope has - from day one - been a project that has produced incredible results on a shoestring budget, using whatever Lovell could scrounge to produce an instrument that has reshaped our view of the Universe.
(I was observing OH- masers there the day Shoemaker-Levy 9 hit Jupiter.)
The budget needed to keep it running is a rounding error when compared to government spend on 'AI'.
Closing it is criminal folly.
Chris Ellis
boosted
If you’re still using anything made by 37signals, this is the shit you’re supporting. https://world.hey.com/dhh/three-sacred-cows-that-must-die-so-europe-can-live-1afb203d
Right, EMF Camp here we come.
Chris Ellis
boosted
Sometimes you read something that tells you what you already know…but you feel as if for the first time.
I read this searing piece through hot tears of rage and renewed determination.
Canada should be using every tool we have - legal, diplomatic, economic - to rein in and isolate this rogue state.
It should be a national scandal that we aren’t.
@Floppy or solder some male headers back to back to jumper them.
@Floppy why not just crimp the dupont terminals onto the ribbon cable?
Chris Ellis
boosted
“In Finland, the number of homeless people has fallen sharply. Those affected receive a small apartment & counselling with no preconditions. 4 out of 5 people affected make their way back to a stable life. And all this is CHEAPER than accepting homelessness.”
IT SAVES PUBLIC MONEY to house people.
Finland ends homelessness and ...
Chris Ellis
boosted
A British court tried protesters for criminal damage, but then sentenced them for terrorism, a charge that was never presented to the jury. This proceeding contravenes a fundamental principle of law.
And sadly a lot of IT architects only seem to exist because companies still struggle with the very flat career hierarchy of IT. What they really need to learn is how to recognise and reward good people working at the metaphorical coal face.
But 20 years in, I'm yet to find a company whom would just recognise someone for being a bloody good engineer and nothing more.
Pretty much every IT architect I've worked with, has had very faded and unrealistic technical knowledge.
That is often a significant counterpoint to the team. Where they frequently have more 'upto date' knowledge but lack the experience to understand past endeavours.
I think the closest analogue in IT to building architects are actually product managers.
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
