The Case Against SQL Slashdotby EditorDavid on database at January 1, 1970, 1:00 am (cached at July 18, 2021, 11:35 pm)

Long-time Slashdot reader RoccamOccam shares "an interesting take on SQL and its issues from Jamie Brandon (who describes himself as an independent researcher who's built database engines, query planners, compilers, developer tools and interfaces). It's title? "Against SQL." The relational model is great... But SQL is the only widely-used implementation of the relational model, and it is: Inexpressive, Incompressible, Non-porous. This isn't just a matter of some constant programmer overhead, like SQL queries taking 20% longer to write. The fact that these issues exist in our dominant model for accessing data has dramatic downstream effects for the entire industry: - Complexity is a massive drag on quality and innovation in runtime and tooling - The need for an application layer with hand-written coordination between database and client renders useless most of the best features of relational databases The core message that I want people to take away is that there is potentially a huge amount of value to be unlocked by replacing SQL, and more generally in rethinking where and how we draw the lines between databases, query languages and programming languages... I'd like to finish with this quote from Michael Stonebraker, one of the most prominent figures in the history of relational databases: "My biggest complaint about System R is that the team never stopped to clean up SQL... All the annoying features of the language have endured to this day. SQL will be the COBOL of 2020..." It's been interesting to follow the discussion on Twitter, where the post's author tweeted screenshots of actual SQL code to illustrate various shortcomings. But he also notes that "The SQL spec (part 2 = 1732) pages is more than twice the length of the Javascript 2021 spec (879 pages), almost matches the C++ 2020 spec (1853) pages and contains 411 occurrences of 'implementation-defined', occurrences which include type inference and error propagation." His Twitter feed also includes a supportive retweet from Rust creator Graydon Hoare, and from a Tetrane developer who says "The Rust of SQL remains to be invented. I would like to see it come."

Read more of this story at Slashdot.

[no title] Scripting News(cached at July 18, 2021, 11:02 pm)

We're living in the post-apocalyptic world. Somehow we got used to it.
[no title] Scripting News(cached at July 18, 2021, 11:02 pm)

Memeorandom has been a regular stop for me for news for decades, is now mostly links to news that's behind paywalls. I couldn’t possibly pay for most of them, too many subs to manage, and I don’t read enough of any individual pub to justify subscribing. I do subscribe to NYT and Washington Post. But I don’t get enough value from either, honestly. This continues to be a lousy situation. The pubs only talk about how news is broken from their point of view, but the readers point of view matters as much, if not more.
Boeing Slows 'Dreamliner' Production After New Manufacturing Issue Slashdotby EditorDavid on transportation at January 1, 1970, 1:00 am (cached at July 18, 2021, 10:35 pm)

"A new production problem has surfaced with Boeing's 787 Dreamliner, further delaying deliveries of the popular wide-body jets..." writes the Wall Street Journal. Long-time Slashdot reader phalse phace shares their report: Boeing halted handing over Dreamliners to airlines in late May, after federal air-safety regulators declined to approve the plane maker's proposed method of inspecting the jets for previously disclosed production defects. It was the second such pause in the past year... The Federal Aviation Administration said the newly discovered quality issue posed no immediate safety threat. While the agency will determine whether to require modifications to 787s already in service, the FAA said: "Boeing has committed to fix these airplanes before resuming deliveries..." The new problem surfaced on part of the aircraft known as the forward pressure bulkhead at the front of the plane, people familiar with the matter said. It involves the skin of the aircraft and is similar to a previously disclosed Dreamliner issue found elsewhere on the planes, one of these people said. It surfaced as part of the FAA's review of Boeing's quality checks on newly produced undelivered planes, this person said. The delivery pause has been another setback for the aerospace giant, which has been grappling with various problems in its commercial, defense and space programs in recent years. It is also choking off a key source of cash as Boeing tries to overcome twin crises that resulted from two fatal crashes of its 737 MAX aircraft in late 2018 and early 2019, and the Covid-19 pandemic's hit to aircraft demand. The new problem hasn't raised any immediate safety concerns, but engineers at Boeing and the FAA are trying to understand the defect's potential to cause premature fatigue on a key part of the aircraft's structure, people familiar with the matter said.

