Category: Technology

When I first learned about the QUERY function in Google Sheets, I was brought back to the surprisingly large amount of discourse I’ve read regarding spreadsheets and databases, the best of which is contained in Matt Parker’s book Humble Pi. In short, the backbone of spreadsheet software is not designed to let it perform like a database. But because spreadsheets are more explicable, visual, and interactive, businesses and researchers and all other sorts of folk force them into that bucket.

Meta-research has since come out that shows the profound number of accounting and data-reporting errors that proliferate due to the use of spreadsheets as databases. Some of this comes from data type interpretation—what if your gene name is interpreted as a date or currency?—and others come from inherent limitations to how data can be stored and related to each other.

All this well-meaning discussion has tried to guide certain disciplines to take greater care in how they process, store, and access their data. It’s a noble cause, but the humble QUERY function even gets me—someone who perhaps knows better—to forego robust solutions in favor of convenience. So it goes with technology.

I’ve had a strong interest in consumer technology for years at this point, though it mostly falls into a category of entertainment via YouTube videos and podcasts. I’m not critic, and tend not to spend much time writing about the latest and greatest in the spaces I follow. But Apple’s new Vision Pro headset is difficult to ignore.

I’ve slowly formed my thoughts on the language model tools that have stormed into the foreground of technology over the last few months. My initial utter skepticism, largely founded on people’s misunderstanding of how these tools are designed, has morphed into an appreciation of their specific utility as a thesaurus for any kind of text available on the internet.