Laura Friedl-Hirst, managing direction at LFH Regulatory explores what regulatory intelligence is and how it can benefit businesses.

Violins, the ink on the Declaration of Independence and other ways that insects shaped human history

Antimicrobial resistance could claim 39 million lives by 2050, yet the pipeline for new antibiotics is drying up. U.S. policy makers can help fix it

Expertise bulks up the brain’s ability to think deeply, a skill that may generalize across tasks

Damage to your environment can bring a profound sense of loss; that feeling, called solastalgia, can also provide inspiration

The multiverse offers no escape from our reality—which might be a very good thing

President-elect Donald Trump’s pick to lead the Department of Homeland Security and its disaster agency has said people aren’t driving temperature increases and declined to accept federal climate money for disaster preparedness as governor of South Dakota

Google is running a test to see what happens when news results are removed for 1% of users in Belgium, Croatia, Denmark, France, Greece, Italy, the Netherlands, Poland, …

London’s National Gallery is celebrating 200 years with newly digitised artworks, curated stories and an interactive AI experience connecting art and music on Google Art…

This post explores the challenges UK IT and security teams face due to legacy tech and the rise of generative AI. Results reveal a surge in security incidents and burno…

New features for Fitbit Ace LTE helps bring the family closer together and gives kids new ways to move.

An overview of Google’s work at APEC and the public-private partnerships expanding AI’s benefits to more people.

An overview of the new ways brands can stand out and make valuable connections on YouTube, including on Shorts and with creators.

Try Google Maps new explore feature, which finds hidden gems along your journey.

Alicia recently inherited a whole suite of home-grown enterprise applications. Like a lot of these kinds of systems, it needs to do batch processing. She went tracking down a mysterious IllegalStateException only to find this query causing the problem:

select * from data_import where id > 10000

The query itself is fine, but the code calling it checks to see if this query returned any rows- if it did, the code throws the IllegalStateException.

First, of course, this should be a COUNT(*) query- no need to actually return rows here. But also… what? Why do we fail if there are any transactions with an ID greater than 10000? Why on Earth would we care?

Well, the next query it runs is this:

update data_import set id=id+10000

Oh. Oh no. Oh nooooo. Are they… are they using the ID to also represent some state information about the status of the record? It sure seems like it!

The program then starts INSERTing data, using a counter which starts at 1. Once all the new data is added, the program then does:

delete from data_import where id > 10000

All this is done within a single method, with no transactions and no error handling. And yes, this is by design. You see, if anything goes wrong during the inserts, then the old records don't get deleted, so we can see that processing failed and correct it. And since the IDs are sequential and always start at 1, we can easily find which row caused the problem. Who needs logging or any sort of exception handling- just check your IDs.

The underlying reason why this started failing was because the inbound data started trying to add more than 10,000 rows, which meant the INSERTs started failing (since we already had rows there for this). Alicia wanted to fix this and clean up the process, but too many things depended on it working in this broken fashion. Instead, her boss implemented a quick and easy fix: they changed "10000" to "100000".

Former CNN anchor Don Lemon said on Wednesday he is leaving Elon Musk’s X, a decision made less than a year after X announced that “The Don Lemon Show” would appear on the social media platform three times a week. That deal was canceled before it was ever signed, and Lemon sued Musk and X […]

© 2024 TechCrunch. All rights reserved. For personal use only.

App developers now have a new way to promote their app launches, updates, and other new features on Apple’s App Store. First announced at the company’s Worldwide Developers Conference in June, Apple this week introduced a “Featuring Nominations” option in App Store Connect, which is the service developers use to submit their apps, games, and […]

© 2024 TechCrunch. All rights reserved. For personal use only.

Spotify CEO Daniel Ek has once again teased the company’s long-delayed HiFi or “super premium” tier, a higher-qualify subscription offering the streaming service first announced in 2021 and then failed to roll out. In the company’s third-quarter earnings call with investors on Wednesday, the exec suggested that such a product was still on the way, […]

© 2024 TechCrunch. All rights reserved. For personal use only.

The European Union is developing compliance guidance for its new law on AI. As part of that process it’s launched a consultation (here) seeking input in two areas. The first is how the law defines AI systems (as opposed to “simpler traditional” software). It’s asking people in the AI industry, business, academics, and civil society […]

