We're consulting firm led by hands-on software engineers that specializes in custom software development for projects that touch millions of lives in areas of immigration (streamlining operations and working to reduce backlogs on benefit processing) and healthcare (post-COVID public health data analytics work) for the US federal government.
Tech stack: Typescript, React, Java/Groovy, Spring Boot, Docker, K8s, AWS.
Based on my experience, I like the author's approach since it makes things pretty clear-cut and optimized the storage in the core table (in my experience as well, deletes happen frequently and the soft deletes are rarely touched). In large, row-oriented tables that that storage can add up and even with views/materialized views there's a cost to using/maintaining those as well.
Yeah, I checked it out and wanted to use but a bunch of regular old SQL queries don't work. Please add support for the old fashioned group by syntax! (This will be helpful for getting to a true drop-in replacement!)
Even if he's out as CEO he still will likely wield outsize influence due to his 1) board seat 2) equity stake 3) majority of leadership are presumably his people.
Will be interesting to see who replaces him and whether the company actually changes.
What I was really confused though, as this doesn't use a grating etc. is how it obtains a spectra.
Like with a grating I can see how you can obtain a spectral pattern for many wavelengths, but with a bayer array, surely you can only distinguish R, G, B.
Would I be right though in thinking, if there's no stray light and only the light from the phone screen shining on the apple, you can cycle through many wavelengths of light, enabling you to measure the reflected light to determine the spectra.
One thing I was wondering so pesticides can presumably also be detected using visible light spectroscopy then?
>Like with a grating I can see how you can obtain a spectral pattern for many wavelengths, but with a bayer array, surely you can only distinguish R, G, B.
They inversed the principle: Rather than controlling the bandpass of the sensor (which a grating does passively, over the spatial domain) they are controlling the spectrum of the light source. You can produce a varying light spectrum by setting R/G/B on the display, and record the light reflected by the object with your R/G/B camera pixels, which also have a certain frequency response.
I have a feeling you can use this to recreate a coarse approximation of the full spectrum and then use it to infer some of the object parameters, like pesticides on fruit.
This CNC also represents what appears to be the best UI in almost any machining tool I've seen. Glad to see good design thinking not just get it done engineering.
I'm no physicist, but I think that while it may be theoretically possible to distribute power wirelessly doing so in practice seems like it will be necessarily dangerous so as to be impractical. To quote a previous comment I made on HN:
To distribute sound over long distances 'wirelessly' you need to make it loud. That typically means cranking up the power. And ultrasound can be harmful at high power [1].
[1]
"Occupational exposure to ultrasound in excess of 120 dB may lead to hearing loss. Exposure in excess of 155 dB may produce heating effects that are harmful to the human body..."
https://en.wikipedia.org/wiki/Ultrasound
Several of the visualizations use data from ACS summary tables and the axis in several of the visualizations reflect the underlying buckets provided by the Census Bureau.
