SQLite or PostgreSQL? It's Complicated!

Miguel Grinberg, a Principal Software Engineer for Technical Content at Twilio, writes in a blog post: We take blogging very seriously at Twilio. To help us understand what content works well and what doesn’t on our blog, we have a dashboard that combines the metadata that we maintain for each article such as author, team, product, publication date, etc., with traffic information from Google Analytics. Users can interactively request charts and tables while filtering and grouping the data in many different ways. I chose SQLite for the database that supports this dashboard, which in early 2021 when I built this system, seemed like a perfect choice for what I thought would be a small, niche application that my teammates and I can use to improve our blogging. But almost a year and a half later, this application tracks daily traffic for close to 8000 articles across the Twilio and SendGrid blogs, with about 6.5 million individual daily traffic records, and with a user base that grew to over 200 employees.

At some point I realized that some queries were taking a few seconds to produce results, so I started to wonder if a more robust database such as PostgreSQL would provide better performance. Having publicly professed my dislike of performance benchmarks, I resisted the urge to look up any comparisons online, and instead embarked on a series of experiments to accurately measure the performance of these two databases for the specific use cases of this application. What follows is a detailed account of my effort, the results of my testing (including a surprising twist!), and my analysis and final decision, which ended up being more involved than I expected. […] If you are going to take one thing away from this article, I hope it is that the only benchmarks that are valuable are those that run on your own platform, with your own stack, with your own data, and with your own software. And even then, you may need to add custom optimizations to get the best performance.

Read more of this story at Slashdot.



Source: Slashdot – SQLite or PostgreSQL? It’s Complicated!

Turns Out Luke Skywalker's Jedi Academy Was Built on a Very Familiar Planet

The more we get to learn about the future of the Force in a post Return of the Jedi, post Rise of Skywalker era for Star Wars, the more we’re getting echoes of its long past—and thanks to the latest novel from the galaxy far, far away, Luke’s attempts to rebuild the Jedi Order have even more connection’s to the…

Read more…



Source: Gizmodo – Turns Out Luke Skywalker’s Jedi Academy Was Built on a Very Familiar Planet

Essential System Tools: gWakeOnLAN – turn machines on through Wake On LAN

gWakeOnLAN is a small graphical utility that lets you wake up machines using the Wake on LAN (WOL) feature. WOL lets you wake a computer from a low-power state when a network adapter detects a WOL event. Typically, such an event is a specially constructed Ethernet packet, often known as a “magic packet”. When the packet is received, the target machine’s network device (Network Interface Controller or NIC) wakes up the rest of the machine.

Source: LXer – Essential System Tools: gWakeOnLAN – turn machines on through Wake On LAN

Government Policies Will Not Get UK To Net Zero, Warns Damning Report

The government is failing to enact the policies needed to reach the UK’s net zero targets, its statutory advisers have said, in a damning progress report to parliament. From a report: The Climate Change Committee (CCC) voiced fears that ministers may renege on the legally binding commitment to achieve net zero greenhouse gas emissions by 2050, noting “major policy failures” and “scant evidence of delivery.” Lord Deben, the chair of the committee and a former Conservative environment secretary, said the government had set strong targets on cutting emissions but policy to achieve them was lacking. “The government has willed the ends, but not the means,” he said. “This report showed that present plans will not fulfil the commitments [to net zero].”

He said net zero policies were also the best way to reduce the soaring cost of living. Average household bills would be about $151.3 lower today if previous plans on green energy and energy efficiency had been followed through. “If you want to deal with the cost of living crisis, this is exactly what you need to do,” he said. The greatest failure was the insulation policy. Britain’s homes are the draughtiest in western Europe, heating costs are crippling household budgets, and heating is one of the biggest single sources of carbon emissions, but the government has no plans to help most people insulate their homes.

Read more of this story at Slashdot.



Source: Slashdot – Government Policies Will Not Get UK To Net Zero, Warns Damning Report

F1 2022 Is Out With Beautiful Ray-Traced Cars And The Same Sweet Benchmark Mode

F1 2022 Is Out With Beautiful Ray-Traced Cars And The Same Sweet Benchmark Mode
If you’re not a hardcore racing fan, you may not have been aware that this year’s F1 cars have seen significant redesigns to comply with the latest regulations for the racing class. Indeed, every team’s cars look and perform quite differently this year, and that means big changes for Codemasters’ latest entry in its aptly-named simulation

Source: Hot Hardware – F1 2022 Is Out With Beautiful Ray-Traced Cars And The Same Sweet Benchmark Mode

Crosby, Stills and Nash return to Spotify after COVID-19 misinformation boycott

The music of Crosby, Stills and Nash is once again available to stream on Spotify. In February, the supergroup left the platform to protest Spotify’s inaction against Joe Rogan, who was accused of spreading COVID-19 misinformation through his podcast. According to Billboard, the trio plan to donate their Spotify earnings to COVID-19 charities for “at least a month.”