© 2024 TechCrunch. All rights reserved. For personal use only.

U.K. consumer rights group ‘Which?’ is filing a legal claim against Apple under competition law on behalf of some 40 million users of iCloud, its cloud storage service. The collective proceeding lawsuit, which is seeking £3 billion in compensation damages (around $3.8 billion at current exchange rates), alleges that Apple has broken competition rules by […]

© 2024 TechCrunch. All rights reserved. For personal use only.

ADM Naveen Babu Death: എഡിഎം നവീൻ ബാബുവിന്റെ മരണത്തിൽ ആദ്യമായാണ് അന്വേഷണസംഘം പ്രശാന്തിന്റെ മൊഴി എടുത്തത്.  

കൊടുത്തത് കിട്ടുമെന്നും സിപിഎമ്മിന് കിട്ടിക്കൊണ്ടിരിക്കുകയാണെന്നുമായിരുന്നു കെ സുധാകരന്റെ പരിഹാസം.

EP Jayarajan autobiography controversy: ആത്മകഥയുമായി ബന്ധപ്പെട്ട് പുറത്ത് വന്ന വിഷയങ്ങളിൽ അന്വേഷണം വേണമെന്ന ് ഡിജിപിക്ക് നൽകിയ പരാതിയിൽ ആവശ്യപ്പെടുന്നു.

ഇടിമിന്നലിന്റെ ആദ്യ ലക്ഷണം കണ്ടുകഴിഞ്ഞാൽ ഉടൻ തന്നെ സുരക്ഷിതമായ കെട്ടിടത്തിനുള്ളിലേക്ക്‌ മാറുക. തുറസായ സ്ഥലങ്ങളിൽ തുടരുന്നത് ഇടിമിന്നലേൽക്കാനുള്ള സാധ്യത വർധിപ്പിക്കും.

Fifty Fifty Lottery Result: നിങ്ങളെടുത്ത ലോട്ടറിക്കാണോ ഒരു കോടി അടിച്ചത്? വിജയികളുടെ നമ്പറുകൾ അറിയാം...        

Rahul Gandhi: ചൂരൽമല മുണ്ടക്കൈ ദുരന്തത്തിന്റെ പശ്ചാതലത്തിൽ വയനാട് സുരക്ഷിതമാണെന്ന സന്ദേശം നൽകുന്നതിനാണ് അദ്ദേഹം സിപ് ലൈനിൽ കയറിയത്. 

Kodakara Hawala Money Case: ബിജെപി തൃശൂർ ജില്ലാ കമ്മിറ്റി മുൻ ഓഫീസ് സെക്രട്ടറി തിരൂർ സതീഷിന്റെ വെളിപ്പെടുത്തലിന് പിന്നാലെയാണ് തുടരന്വേഷണത്തിന് സർക്കാർ തയാറെടുക്കുന്നത്. 

തിരുവനന്തപുരത്തെ ഒ ബൈ താമര ഹോട്ടലിൽ വച്ചാണ് എംപവർ എക്സ് 1.0 സംഘടിപ്പിക്കുന്നത്.   

തെരഞ്ഞെടുപ്പ് കമ്മീഷന്‍റെ അന്തിമ കണക്ക് പ്രകാരം വയനാട്ടിൽ 64.53 ആണ് പോളിങ് ശതമാനം.  

Land Scam Case: അടുത്ത കാലങ്ങളില്‍ സാമ്പത്തികമായി പെട്ടന്ന് അഭിവൃദ്ധി പ്രാപിച്ച ബ്രോക്കര്‍മാരും പോലീസ് നിരീക്ഷണത്തിലാണ്. 

At 9 am on Wednesday, the air quality was 'very poor' with a reading of 366 which later rose to 418.

The city experienced heavy rainfall on Wednesday night, and the IMD bulletin indicates that several isolated areas of the capital are expected to see heavy downpours on Thursday.

The Kerala Lottery Result for Karunya Plus KN 547 is set to be drawn today (November 14, 2024). The draw is scheduled to be held at Gorky Bhavan near Bakery Junction in Thiruvananthapuram. The public can view the Winning Number post at 2.55 pm during the Kerala Lottery Today live broadcast.