Free Cloud Data Logging Courtesy Of Google

Pushing all of your data into “The Cloud” sounds great, until you remember that what you’re really talking about is somebody else’s computer. That means all your hard-crunched data could potentially become inaccessible should the company running the service go under or change the rules on you; a situation we’ve unfortunately already seen play out.

Which makes this project from [Zoltan Doczi] and [Róbert Szalóki] so appealing. Not only does it show how easy it can be to shuffle your data through the tubes and off to that big data center in the sky, but they send it to one of the few companies that seem incapable of losing market share: Google. But fear not, this isn’t some experimental sensor API that the Big G will decide it’s shutting down next Tuesday in favor of a nearly identical service with a different name. All your precious bits and bytes will be stored in one of Google’s flagship products: Sheets.

It turns out that Sheets has a “Deploy as Web App” function that will spit out a custom URL that clients can use to access the spreadsheet data. This project shows how that feature can be exploited with the help of a little Python code to push data directly into Google’s servers from the Raspberry Pi or other suitably diminutive computer.

Here they’re using a temperature and humidity sensor, but the only limitation is your imagination. As an added bonus, the chart and graph functions in Sheets can be used to make high-quality visualizations of your recorded data at no extra charge.

You might be wondering what would happen if a bunch of hackers all over the world started pushing data into Sheets every few seconds. Honestly, we don’t know. The last time we showed how you could interact with one of their services in unexpected ways, Google announced they were retiring it on the very same day. It was probably just a coincidence, but to be on the safe side, we’d recommend keeping the update frequency fairly low.

Back in 2012, before the service was even known as Google Sheets, we covered how you could do something very similar by manually assembling HTTP packets containing your data. We’d say this validates the concept for long-term data storage, but clearly the methodology has changed considerably in the intervening years. Somebody else’s computer, indeed.

Lock Your Keys In The Car On Purpose With Aluminum Foil

[TJ] is a surfer, and drives his car to get to the beach. But when he gets there he’s faced with a dilemma that most surfers have: either put his key in your baggies (shorts) or wetsuit and hope it doesn’t get lost during a wipeout, or stash it on the rear wheel of his car. Hiding the keyfob by the car isn’t an option because it can open the car doors just by being in proximity to the car. He didn’t want to risk losing it to the ocean either, so he built a waveguide of sorts for his key out of aluminum foil that lets him lock the key in the car without locking himself out.

Over a series of trials, [TJ] found out that his car, a 2017 Chevy Cruze, has a series of sensors in it which can determine the location of the keyfob based on triangulation. If it thinks the keyfob is outside of the car, it allows the door to be locked or unlocked with a button on the door handle. If the keyfob is inside the car, though, it prevents the car from locking via the door handles so you don’t accidentally lock yourself out. He found out that he could “focus” the signals of the specific sensors that make the car think the keyfob is outside by building an open Faraday cage.

The only problem now is that while the doors can be locked, they could also can be unlocked. To solve that problem he rigged up an ESP32 to a servo to open and close the opening in the Faraday cage. This still means there’s a hidden device used to activate the ESP32, but odds are that it’s a cheaper device to replace than a modern car key and improves security “through obscurity“. If you have any ideas for improving [TJ]’s build, though, leave them in the comments below. Surfers across the world from [TJ] to the author would be appreciative.

ESP8266 And Sensors Make For A Brainy NERF Ball

For his final project in UCLA’s Physics 4AL program, [Timothy Kanarsky] used a NodeMCU to smarten up a carefully dissected NERF football. With the addition to dual MPU6050 digital accelerometers and some math, the ball can calculate things like the distance traveled and angular velocity. With a 9 V alkaline battery and a voltage regulator board along for the ride it seems like a lot of weight to toss around; but of course nobody on the Hackaday payroll has thrown a ball in quite some time, so we’re probably not the best judge of such things.

Even if you’re not particularly interested in refining your throw, there’s a lot of fascinating science going on in this project; complete with fancy-looking equations to make you remember just how poorly you did back in math class.

As [Timothy] explains in the write-up, the math used to find velocity and distance traveled with just two accelerometers is not unlike the sort of dead-reckoning used in intercontinental ballistic missiles (ICBMs). Since we’ve already seen model rockets with their own silos, seems all the pieces are falling into place.

The NodeMCU polls the accelerometers every 5 milliseconds, and displays the data on web page complete with scrolling graphs of acceleration and angular velocity. When the button on the rear of the ball is pressed, the data is instead saved to basic Comma Separated Values (CSV) file that’s served up to clients with a minimal FTP server. We might not know much about sportsball, but we definitely like the idea of a file server we can throw at people.

