RSS Feeds

The former gang leader was charged with planning the drive-by shooting that killed Tupac Shakur in 1996

Jurors on Thursday heard Duane “Keffe D” Davis tell detectives in 2008 that his nephew Orlando “Baby Lane” Anderson fired the shots that killed Tupac Shakur.

Davis, who said in the interview that he was also in the car with Anderson, is accused of orchestrating the 1996 killing of the 25-year-old hip-hop superstar in Las Vegas. At the time of the interview, his nephew had been dead for a decade.

State senator beats rival Melissa Hernandez and will replace US congressman who quit amid sexual misconduct claims

Progressive Aisha Wahab has been elected to Congress in a special election following a bitter intra-party battle over the seat formerly held by Eric Swalwell, who resigned in April after facing sexual misconduct allegations. Swalwell has denied the allegations.

Wahab, a state senator, was widely considered the frontrunner in the district in California’s East Bay and had the backing of the state Democratic party as well as Our Revolution, labor unions, local officials and the state’s attorney general, Rob Bonta.

The Israeli ambassador has claimed ‘a court came to a decision that there’s no criminal liability’ but there is no evidence that any court has been involved

Zomi Frankcom did not deserve to die. She and her six colleagues were traveling in a clearly marked humanitarian convoy to distribute food to starving Palestinians on a route that had been communicated well in advance to the Israel Defense Forces (IDF). It bombed them deliberately and repeatedly. Israel’s prime minister, Benjamin Netanyahu, announced the next day that the attack was a “mistake” and a few days later its two commanders were forced to retire, and three others were disciplined. An internal inquiry followed, but this week – well over two years later – the IDF announced that there would be no further investigation because there could be no suspicion that any crime had been committed: it was merely a mistake. This is a serious misunderstanding of the law of war.

Mistakes may have fatal consequences and, if they are the result of gross negligence or reckless or irresponsible conduct, they are culpable and deserving of punishment. The crime of manslaughter in Australian and English law reflects this grave level of criminality. In war law, under article 8 of the statute of the international criminal court (ICC) “intentionally launching an attack in the knowledge that such an attack will cause loss of life to civilians” and “directing attacks against personnel or vehicles involved in humanitarian assistance” are serious war crimes which may be committed by mistakes made through negligence or blind eyes turned to their foreseeable consequences. The IDF decision not to investigate Zomi’s killing on the grounds that it was merely a “mistake” is not a legitimate reason and the Israeli government’s refusal even now to apologise is despicable.

President’s one-time ‘attack dog’ became his fierce critic – but now Cohen says he has forgiven his former boss

Donald Trump has given a radio interview to none other than Michael Cohen, his former longtime personal fixer turned fierce critic, after an apparent reconciliation set the stage for their first public conversation in eight years.

Cohen once had such a tight relationship with the US president that he described himself back in the day as his “attack dog with a law license”, but later became the star witness in Trump’s 2024 criminal trial over his hush-money payments to the adult film star Stormy Daniels. Trump was found guilty on 34 counts of falsifying business records in an effort to interfere with the 2016 election.

Manchester United’s new-look midfield, Ipswich’s ambition is tested and Kevin Keegan tributes at Newcastle

While Myles Lewis-Skelly looks likely to remain at the Emirates, the same can’t be said for Ethan Nwaneri. The 19-year-old was outstanding in his breakthrough season for Arsenal in 2024-25 but barely featured last season and was sent on loan to Marseille. That didn’t really work out and Arsenal are now exploring another temporary move to ensure Nwaneri gets regular football this season. Milan, RB Leipzig, Dortmund and Fulham are all thought to be interested, with Nwaneri unlikely to feature on the bench for Friday’s opener against Coventry as a result. Whether Gabriel Martinelli and Gabriel Jesus are available remains to be seen as Arsenal attempt to find suitors for the Brazil duo. Ed Aarons

Arsenal v Coventry City, Friday 8pm (all times BST)

Hull City v Manchester United, Saturday 12.30pm

Everton v Crystal Palace, Saturday 3pm

Ipswich Town v Sunderland, Saturday 3pm

Nottingham Forest v Leeds, Saturday 3pm

Brighton v Aston Villa, Sunday 2pm

Manchester City v Bournemouth, Sunday 2pm

Sunderland fans hope Régis Le Bris and his talented squad can continue to surprise the pundits and Opta

Guardian writers’ predicted position: 14th (NB: this is not necessarily Louise Taylor’s prediction but the average of our writers’ tips)

Last season’s position: 7th

• Cox: ‘We were hoping one of us would have kicked on’

• Sam Curran will miss rest of the summer due to injury

Jordan Cox was one of four half-centurions as England maintained control of the first Test against Pakistan – but there were a few regrets as no one reached three figures on day two in Leeds.

“We were hoping one of us would have kicked on and instead of make it just a hundred, make it 150, 160, 170,” said Cox, who hit 73 in his first Test innings at No 3. “And then the game looks, not completely different, but it puts us in definitely a better position.”

LibreDB Studio is an MIT-licensed, self-hosted SQL IDE for PostgreSQL that runs in the browser and deploys as a container or Helm chart.

It is deployed next to the database it manages, as a container, a Helm chart or an npm package, rather than installed on each developer's machine. PostgreSQL is its reference implementation: the provider is built on node-postgres, and the other supported engines follow the patterns established there.

On a PostgreSQL connection the editor uses pooled connections, explicit BEGIN/COMMIT/ROLLBACK transactions with an auto-rollback timeout, and query cancellation through pg_cancel_backend on the tracked backend PID. Schema introspection is written to stay responsive on databases with hundreds of tables: the table tree renders from a first pass while relationships stream in from a second. Monitoring reads the pg_stat_* views, including pg_stat_statements where the extension is installed, and degrades to what the connected role can actually see instead of failing when superuser-only views are unavailable.

The optional query assistant is constrained by the database rather than by prompt text. A run is given the real schema of the connected database before its first turn, so a drafted statement names objects that exist, and read-only runs execute inside BEGIN READ ONLY as a single statement over the extended protocol. Authentication is local accounts or OIDC, with role-based access control in front of every API route.

The current release is 0.12.0. Source, documentation and the PostgreSQL provider reference are at github.com/libredb/libredb-studio and libredb.org.