/* Michael D O'Shea */

7.1K posts

/* Michael D O'Shea */

@MichaelDOShea

A Software Developer, closet Synthetic Organic Chemist, proud Kiwi, Otago University Graduate, Pink Floyd addict, migraineur, and more. What's not to like?

Oxfordshire/UK & Basel/CH Katılım Ekim 2011

327 Takip Edilen332 Takipçiler

/* Michael D O'Shea */@MichaelDOShea·10h

@MikeJPretzel Goodness, the idiots are out in full force at the moment Sir Mike Jansen .... and guess what, you're one of them x.com/MichaelDOShea/…

/* Michael D O'Shea */@MichaelDOShea

> Brexit dividend? Remember? If you voted for > that you're a moron. Happy holidays. @TheDesKelly you plonker, the UK was never in Shengen. This would have happened regardless and nowt to do with Brexit. Making this uninformed tweet is so typical of your type too.

English

Sir Mike Jansen #FBPPR #FBPE #RejoinEU #PropRep@MikeJPretzel·1d

Let’s be absolutely clear about the queues at Dover, Eurotunnel and airports – this is happening because of Brexit. ‘We’ voted for it. This is NOT the EU’s fault. #RejoinEU

English

926

665

2.8K

46.5K

/* Michael D O'Shea */@MichaelDOShea·10h

> RESIGN I think so too Steve. Having so-called burnout as a backbencher with no real other resonsibilities in a minor party just screams she's not up to the job. Education Secretary Estelle Morris recognised she wasn't up to the job and resigned. Good on her for self reflection and acting swiftly too. It's a pity many in the current government don't have this level of integrity, irrespective of the party.

English

Steve Miller@StevenJonMiller·1d

RESIGN 🚨👉Try working in the business world, try being a Nurse, try being a retail worker being abused daily. This is a Green Party MP, paid a fortune, possibly now off to watch daytime TV with her feet up.

English

486

1.1K

5.6K

142.5K

/* Michael D O'Shea */@MichaelDOShea·11h

@christiancalgie @RaynerUpdates And demonstrably without Ozempic .... well done.

English

123

Calgie@christiancalgie·1d

@RaynerUpdates Mate, I’ve lost 8.5 stone, I’ve got a pt, I’m living an active lifestyle and feeling truly healthy for the first time in years. What more do you want

English

542

29.5K

Angela Rayner Updates@RaynerUpdates·1d

Another fat L for Christian Calorie

Calgie@christiancalgie

Having to watch today’s Boro match through a window because I forgot when it was on and didn’t get out the pool in time

English

47K

/* Michael D O'Shea */@MichaelDOShea·11h

English

Des Kelly@TheDesKelly·1d

Brexit dividend? Remember? If you voted for that you're a moron. Happy holidays.

English

1.8K

266

1.6K

133.6K

/* Michael D O'Shea */@MichaelDOShea·11h

@vonderleyen Yet another AI generated "say nothing" (because I am sidelined) tweet from Ursula. It's all so pointless

English

Ursula von der Leyen@vonderleyen·14h

I welcome the progress towards an agreement between the US and Iran. We need a deal that truly de-escalates the conflict, reopens the Strait of Hormuz and guarantees toll free full freedom of navigation. Iran must not be allowed to develop a nuclear weapon. It must also end its destabilising actions in the region, directly or through proxies, as well as its unjustified and repeated attacks on its neighbours. Europe will continue working with international partners to seize this moment for a lasting diplomatic solution. And to contain the spillover of this conflict, notably on supply chains and energy prices.

English

3.3K

356

1.8K

596K

/* Michael D O'Shea */@MichaelDOShea·12h

> Brussels has just confirmed they are ready > to "fast track" Britain back into the EU They mean "fast track payments" back into the EU

English

731

David Shaw@David90shaw·13h

🚨 I TOLD YOU! The plot to completely reverse Brexit and sell out the UK is officially underway. Brussels has just confirmed they are ready to "fast track" Britain back into the EU, calling our return a "major victory for the European project". The catch? Re-accession talks will force us to adopt the Euro and kill off the pound. I warned you for weeks that the Labour establishment was preparing the ultimate betrayal, and now they are openly coordinating with EU officials to make it happen. Absolutely sickening. 🇬🇧📉