Crosby, Stills and Nash were among a handful of musicians who left Spotify in response to Rogan’s interview with vaccine skeptic Dr. Robert Malone. The exodus, such that it was, began with Neil Young and later came to include Joni Mitchell, as well as author Brené Brown.

In the end, Spotify did not drop Rogan. Instead, the company said it would add a content advisory to any episode that includes a discussion about COVID-19. The protest’s effect on Spotify’s bottom line appears to have been minimal, with the company recently reporting that it grew to 422 million monthly users.

Despite the return of Crosby, Stills and Nash to Spotify, don’t expect to see all of the music the trio helped created on the platform. As The Verge point outs, Young’s continued absence from the service means not every song from Crosby, Stills, Nash and Young is available. For instance, tracks like “Helpless” and “Country Girl” are missing from the band’s 1970 album Déjà Vu, 



Source: Engadget – Crosby, Stills and Nash return to Spotify after COVID-19 misinformation boycott

The Amazing Spider-Man Got There, In the End

It isn’t just Transformers that’s celebrating a milestone this holiday weekend. Back in 2012, Sony returned to Marvel Comics’ most popular hero with The Amazing Spider-Man, a reboot completely separate from the original Sam Raimi trilogy, for better and for worse. And ten years later, the two-film franchise (well,

Read more…



Source: Gizmodo – The Amazing Spider-Man Got There, In the End

Gartner Predicts 9.5% Drop in PC Shipments

The party is over for PC makers as figures from Gartner suggest the market is on course for a breathtaking decline this year. From a report: According to the analysts, worldwide PC shipments will decline by 9.5 percent, with consumer demand leading the way — a 13.5 percent drop is forecast, far greater than business PC demand, which is expected to drop by 7.2 percent year on year. The PC market in the EMEA region is forecast to fare even worse, with a 14 percent decline on the cards for 2022. Gartner pointed the finger of blame at uncertainty caused by conflicts, price increases and simple unavailability of products. Lockdowns in China were also blamed for an impact in consumer demand. It all makes for grim reading from a channel perspective. While worldwide PC shipments fared the worst, tablet devices are forecast to fall by 9 percent and mobile phones by 7.1 percent. Overall, the total decline over all types of devices in the report is expected to be 7.6 percent. This is in stark contrast to a 11 percent increase year on year in the shipment of PCs in 2021 and 5 per cent for mobile phones.

Read more of this story at Slashdot.



Source: Slashdot – Gartner Predicts 9.5% Drop in PC Shipments

A Game So Good It Could Have Been Hexen III

In the mood for a retro-style FPS, I dug around the new releases on Steam, and poked at a few, not really clicking. Until, that is, I found Hands Of Necromancy, and then played it all weekend. This is a Hexen-like FPS, with enormous, sprawling maps, a whole bunch of weapons, an array of enemy types, and some fresh…

Read more…



Source: Kotaku – A Game So Good It Could Have Been Hexen III

NASA's CAPSTONE satellite breaks from Earth's orbit and heads toward the Moon

NASA’s grand plan to take humans back to the Moon for the first time in over half a century has taken another step forward. The 55-pound CAPSTONE (Cislunar Autonomous Positioning System Technology Operations and Navigation Experiment) cubesat has broken free of Earth’s orbit and is on its way to the Moon.

Rocket Lab launched CAPSTONE on an Electron rocket from New Zealand last week. Following six days of orbit-raising burns to build up enough speed, the pathfinding satellite set out toward the Moon. It’s a relatively slow trip, though. CAPSTONE won’t reach the Moon until November.

NASA will try to put CAPSTONE in a Near Rectilinear Halo Orbit around the Moon, a feat that’s never been attempted before. The agency plans to use the same orbit for the Gateway space station, which will provide support for long-term lunar missions under the Artemis program. The outpost will have living quarters for astronauts and a lab. That mission won’t launch until at least 2024.

Meanwhile, it emerged last week that NASA has targeted a launch window of between August 23rd and September 6th for the Artemis 1 mission. It will send an uncrewed module around the Moon to assess how the journey might affect the human body. The agency ran a successful wet launch fueling test for Artemis 1 in June.



Source: Engadget – NASA’s CAPSTONE satellite breaks from Earth’s orbit and heads toward the Moon

The Really Important Job Interview Questions Engineers Should Ask (But Don't)

James Hawkins: Since we started PostHog, our team has interviewed 725 people. What’s one thing I’ve taken from this? It’s normal for candidates not to ask harder questions about our company, so they usually miss out on a chance to (i) de-risk our company’s performance and (ii) to increase the chances they’ll like working here.

Does the company have product-market fit? This is the single most important thing a company can do to survive and grow.
“Do you ever question if you have product-market fit?”
“When did you reach product-market fit? How did you know?”
“What do you need to do to get to product-market fit?”
“What’s your revenue? What was it a year ago?”
“How many daily active users do you have?”

It’s ok if these answers show you the founder doesn’t have product market fit. In this case, figure out if they will get to a yes. Unless you want to join a sinking ship, of course! Early stage founders are (or should be) super-mega-extra-desperately keen to have product-market fit — it’s all that really matters. The ones that will succeed are those that are honest about this (or those that have it already) and are prioritizing it. Many will think or say (intentionally or through self-delusion) that they have it when they don’t. Low user or revenue numbers and vague answers to the example questions above are a sign that it isn’t there. Product-market fit is very obvious.

Read more of this story at Slashdot.



Source: Slashdot – The Really Important Job Interview Questions Engineers Should Ask (But Don’t)

AMD Rembrandt SoC Support For Coreboot In Place – Based Off Existing "Sabrina" Code

Today’s Coreboot code now has AMD Rembrandt SoC support by splitting it out from the Sabrina SoC support that has been in the works the past several months for this open-source firmware project…

Source: Phoronix – AMD Rembrandt SoC Support For Coreboot In Place – Based Off Existing “Sabrina” Code

World's First RISC-V Laptop Touts A Mysterious Quad-Core CPU And You Can Preorder It Now

World's First RISC-V Laptop Touts A Mysterious Quad-Core CPU And You Can Preorder It Now
Loyal HotHardware reader, you know all about RISC-V, right? Well, just in case, a brief refresher: RISC-V is an instruction set architecture like ARM or x86, but unlike those, it’s completely free and open-source. That means anyone can make their own RISC-V CPU if they have the resouces to do so.

The last bit there is part of what makes

Source: Hot Hardware – World’s First RISC-V Laptop Touts A Mysterious Quad-Core CPU And You Can Preorder It Now

Thor: Love and Thunder's Soundtrack Sounds Suitably Over the Top

Taika Waititi has made it his goal with his Thor movies to Do The Most Possible with his take on the God of Thunder, in a way few other Marvel movies do with their own heroes. Love and Thunder appears to be following on from Ragnarok in fine form in this regard, with both its Thors—and if this taste of the soundtrack…

Read more…



Source: Gizmodo – Thor: Love and Thunder’s Soundtrack Sounds Suitably Over the Top

10 More Fascinating Indie Games To Wishlist Today

As previously established, today is the day all gaming websites that don’t hate their readers, their country, their God, post as much as they can about unknown indie games in penance for all that triple-A blah that occupies our lives. So read on for another 10 games you’ve never heard of before, but will be so glad…

Read more…



Source: Kotaku – 10 More Fascinating Indie Games To Wishlist Today

When Ubisoft Is Shutting Down Servers For These 15 Games

When Ubisoft Is Shutting Down Servers For These 15 Games
The online services for more and more games are being shuttered due to decreased engagement and the costs associated to maintain the server hardware and software.

Ubisoft has announced its latest list of games and their associated platforms for which online services will no longer be available. There are, of course, some caveats and peculiar

Source: Hot Hardware – When Ubisoft Is Shutting Down Servers For These 15 Games

Webb Telescope Will Look for Signs of Life Way Out There

This month will mark a new chapter in the search for extraterrestrial life, when the most powerful space telescope yet built will start spying on planets that orbit other stars. Astronomers hope that the James Webb Space Telescope will reveal whether some of those planets harbor atmospheres that might support life. New York Times: Identifying an atmosphere in another solar system would be remarkable enough. But there is even a chance — albeit tiny — that one of these atmospheres will offer what is known as a biosignature: a signal of life itself. “I think we will be able to find planets that we think are interesting — you know, good possibilities for life,” said Megan Mansfield, an astronomer at the University of Arizona. “But we won’t necessarily be able to just identify life immediately.”

So far, Earth remains the only planet in the universe where life is known to exist. Scientists have been sending probes to Mars for almost 60 years and have not yet found Martians. But it is conceivable that life is hiding under the surface of the Red Planet or waiting to be discovered on a moon of Jupiter or Saturn. Some scientists have held out hope that even Venus, despite its scorching atmosphere of sulfur dioxide clouds, might be home to Venusians. Even if Earth turns out to be the only planet harboring life in our own solar system, many other solar systems in the universe hold so-called exoplanets. In 1995, Swiss astronomers spotted the first exoplanet orbiting a sunlike star. Known as 51 Pegasi b, the exoplanet turned out to be an unpromising home for life — a puffy gas giant bigger than Jupiter, and a toasty 1,800 degrees Fahrenheit. In the years since, scientists have found more than 5,000 other exoplanets. Some of them are far more similar to Earth — roughly the same size, made of rock rather than gas and orbiting in a “Goldilocks zone” around their star, not so close as to get cooked but not so far as to be frozen.

Read more of this story at Slashdot.



Source: Slashdot – Webb Telescope Will Look for Signs of Life Way Out There