A Spreadsheet For The Python Hacker

You can write a Python program or use a Jupyter Notebook to do almost anything. But you can also get a lot of things done quickly using a spreadsheet. Grist is a “hacker’s” spreadsheet that merges these worlds. It looks like a spreadsheet, but underneath are SQLite tables and the formula language is Python.

The code is open source and if you want it hosted, there are free and paid plans. You can even try it out without even logging in and either start with a blank screen or use a template. You can see an introductory video below.

Continue reading “A Spreadsheet For The Python Hacker”

For The ESP’s Next ESP Trick…

It is a pretty stale dad joke to tell someone you have ESP when you mean you have an ESP8266 or ESP32 in your hand. However, [Naufil Metkar] uses an ESP device to pretend — via a magic trick — that he does have ESP. The trick requires a bit of 3D printing, an MPU6050 gyro sensor, and a lot of showmanship.

We hate to spoil an illusion, but you can probably figure it out from the list of things you need. The die has a gyro in it and uses a small ESP module to transmit its current orientation out to a display. There is a small reed switch that lets you turn off the device with a magnet. Without it, the battery dies quickly.

Continue reading “For The ESP’s Next ESP Trick…”

Nazi Weapons Of The Future

We know. The title sounds like a bad newsreel from 1942. Turns out, though, that the Nazis were really good at pouring money into military research and developing — or trying to develop — what they called “wunderwaffe” — wonder weapons. While we think of rockets and jets today as reasonably commonplace, they were state-of-the-art when Germany deployed them during WWII. While the rockets were reasonably successful, the jets were too few and too late to matter. However, those were just the tip of the iceberg. The German war industry had plenty of plans ranging from giant construction to secret weapons that seem to be out of the pages of a pulp science fiction magazine.

Size Matters

Part of the plans included huge ships including one aircraft carrier displacing 56,500 tons. Many of these were never completed and, in some cases, were never actually started. In contrast, the Essex-class USS Hornet displaces 31,300 tons and the Lexington was 37,000 tons. The H-class battleships would have had as much as 140,000 tons of displacement dwarfing the Yamato class (73,000 tons) and the Iowa class (53,000 tons).

Continue reading “Nazi Weapons Of The Future”

Exploring Texas Instrument’s Forgotten CPU

Texas Instruments isn’t the name you usually hear associated with the first microprocessor. But the TI TMX 1795 was an 8008 chip produced months before the 8008. It was never available commercially, though, so it has been largely forgotten by most people. But not [Ken Shirriff]. You can see a demo from 2015 of the device in the video below, too.

The reason the chips have the same architecture is they were built to replace the same large circuit board inside a Datapoint 2200 programmable terminal. These were big beasts that could be programmed in BASIC or PL/B.

Datapoint asked Intel to shrink the board to a chip due to heating problems — but after delays, they instead replaced the power supply and lost interest in the device. TI heard about the affair and wanted in on the deal. However, Datapoint was unimpressed. The chip didn’t tolerate voltage fluctuations very well, since they had replaced the power supply and had a new CPU design that was faster than the chip would be. They were also unimpressed with how much stuff you had to add to get a complete system.

So why did the Intel 8008 work out in the marketplace but the TI chip didn’t? After all, Datapoint decided not to use the 8008, also. But as [Ken] points out, the 8008 was much smaller than the TI chip and, thus, was more cost-effective to produce.

As usual, [Ken]’s posts are always interesting and enlightening. He’s looked at a lot of old computers. He’s even dug into old space hardware. Great stuff!

Continue reading “Exploring Texas Instrument’s Forgotten CPU”

OpenAI Hears You Whisper

Should you wish to try high-quality voice recognition without buying something, good luck. Sure, you can borrow the speech recognition on your phone or coerce some virtual assistants on a Raspberry Pi to handle the processing for you, but those aren’t good for major work that you don’t want to be tied to some closed-source solution. OpenAI has introduced Whisper, which they claim is an open source neural net that “approaches human level robustness and accuracy on English speech recognition.” It appears to work on at least some other languages, too.

If you try the demonstrations, you’ll see that talking fast or with a lovely accent doesn’t seem to affect the results. The post mentions it was trained on 680,000 hours of supervised data. If you were to talk that much to an AI, it would take you 77 years without sleep!

Continue reading “OpenAI Hears You Whisper”

Better Scope Measurements

There was a time when few hobbyists had an oscilloscope and the ones you did see were old military or industrial surplus that were past their prime. Today you can buy a fancy scope for about what those used scopes cost that would have once been the envy of every giant research lab. However, this new breed of instrument is typically digital and while they look like an old analog scope, the way they work leads to some odd gotchas that [Arthur Pini] covers in a recent post.

Some of his tips are common sense, but easy to forget about. For example, if you stack your four input channels so each uses up a quarter of the screen, it makes sense, right? But [Arthur] points out that you are dropping two bits of dynamic range, which can really jack up a sensitive measurement.

Continue reading “Better Scope Measurements”

A Love Letter To Small Design Teams, And The B-52

The true measure of engineering success — or, at least, one of them — is how long something remains in use. A TV set someone designed in 1980 is probably, at best, relegated to a dusty guest room today if not the landfill. But the B-52 — America’s iconic bomber — has been around for more than 70 years and will likely keep flying for another 30 years or more. Think about that. A plane that first flew in 1952 is still in active use. What’s more, according to a love letter to the plane by [Alex Hollings], it was designed over a weekend in a hotel room by a small group of people.

A Successful Design

One of the keys to the plane’s longevity is its flexibility. Just as musicians have to reinvent themselves if they want to have a career spanning decades, what you wanted a bomber to do in the 1960s is different than what you want it to do today. Oddly enough, other newer bombers like the B-1B and B-2 have already been retired while the B-52 keeps on flying.

Continue reading “A Love Letter To Small Design Teams, And The B-52”