English

335

1.5K

3.3K

108.7K

/* Michael D O'Shea */@MichaelDOShea·12h

Exactly! So many experts lack appreciation that SQL is primarily a declarative language, and that the query as written is not the query that will necessarily be executed. I am not writing that execution query optimisation is simple, just that the optimisation step will factor out the addition in the WHERE clause to use the index.

English

Senthil@besenthil·13h

@SumitM_X Good DB engines should rewrite the query as salary > 68000 And make use of the index

English

310

SumitM@SumitM_X·15h

You created an index on salary. SELECT * FROM employees WHERE salary + 2000 > 70000; Will the index be used in above query?

English

14.7K

/* Michael D O'Shea */@MichaelDOShea·1d

@jahirsheikh8 A database sequence is the obvious answer. Even then I'd ask myself whether an Order ID need to be sequential in the first place. It seems an odd implementation decision.

English

141

Jahir Sheikh@jahirsheikh8·1d

Senior backend interview question: A junior dev added this to generate order IDs: SELECT MAX(id) + 1 FROM orders It worked perfectly in testing. Then Black Friday traffic hit. Suddenly: • duplicate IDs • failed payments • missing orders What went wrong and how do you fix it properly?

English

14.8K

/* Michael D O'Shea */@MichaelDOShea·1d

@Umesh__digital To avoid the "dead" option and I'd spend 5 mins using file_fdw(.......). Then I'd look at chunking, parallel ingestion, ALTER TABLE xxxx SET UNLOGGED to reduce I/O contention (to speed up I/O, in this ingestion likely to be the bottleneck), and so on and so on.

English

374

Umesh Kumar Yadav@Umesh__digital·2d

Google Interviewer: You’re given a single CSV file with 100M rows. You need to reliably persist all of it into a PostgreSQL table by tonight or you’re dead. How would you approach the problem.

English

183

52.8K

/* Michael D O'Shea */@MichaelDOShea·17 May

Aha, but it is shrewd politicking. Labour are currently polling at 17% The referendum "remainers" lost at 48% By attempting to resurect societal division with this Brexit thing, again (yawn), he/they are hoping to improve Labour polling and their chances for reelection. It does afterall divert attention from illegal immigration and the country falling apart due to political and economic mismanagement. They're not fooling me. I am not going to let them set the agenda, likely decided by some Labour spindoctor, with the goal of saving their political skins. Sorry.

English

Politics UK@PolitlcsUK·16 May

🚨 BREAKING: Wes Streeting calls for the Government to rejoin the EU "Leaving the EU was a catastrophic mistake"

English

3.1K

1.9K

14K

2.6M

/* Michael D O'Shea */@MichaelDOShea·17 May

@SusanCowell @Keir_Starmer And his future income ... other than the Keir Starmer pension act, that's it! No one would be interested in buying his memoirs/autobiography and the normally lucrative global speaking circuit won't be open to him either. legislation.gov.uk/uksi/2013/2588…

English

Susan Cowell@SusanCowell·17 May

I wonder where @Keir_Starmer will go and live once he’s stepped down, because let’s face it, he’s not going to be able to walk the streets without getting heckled for the rest of his life here 🤔

English

576

486

66.3K

/* Michael D O'Shea */@MichaelDOShea·17 May

> What exactly will this return? "Exactly" ..... well none of the multichoice options provided, that's for sure. AVG is just averaging salaries for where the salary isn't NULL for starters. NULL doesn't mean 0.00, it just means missing. Another obvious point, there's not even a predicate to check that the employee is active/current/still employed ....

English

104

Ritesh Roushan@devXritesh·17 May

Backend Interview Problem: You have this SQL query What exactly will this return? A) Highest paid employee only B) Employees earning above average salary C) Employees with duplicate salaries D) All employees What’s the correct answer?

English

283

87.7K

