Scratching Out Business Intelligence

August 9, 2022 by Matthew Carlson 9 Comments

At Hackaday, we love things both from scratch and in Scratch, Scratch being the blocks building helpful language for teaching kids and the like how to program. However, when you have a large amount of data that needs to be processed, queried, and collated to get meaningful insights, it is a pain to rewrite a SQL query every time a new question arises that needs an answer. So perhaps a more elegant approach would be to give the people asking the questions the tools to answer them, but rather than teach them SQL, Mongo, GraphQL, or any other database, give them the tools to scratch out the answers themselves.

That’s enough scratch puns for one article. [Tommy] ran into this situation in 2011 and recently wrote about it. Scratch came out in 2003 and has inspired several projects, such as Google’s Blockly. [Tommy] used Blockly to create a web app where users could drag and drop different blocks to form queries. These layouts were passed to a PHP-backed (though later HVVM for performance reasons) and executed as SQL.

Eventually, big data came around, and the company hired proper data scientists. Though [Tommy] notes that some of those who used his tool went on to learn proper SQL and do it themselves. Applying concepts from programs designed to teach children programming might sound a little odd in a business sense, but we love seeing projects that help someone become curious enough to peer inside the machine.

An opened plastic project box with electronics inside

Smoking Meat Finds Natural Home In The Cloud

August 9, 2022 by Chris Wilkinson 15 Comments

Did you know that backyard barbecues now come with WiFi? It should be no surprise, given the pervasiveness of cloud-enabled appliances throughout the home. However [Carl] wasn’t ready to part with his reliable but oh-so-analog BBQ smoker, so instead he created an affordable WiFi-based temperature monitor that rivals its commercial counterparts.

Accurate temperature measurement is essential to smoking meat from both a taste and safety standpoint. In this project, two Maverick ET-732/733 thermistor probes take care of the actual temperature monitoring. One probe is skewered into meat itself, and the other measures the ambient ‘pit’ temperature. Combined, these two gauges ensure that the meat is smoked for exactly the right length of time. [Carl] mentions that adding an extra temperature sensor is trivial for larger setups, but he’s getting by just fine with two data points.

Naturally an ESP8266 does most of the heavy lifting in bridging the gap between smoke and cloud. At the core of this project is utility and practicality – temperature statistics can be viewed on any device with a web browser. Being able to study the temperature trends in this way also makes it easier to predict cooking times. Electronic alerts are also used to notify the chef if the temperature is too hot or cold (among other things). The entire contraption is housed in a smart looking project box that contains an LCD and rotary encoder for configuration.

If this has piqued your culinary interest, check out the extensive documentation recipe over on GitHub and the project Wiki. We also recommend checking out this project that takes automated meat smoking to the next level.

Student Competition Badge Bears Custom Silicon

August 9, 2022 by Arya Voronova 5 Comments

[Daniel Valuch] shared a fun and record-setting conference badge story (Slovak, translated) with us. He was one of the organizers for the “ZENIT in electronics” event, which is an annual Slovak national competition for students. During the competition, students are assigned a letter+number code for the purpose of result submission anonymity, and organizers are always on the lookout for a fun way to assign these codes – this time, they did it with custom silicon!

It just so happened that [Peter], one of [Daniel]’s colleagues, was at the time working for onsemi who were doing a tapeout and had some free space on their test chips. Of course, they didn’t have to think twice. When it was a student’s turn to draw their identification number, instead of a slip of paper, they received a SOIC-16 package with custom silicon bonded to it. Then, they had to solder it to their competition badge – which was, of course, a PCB. Each chip was individually laser-trimmed to contain the student’s number, and that number could then be decoded using a multimeter – or a reasonably sharp eye.

There’s way more to this competition story than just the badge, but the custom silicon part of it sure caught our eyes. Who knows, maybe next year stars will align again and we’ll see custom silicon on one of the hacker conference badges. After all, things have been advancing rapidly on that front – for instance, since Skywater PDK project’s inception in 2020, there’s been several successful runs already, and if you’d like to learn more, you could check the HackChat we’ve had this year, and this Remoticon 2020 workshop!

Up Your Desk Toy Game With This 3D Printed Escalator

August 9, 2022 by Tom Nardi 21 Comments