Read more of this story at Slashdot.

Salvador Dali Scripting News(cached at July 18, 2021, 10:32 pm)

Portrait of Ruth Lachman, 1961.

[no title] Scripting News(cached at July 18, 2021, 10:32 pm)

If you have a Google phone they know every place you go.
Amazon's Elasticsearch Fork 'OpenSearch' Reaches General Availability 1.0 Milestone Slashdotby EditorDavid on opensource at January 1, 1970, 1:00 am (cached at July 18, 2021, 9:35 pm)

Mike Melanson's "This Week in Programming" column shares an update on Amazon's ongoing battle with scalable data search solution ElasticSearch: Earlier this year, AWS completed its fork of ElasticSearch with the first release of OpenSearch. If you haven't followed along, the whole affair was a bit of a tug of war between AWS and Elastic, with AWS eventually coming out seemingly on top. After Elastic changed the licensing on ElasticSearch in an attempt to prevent AWS from selling a service based on the then-open-source project, AWS forked the project to release OpenSearch under Apache 2.0, effectively preserving its open source status. Now, OpenSearch has reached 1.0, which AWS says not only "marks the first production-ready version of OpenSearch," but also introduces "multiple new enhancements," such as data streams, trace analytics span filtering, report scheduling and more. The 1.0 release also involved quite a bit of code cleanup, removing proprietary code and marks, and adds the ability to upgrade from ElasticSearch to OpenSearch as if you were performing a normal upgrade of ElasticSearch. If you're interested in learning where the project is going, head on over to the public roadmap to learn more.

Read more of this story at Slashdot.

Tahoe's Workforce is Disappearing, As Many Can No Longer Afford to Live There Slashdotby EditorDavid on government at January 1, 1970, 1:00 am (cached at July 18, 2021, 8:35 pm)

200 miles east of Silicon Valley, "A disproportionate number of people who purchased homes in Tahoe in 2020 are employees of some of the largest tech companies in the Bay Area," a real estate brokerage firm specializing in data analytics recently told Outside magazine. Of the 2,280 new-home buyers Atlasa identified throughout the Tahoe region in 2020, roughly 30 percent worked at software companies. The top three employers were Google (54 buyers), Apple (46), and Facebook (34)... There is, however, one glaring issue with all this rapid, high-priced growth: the people who actually make a mountain town run — the ski instructors and patrollers, lift operators and shuttle drivers, housekeepers and snowcat mechanics, cooks and servers — can no longer afford to live there. Just last year Sierra Sotheby's found more than 2,350 homes were sold across the Tahoe Basin, for a boggling $3.28 billion (up 86% from the $1.76 billion in 2019), according to the article, which calls the popular tele-working destination a "Zoom town." Now the region's heading into its summer tourist season — but "with a shorthanded workforce, businesses are unraveling," like the restaurant that simply closed for a week because "We literally do not have enough cooks to operate..." The evidence is showing up in the ways businesses are cutting back during the peak of the busiest time of year, a time when small business owners in Tahoe typically are trying to make as much money as possible so they can survive the slower times of year... While the hiring crisis spans far and wide across the nation, in Tahoe, the linchpin is housing. At Tahoe Dave's, Dave Wilderotter, the owner of Tahoe Dave's Skis and Boards, starts his employees at $20 an hour. Most of his employees make too much money to qualify for affordable housing. But they don't make enough money to pay Tahoe's rent prices, which have risen by 25% to 50% in the past year. Tahoe's workforce is disappearing because many of them cannot afford to live here any more... Making matters worse, Tahoe's already minimal long-term rental housing stock is getting eaten up by the very hot real estate market. Many landlords are selling homes they've been renting to local workers, leaving those tenants without many options... "This isn't just tourism that's being hit," says Alex Mourelatos, a business owner on Tahoe's North Shore who also serves on multiple boards for the North Tahoe Public Utility District and nonprofit groups. "It's every service industry. Every industry across people, dentistry, legal, everything, Planned Urban Developments, all the special districts, firemen, teachers, all of them." The hiring crisis has even affected critical services like public transportation. Bus drivers are so hard to come by that the Tahoe Transportation District made the unprecedented decision to shut down an entire bus route down the East Shore. The district had shuttles but no one to steer the wheel.

