Data

All things data related. Pretty much redundant, considering this is a blog about data.

Stitch's “Query Anywhere”: Executing Business Logic via Frontend

MongoDB Stitch vs the impossible: secure database queries via frontend JS

Some tools are simply the right tool for the job. I imagine this must have been the thinking behind the wave of JSON-like NoSQL databases at their peak, and even so today. If we figure we’ll be passing information as JSON to an endpoint, to then have it structured into a schema, only to be promptly broken down again

NoSQL Todd Birchard avatarTodd Birchard Todd Birchard avatar
toddJan 15
Nov 23
Read

Create a REST API Endpoint Using AWS Lambda

Use Python and MySQL to Build an Endpoint

Now that you know your way around API Gateway, you have the power to create vast collections of endpoints. If only we could get those endpoints to actually receive and return some stuff.

We'll create a GET function which will solve the common task of retrieving data from a database. The sequence will look something like:

  • Connect to the database
Read

Create Google Cloud Functions Running Python 3.7

GCP scores another victory by trivializing serverless functions

The more I explore Google Cloud's endless catalog of cloud services, the more I really like Google Cloud. This is why before moving forward, I'd like to be transparent that this blog has become little more than thinly veiled Google propaganda, where I will henceforth bombard you with persuasive and subtle messaging to sell your soul to Google. Let's be

Google Cloud Todd Birchard avatarTodd Birchard Todd Birchard avatar
toddJan 15
Oct 18
Read

I Owe My Job to Mr. Robot

Entering the Dataverse

What's up data gang? If you've been reading along throughout this journey, you'll realize that all of my posts have something in common (other than Excel...smartass), they all assume that you're already working with data...even if it's just cursory exposure. Well, every journey of a thousand worksheets begins with a single lookup, and hopefully this story will help

Data Max Mileaf avatarMax Mileaf Max Mileaf avatar
snacksJan 15
Aug 14
Read

Hacking Tableau to Handle ETL Workflows

Weaponizing APIs against tyrannical software

Before we get into the specifics of how to sadistically abuse Tableau, let's clear the air: there's something about inaccessible, expensive, proprietary enterprise software that tends to put me in a touchy mood. As we know, B2B software pricing has nothing to do with code quality or even value-add, but rather the tendency of businesses to create time-based urgencies without

Tableau Todd Birchard avatarTodd Birchard Todd Birchard avatar
toddJan 15
Aug 03
Read

Data Could Save Humanity if it Weren't for Humanity

A compelling case for robot overlords.

A decade has passed since I stumbled into technical product development. Looking back, I've spent that time almost exclusively in the niche of data-driven products and engineering. While it seems obvious now, I realized in the 2000s that you could generally create two types of product: you could either build a (likely uninspired) UI for existing data, or you could

Read

Extract Massive Amounts of Data from APIs in Python

Abusing APIs for all they’re worth

Taxation without representation. Colonialism. Not letting people eat cake. Human beings rightfully meet atrocities with action in an effort to change the worked for the better. Cruelty by mankind justifies revolution, and it is this writer's opinion that API limitations are one such cruelty.

The data we need and crave is stashed in readily available APIs all around us. It's

Python Todd Birchard avatarTodd Birchard Todd Birchard avatar
toddJan 15
Jul 04
Read

Yes...If(And))

Adventures in Excel

If you've been following along on our proverbial Hogwarts for budding Excel wizardry, you would know that we recently crossed an important Rubicon upon which all Excel, and indeed all computer programming languages are built: The mighty IF statement. Remember, the IF statement allows the wielder to fork reality at their whim, to bend the code on a lark, to

Excel Max Mileaf avatarMax Mileaf Max Mileaf avatar
snacksJan 15
Jun 20
Read