Let’s be real, nobody needs a tiny motorized escalator for their desk. But now that you’ve seen it, can you really say you don’t want one of your own? The design comes our way from [AlexY], and is actually the logical evolution of a manually-operated version released previously. But for our money (and 3D printing time), we’d definitely go with this new motorized variant.

While the core mechanism is largely the same, the powered unit uses a N20 geared motor and an 18650 cell. There’s no fancy motor controller here — just flip the switch and you’ve got 30 RPMs worth of stair-steppin’ action. When you’ve run the cell down, and you will, there’s an onboard TP4056 charging module to keep the good times rolling.

[AlexY] hasn’t had a chance to document the build process for the motorized version of the escalator, but as most of the parts are compatible with the manual version, you should be able to figure it out by referencing the earlier assembly guide.

Hot squirted plastic not your thing? We’ve previously seen a wooden escalator designed to keep a Slinky in motion for as long as it takes for you to realize you could be using your skills for something more constructive.

Continue reading “Up Your Desk Toy Game With This 3D Printed Escalator” →

2022 Hackaday Prize: Congratulations To The Winners Of The Hack It Back Challenge

August 9, 2022 by Elliot Williams 7 Comments

Wow! We knew that the Hack it Back Challenge round of the Hackaday Prize would bring out the clever repairers among you, but we’re still impressed to see the results! This was a tough round for the judges, but they came up with a short list of ten finalists, and we’re pleased to bring them to you here.

The Hack it Back Challenge aimed to keep old gear from being thrown away by performing a heroic repair, giving it a new purpose in life, or otherwise bringing it back to a useful state. Of course, once you’ve got the box open, you start thinking of how to improve whatever the gadget is, and some of our finalists took that in unexpected directions. Continue reading “2022 Hackaday Prize: Congratulations To The Winners Of The Hack It Back Challenge” →

Mapping Out The LEDs On An Outlet Tester

August 9, 2022 by Tom Nardi 13 Comments

The concept of an outlet tester is pretty simple: plug the gadget into a suspect wall receptacle, and an array of LEDs light up in various patterns to alert the user to any wiring faults. They’re cheap, reliable, and instantaneous. Most people wouldn’t give them much more thought than that, but like any good hacker, [Yeo Kheng Meng] wanted to know how these devices worked.

After picking up a relatively advanced model that featured an LCD display capable of showing various stats such as detected voltage in addition to the standard trio of LEDs, he started by using some test leads to simulate various fault conditions to understand the basic principle behind its operation. The next step was to disassemble the unit, which is where things went briefly sideways — it wasn’t until [Yeo Kheng Meng] and a friend had nearly cut through the enclosure that they realized it wasn’t ultrasonically welded liked they assumed, and that the screws holding it together were actually hidden under a sticker. Oops.

The write-up includes some excellent PCB shots, and [Yeo Kheng Meng] was able to identify several components and ascertain their function. He was even able to find some datasheets, which isn’t always such an easy task with these low-cost devices. Unfortunately the MCU that controls the device’s more advanced features is locked away with a black epoxy blob, but he was able to come up with a schematic that explains the rather elegant logic behind the LED display.

This isn’t the first time [Yeo Kheng Meng] has taken apart an interesting piece of hardware for our viewing pleasure, and given the fine job he does of it, we hope it’s not the last either.

AI Creates Your Spreadsheets, Sometimes

August 9, 2022 by Al Williams 9 Comments

We’ve been interested in looking at how AI can process things other than silly images. That’s why the “Free AI Bot that Generates the Excel Formula for Any Problem” caught our eye. Based on GPT-3, it supposedly transforms your problem description into a formula suitable for Excel or Google Sheets.

Our first prompt didn’t work out very well. But that was sort of our fault. When they say “Excel formula” they mean that quite literally. So trying to describe the actual result you want in terms of columns or rows seems to be beyond it. Not realizing that, we asked:

If the sum of column H is greater than 50, multiply column A by 0.33

And got:

=IF(SUM(H:H)>50,A*0.33,0)

A Better Try

Which is close, but not really how anyone even mildly proficient with Excel would interpret that request. But that’s not fair. It really needs to be a y=f(x) sort of problem, we suppose.

Continue reading “AI Creates Your Spreadsheets, Sometimes” →