Interestingly, this isn’t the first time we’ve seen an instrumented football. Back in 2011 it took some pretty elaborate hardware to pull this sort of thing off, and it’s fascinating to see how far the state-of-the-art has progressed.

Home Safety Monitoring With IoT

Home automation is a popular project to undertake but its complexity can quickly become daunting, especially if you go further than controlling a few lights (or if you’re a renter). To test the waters you may want to start with something like this home safety monitor, which is an IoT device based on an Arduino. It allows remote monitoring of a home for things such as temperature, toxic gasses, light, and other variables, which is valuable even if you don’t need or want to control anything.

The device is built around an Arduino Nano 33 IOT which has WiFi and Bluetooth capabilities as well as some integrated security features. This build features a number of sensors including pressure/humidity, a gas/smoke detector, and a light sensor. To report all of the information it gathers around the home, an interface with Ubidots is configured to allow easy (and secure) access to the data gathered by the device.

The PCB and code for the project are all provided on the project page, and there are a number of other options available if Ubidots isn’t your preferred method of interfacing with the Internet of Things. You might even give Mozilla’s WebThings a shot if you’re so inclined.

A Slightly Bent ESP8266 Sensor Platform

The ability to get professionally manufactured PCBs, at least small ones, for dirt cheap has had a huge impact on the sort of projects we see around these parts. It’s getting to the point where experimenting with PCB enclosures is not only a way to make your next project stand out, but an economical choice.

Which is how this ESP8266 sensor gadget from [Josef Adamčík] got its unique “folded over” look. The top panel is where the microcontroller and headers for various sensors live, the bottom panel is home to the TP4056 USB charging module, and the center panel provides mechanical support as well as holds the single 18650 cell. Rather than close the whole thing up with a fourth panel, he decided to leave it open so the battery can easily be removed. Plus, of course, it looks cooler this way.

Could [Josef] have fit all his electronics on a single 100 x 100 PCB and then put the whole thing into a 3D printed enclosure? Well, sure. But that’s been done to death at this point, and besides, he was looking for an excuse to get more comfortable doing PCB design. We think it also makes for a considerably more visual appealing final product than simply taking the “normal” way out.

Currently [Josef] has an SHT21 humidity/temperature sensor and a BH1750 light sensor slotted into the headers on the top side of the device, but they could just as easily be swapped out with something else if you wanted to do something a bit more exciting. We notice that homebrew air quality monitors are becoming increasingly popular.

Building bespoke enclosures from PCBs is a fantastic trick that frankly we’d love to see more of. It’s somewhat of an artform in itself, but if you’re willing to put the effort in to do it right the results can be truly phenomenal.

Listen To Your Feet, They Have A Lot To Tell You

[Umar Qattan] is in tune with his sole and is trying hard to listen to what it has to say.

At a low level, [Umar] is building an insole with an array of force sensors in it. These sensors are affixed to a flexible PCB which is placed in a user’s shoe. A circuit containing a ESP32, IMU, and haptic feedback unit measure the sensors and send data back to a phone or a laptop.

What’s most interesting are the possibilities opened by the data he hopes to collect. The first application he proposes is AR/VR input. The feedback from the user’s feet plus the haptics could provide all sorts of interesting interaction. Another application is dynamically measuring a user’s gait throughout the day and exercise. People could save themselves a lot of knee pain with something like this.

[Umar] also proposes that an insert like this could record a user’s weight throughout the day. Using the data on the weight fluctuation, it should be possible to calculate someone’s metabolism and hydration from this data.

Interview: FieldKit Team The Morning After Winning The 2019 Hackaday Prize

We caught up with Shah Selbe and Jacob Lewallen the morning after their project, FieldKit, won the Hackaday Prize. FieldKit is an open-source field-based research data collection platform. Which is basically a lot of fancy words for saying it’s a system for collecting sensor data in the field without being snagged by the myriad of problems associated with putting electronics in remote locations. It’s a core project of Conservify, a non-profit organization that seeks to empower conservation research.

As grand prize winner the FieldKit project was awarded a $125,000 cash prize, which Shah and Jacob say is transformative for a non-profit pursuing technology research and development. It seems the grant process has not evolved to embrace developing electronics, while opportunities for research projects have begun to involve recording large data sets in order to test a hypothesis. This is where FieldKit truly shines. Their vision is to provide a low-cost and extensible system that other researchers can use to collect data while making their own grant dollar go much further.

Continue reading “Interview: FieldKit Team The Morning After Winning The 2019 Hackaday Prize”