Read more of this story at Slashdot.

Reality check Scripting News(cached at July 18, 2021, 8:32 pm)

From the Washington Post via Political Wire:

[no title] Scripting News(cached at July 18, 2021, 8:02 pm)

When will I be able to set an alarm on my iPhone that wakes me up when there are five minutes left in the fourth quarter of the game I’m watching?
Scientists Find Evidence of Mile-high Tsunami Generated By Dino-killing Asteroid Slashdotby EditorDavid on science at January 1, 1970, 1:00 am (cached at July 18, 2021, 7:35 pm)

Slashdot reader sciencehabit shares news from Science magazine: When a giant space rock struck the waters near Mexico's Yucatán Peninsula 66 million years ago, it sent up a blanket of dust that blotted out the Sun for years, sending temperatures plummeting and killing off the dinosaurs. The impact also generated a tsunami in the Gulf of Mexico that some modelers believe sent an initial tidal wave up to 1500 meters (or nearly 1 mile) high crashing into North America, one that was followed by smaller pulses. Now, for the first time, scientists have discovered fossilized megaripples from this tsunami buried in sediments in what is now central Louisiana. "It's great to actually have evidence of something that has been theorized for a really long time," says Sean Gulick, a geophysicist at the University of Texas, Austin. Gulick was not involved in the work, but he co-led a campaign in 2016 to drill down to the remains of the impact crater, called Chicxulub... Cores from the 2016 drilling expedition helped explain how the impact crater was formed and charted the disappearance and recovery of Earth's life. In 2019, researchers reported the discovery of a fossil site in North Dakota, 3000 kilometers north of Chicxulub, that they say records the hours after the impact and includes debris swept inland from the tsunami. "We have small pieces of the puzzle that keep getting added in," says Alfio Alessandro Chiarenza, a paleontologist at the University of Vigo who was not involved with the new study. "Now this research is another one, giving more evidence of a cataclysmic tsunami that probably inundated [everything] for thousands of miles."

Read more of this story at Slashdot.

More Bitcoin Miners Head to America, Partly for Cheaper Energy Slashdotby EditorDavid on bitcoin at January 1, 1970, 1:00 am (cached at July 18, 2021, 6:35 pm)

"Well before China decided to kick out all of its bitcoin miners, they were already leaving in droves, and new data from Cambridge University shows they were likely headed to the United States," reports CNBC: The U.S. has fast become the new darling of the bitcoin mining world. It is the second-biggest mining destination on the planet, accounting for nearly 17% of all the world's bitcoin miners as of April 2021. That's a 151% increase from September 2020. "For the last 18 months, we've had a serious growth of mining infrastructure in the U.S.," said Darin Feinstein, founder of Blockcap and Core Scientific. "We've noticed a massive uptick in mining operations looking to relocate to North America, mostly in the U.S." This dataset doesn't include the mass mining exodus out of China, which led to half the world's miners dropping offline, and experts tell CNBC that the U.S. share of the mining market is likely even bigger than the numbers indicate... "500,000 formerly Chinese miner rigs are looking for homes in the U.S," said Marathon Digital's Fred Thiel. "If they are deployed, it would mean North America would have closer to 40% of global hashrate by the end of 2022." America's rising dominance is a simple case of luck meeting preparation. The U.S. has quietly been building up its hosting capacity for years... It also helps that the U.S. is also home to some of the cheapest sources of energy on the planet, many of which tend to be renewable. Because miners at scale compete in a low-margin industry, where their only variable cost is typically energy, they are incentivized to migrate to the world's cheapest sources of power. Thiel expects most new miners relocating to North America to be powered by renewables, or gas that is offset by renewable energy credits. While Castle Island Ventures founding partner, Nic Carter, points out that U.S. mining isn't wholly renewable, he does say that miners here are much better about selecting renewables and buying offsets. "The migration is definitely a net positive overall," he said. "Hashrate moving to the U.S., Canada, and Russia will mean much lower carbon intensity."