/* Michael D O'Shea */@MichaelDOShea·16 May

@sudox7 Somewhat interestingly Dave Plummer tweeted this last night, and in his clear piece to camera explains the problem with this approach and others generally x.com/davepl1968/sta…

Dave W Plummer@davepl1968

malloc() is lying to you. Find out why, and how the illusion works!

English

1.4K

SudoX7@sudox7·16 May

i replaced malloc with my own implementation. the real one is just a linked list of memory blocks sitting on top of one syscall

English

272

23.9K

/* Michael D O'Shea */@MichaelDOShea·16 May

> Keir Starmer has a massive mandate given to > him by the British people at the general election 33% massive ... ?? Grow up.

English

Dale Vince@DaleVince·16 May

I just don’t think there should be a leadership challenge. Keir Starmer has a massive mandate given to him by the British people at the general election. I don’t think anybody in the Cabinet has a right to try to overturn that. I still hope there won’t be a leadership contest. If there is, it’s probable that Keir will stand himself and in which case, I’d be in his camp. What we need now is continuity. We need Labour to deliver on their manifesto. We haven’t even been two years into this government. telegraph.co.uk/gift/d0332ac86…

English

2.7K

785

2.9K

117K

/* Michael D O'Shea */@MichaelDOShea·16 May

@NJ_Timothy > The problem isn't Starmer. It's Labour. Well put!

English

Nick Timothy MP@NJ_Timothy·16 May

They think they can do what they like without a mandate. The problem isn't Starmer. It's Labour.

English

481

2.7K

11K

99.2K

/* Michael D O'Shea */@MichaelDOShea·16 May

@James7Holland And today of all days, he still can't read the room ..... x.com/TheBritishInte… He should be focussing on what matters and that is our broken politics/politicians/policies.

British Intel@TheBritishIntel

🇬🇧 4,000 POLICE DEPLOYED FOR TOMMY ROBINSON RALLY The Metropolitan Police are deploying over 4,000 officers, drones, helicopters and live facial recognition for this weekend’s Unite the Kingdom rally in London. Large numbers of officers are expected to be in riot gear for what is primarily a demonstration centred around free speech, immigration and national identity. Meanwhile countless other disruptive protests across Britain are routinely handled with a far softer approach and far less policing. More and more people are asking the same question - why does one set of protesters face overwhelming force while others appear to get endless leniency? The accusations of two-tier policing are only going to grow louder after this.

English

123

James Holland@James7Holland·16 May

Translation: I won’t admit I want to rejoin the EU when running to be elected. I’ll do that only once I’m safely in office. But I’ll happily state this publicly before the election. This current crop of politicians must be some of the very worst in history.

Alex Wickham@alexwickham

NEW: Andy Burnham confirms to ITV he wants to rejoin the EU in future But he says he doesn’t want to advocate that at this by-election (presumably because it’s a very pro-Leave seat) “In the long-term there is a case for that, but I'm not advocating that in this by-election”

English

140

556

11.1K

/* Michael D O'Shea */@MichaelDOShea·16 May

I know Michael ... he's flogging a dead horse with this EU thing. Another idiom, the elephant in the room isn't the EU now and it's far from the panacea to our current problems, the opposite in fact. If he cannot see this, he's unfit for office or out of touch or both.

English

Michael Fabricant 🇬🇧🇺🇸🇮🇱🇺🇦@Mike_Fabricant·16 May

Put me right off HIM‼️

Politics UK@PolitlcsUK

🚨 BREAKING: Wes Streeting calls for the Government to rejoin the EU "Leaving the EU was a catastrophic mistake"

English

431

6.2K

/* Michael D O'Shea */@MichaelDOShea·16 May

@PolitlcsUK > "Leaving the EU was a catastrophic mistake" Why always say "Leaving the EU ...." It was really "Paying the EU ...."

English

/* Michael D O'Shea */@MichaelDOShea·16 May

@Inevitablewest Yet the governing classes still won't get it. They're unfit to govern, causing the problems and division. We need to replace the lot of them, and not by recycling the old faces either.

English