Tag programming

ESP8266 ADC Inconsistency Fixed

Share

tl;dr The ESP-12F ADC pin appears to consistently read higher values at times when the processor is not as busy. I worked around this by taking the average of multiple reads, and discarding any averages where the number of samples…

Share

3D Printed T10 Lamp Shade

Share

Here’s a 3D printed T10 lamp shade that I designed and printed last night. A few weeks ago while searching for LEDs, I noticed an ebay listing for very inexpensive 12V automotive lamps that combine nine bright white LEDs. I…

Share

J&M SCR Robot Test-drive

Share

He we’re test-driving the our latest robot creation for the first time. It’s the boy’s design and made mostly of wood. The tires are o-rings, and there’s a 12V AA batter pack sandwiched between the two pieces of plywood. The…

Share

Parsing and Joining on a Long Text Field Using SQL

Share

Here’s a little SQL gymnastics used to parse and query against a predictably-formatted long text field. The challenge: We have a single text field that contains a list person_id-to-area mappings, and we need the query the database for a list…

Share