Read more of this story at Slashdot.

China Secretively Launches Reusable Suborbital Vehicle for Space Transportation Syst Slashdotby EditorDavid on space at January 1, 1970, 1:00 am (cached at July 18, 2021, 5:35 pm)

"China conducted a clandestine first test flight of a reusable suborbital vehicle Friday as a part of development of a reusable space transportation system," reports Space News: The vehicle launched from the Jiuquan Satellite Launch Center Friday and later landed at an airport just over 800 kilometers away at Alxa League in Inner Mongolia Autonomous Region, the China Aerospace Science and Technology Corp. (CASC) announced. No images nor footage nor further information, such as altitude, flight duration or propulsion systems, were provided. The CASC release stated however that the vehicle uses integrated aviation and space technologies and indicates a vertical takeoff and horizontal landing profile. The test follows a September 2020 test flight of a "reusable experimental spacecraft". The spacecraft orbited for days, releasing a small transmitting payload and later deorbited and landed horizontally. The spacecraft is widely believed to be a reusable spaceplane concept, though no images have emerged. Giant space and defense contractor CASC also developed that vehicle and stated that the new vehicle tested Friday can be used as a first stage of a reusable space transportation system. The implication is that the two vehicles will be combined for a fully reusable space transportation system. The developments have not come out of the blue. China stated in 2017 that it aimed to test a reusable spaceplane in 2020... Chen Hongbo, from CASC's China Academy of Launch Vehicle Technology (CALT), told Science and Technology Daily (Chinese) in 2017 that the reusable spacecraft would be capable of carrying both crew and payloads... Chen stated the aim was full reusability, moving beyond partial reusability of Falcon 9-like launchers. The spaceplane, the development and testing of which is to be completed by 2030, should be capable of being reused more than 20 times.

Read more of this story at Slashdot.

Fired Covid-19 Data Manager is Now Running for Congress Slashdotby EditorDavid on government at January 1, 1970, 1:00 am (cached at July 18, 2021, 2:35 pm)

Florida's fired Department of Health data manager Rebekah Jones lost access to her 400,000 followers on Twitter last month — which she'd been using to criticize Florida governor Ron DeSantis for downplaying the severity of the state's Covid-19 crisis. Then Jones announced she'd be running for Congress. "This also means, under Desantis' recently signed social media law, I get to fine Twitter $250K per day until my account is restored starting July 1." Orlando Weekly reports: After a media frenzy, Jones deleted the post. She said she was attempting to point out Gov. Ron DeSantis's "hypocrisy" in writing a law that allowed political candidates to sue media companies that ban them, while still celebrating her Twitter suspension... The bit became real when she filed to run as an Independent in Florida's 1st congressional district on June 25... On her campaign website, she lists eight issues on her platform: protecting Florida's environmental systems, promoting government transparency, fighting for media accountability in disinformation, giving access to representatives, ensuring the district's veterans are taken care of, scrutinizing restrictive voting laws, funding science and research, and boosting support for all levels of education. Jones says there's still room for other issues on her platform, after she talks to more residents. Jones' GoFundMe account ("DefendScience") now directs visitors to her official campaign site if they want to make campaign contributions. (And the GoFundMe page also notes that her campaign has been endorsed by 90-year-old Daniel Ellsberg, the famous whistleblower who in 1971 leaked the Pentagon Papers, a top-secret government study on the Vietnam War.) But the last six weeks have been a wild ride for the data scientist: Last month Florida's Inspector General granted official whistleblower status to Jones.Six days later Twitter told Slashdot they'd "permanently suspended" Jones' account "for violations of the Twitter Rules on spam and platform manipulation."When Jones then created a new Twitter account for her campaign, "it was suspended within a day of its creation," Orlando Weekly reports.Jones created a new account on Instagram named "insubordinatescientist". Yet since June 16th Instagram has also marked it as "unavailable," saying the link "may be broken, or the page may have been removed." (Since June 16th Instagram has not responded to Slashdot's request for an explanation.)Jones' GoFundMe page now refers visitors to an entirely different Instagram page. Yesterday the official coronavirus coordinator for the U.S. White House reported that one in five of America's Covid-19 cases this week have come from Florida.

Read more of this story at Slashdot.

What Ever Happened to IBM's Watson? Slashdotby EditorDavid on ibm at January 1, 1970, 1:00 am (cached at July 18, 2021, 10:35 am)

After Watson triumphed on the gameshow Jeopardy in 2011, its star scientist had to convince IBM that it wasn't a magic answer box, and "explained that Watson was engineered to identify word patterns and predict correct answers for the trivia game." The New York Times looks at what's happened in the decade since: Watson has not remade any industries. And it hasn't lifted IBM's fortunes. The company trails rivals that emerged as the leaders in cloud computing and A.I. — Amazon, Microsoft and Google. While the shares of those three have multiplied in value many times, IBM's stock price is down more than 10 percent since Watson's "Jeopardy!" triumph in 2011.... The company's missteps with Watson began with its early emphasis on big and difficult initiatives intended to generate both acclaim and sizable revenue for the company, according to many of the more than a dozen current and former IBM managers and scientists interviewed for this article... The company's top management, current and former IBM insiders noted, was dominated until recently by executives with backgrounds in services and sales rather than technology product experts. Product people, they say, might have better understood that Watson had been custom-built for a quiz show, a powerful but limited technology... IBM insists that its revised A.I. strategy — a pared-down, less world-changing ambition — is working... But the grand visions of the past are gone. Today, instead of being a shorthand for technological prowess, Watson stands out as a sobering example of the pitfalls of technological hype and hubris around A.I. The march of artificial intelligence through the mainstream economy, it turns out, will be more step-by-step evolution than cataclysmic revolution. One example: IBM technologists approached cancer medical centers, but "were frustrated by the complexity, messiness and gaps in the genetic data at the cancer center... At the end of last year, IBM discontinued Watson for Genomics, which grew out of the joint research with the University of North Carolina. It also shelved another cancer offering, Watson for Oncology, developed with another early collaborator, the Memorial Sloan Kettering Cancer Center..." IBM continued to invest in the health industry, including billions on Watson Health, which was created as a separate business in 2015. That includes more than $4 billion to acquire companies with medical data, billing records and diagnostic images on hundreds of millions of patients. Much of that money, it seems clear, they are never going to get back. Now IBM is paring back Watson Health and reviewing the future of the business. One option being explored, according to a report in The Wall Street Journal, is to sell off Watson Health... Many outside researchers long dismissed Watson as mainly a branding campaign. But recently, some of them say, the technology has made major strides... The business side of Watson also shows signs of life. Now, Watson is a collection of software tools that companies use to build A.I.-based applications — ones that mainly streamline and automate basic tasks in areas like accounting, payments, technology operations, marketing and customer service. It is workhorse artificial intelligence, and that is true of most A.I. in business today. A core Watson capability is natural language processing — the same ability that helped power the "Jeopardy!" win. That technology powers IBM's popular Watson Assistant, used by businesses to automate customer service inquiries... IBM says it has 40,000 Watson customers across 20 industries worldwide, more than double the number four years ago. Watson products and services are being used 140 million times a month, compared with a monthly rate of about 10 million two years ago, IBM says. Some of the big customers are in health, like Anthem, a large insurer, which uses Watson Assistant to automate customer inquiries. "Adoption is accelerating," Mr. Thomas said.

Read more of this story at Slashdot.