Hacking Airtable with the Alphabet

For those of you that have been following me for a bit, you know I’ve been live-coding Alexa skill development on Twitch for a few months now. One of my favorite tools for development these days is Airtable, which is mostly just a cloud database, but its user interface, api, and documentation is one of the industry’s best. Seriously.

For many of the Alexa things I build on Airtable, whether that’s a trivia game, or just the speech data that I want to say to my users, I always come back to one fundamental problem:

Airtable doesn’t provide a way for me to retrieve a single random record from the database.

There are LOTS of ways for me to retrieve my data. Filter formulas, sort orders, and primary keys give me lots of options. I have access to created and modified dates for each record. If I know what I’m looking for, it’s incredibly easy. But if I want one random trivia question out of the hundreds I have in my table, I typically have to grab ALL of them, and choose one randomly from inside my software. This is a potentially huge, potentially slow process, and one I’m desperately trying to avoid, but when most of my tables have fewer than 100 records, it’s also not destructive. Yet.

Enter sound effects. The skill I’m building has a library of over 1000 sound effects that a user can request. Sometimes, they will say “play the cat meow sound effect,” and I can determine which one that is, retrieve the record, and play it for them. Other times, they will say “play a random sound effect,” and expect to hear something new. How do I solve this randomization problem? 1000 records is too many to grab every time I need to do this.

Here’s how I “solved” this. Each record has a unique identifier, which I call the RecordId. (You can see the entire dataset here.) Below are ten examples of the RecordIds:

recEux9NFw0Cuqrwy
recFqFT3v7gKNryDt
recVHl6WkB3hsfbG0
rectIyMvutLNbdqig
rec5cRiiDDQ2k16kh
reczDDoansCv22MAh
recckUMmBOvOzgzBb
recIOOnbPCZ5QSPBG
recP5xDQkKxV2vEkQ
recB5raUWFx7pEmmB

They all start with “rec”, and then contain 14 additional random characters. Because I can apply filters to my queries, my first thought was to filter the records based on a single character. So, if I filter on “a” in this example, I’d end up with only two of the ten records above (#6 & #10). (It’s case insensitive.)

When I tried this against the entire dataset, it reduced the number of records I was pulling from 1,000 to around 350, pretty consistently. 350ish is better, but it’s really still way too many. In my next experiment, I tried two letter combinations. I assumed there would be cases, even in 1,000 records, where some two letter combination wouldn’t exist, but I was delighted to find that about 15 records matched every two letter combination as well. 15 randomly selected records is something I’m willing to accept. I can pick from one of those and give my user what they asked for. (Three letter combinations resulted in ZERO records most of the time.)

There are a couple of obvious exceptions to this rule: “re” and “ec” each bring back 1,000 records, since every record contains those letters (“rec”). So I just decided to eliminate “e” from my random alphabet pair generator.

Now, when I need a random record from this collection, I pass in filtering rules on the RecordId for a randomly generated pair of letters, and I get a very small collection of data to work with. It’s not perfect (I’d still love to be able to get just one), but this is FAR better than dragging 1000 records across the internet every time I need just one.

Now for the real question: How would YOU solve this problem? Mine is almost certainly not the best solution, it’s “a” solution.

The Couch Table

This weekend, we finally had our new couch delivered.  (We ordered it in October.)

New couch, who dis?

One of the things we planned to do when it arrived was to build a couch table.  You may not have heard of a couch table before, but I promise that they are a thing.  (A quick search shows lots of examples.) The main idea is to create a 4-6 inch table behind your couch, and in my example, also bring the hidden power outlets from the wall up to an accessible location.

It should be noted that I am not an experienced furniture maker, nor much of a woodworking expert, so any advice or ideas you gain from reading this are entirely your fault.

Planning the Table

I really wanted to minimize how much space this table took up, so I started with the features that mattered most to me: the power outlets.  I spent time in the aisles of Lowe’s and Home Depot, but there wasn’t much variety, and the prices were pretty high.  I took a chance on a brand that had high ratings on Amazon, and was pleasantly surprised by the build quality and price.

Power outlet with cord

One of the things I liked about this outlet type was that it was narrow.  The width of the entire face plate was just over 2″, where a standard outlet face plate in the United States is 3.5″.

Outlet with dimensions.

This meant that I could build a table with a 4″ wide top (actually 3.5″, because the entire lumber industry is a secret society of liars) , and still have a comfortable amount of space on either side of it.  With a wider face plate, I probably would have been convinced to make it 6″ wide instead.

The only other part of planning was determining two dimensions: the length of the couch, and the height of the table.

Our couch, with the chaise extension, is 117″ long (that’s almost 10 feet!).  So that’s how long I want this table to be.  The back of the couch is actually much lower than the back cushions, so an ideal table height would come right to the edge of the back.  That is 28″ from the ground.

With those dimensions, I came up with a plan that looks like this:

It basically became a 2×4 base, with four structural 4×4 columns.  That structure is then completely covered in 1×4 poplar on the top and sides.  You should be able to easily modify this for the length and height of your couch.

Building the Table

Building this wasn’t terribly difficult.  A few long wood screws, and you’re on the right path.  I initially had aspirations to attach the poplar board with dowels, which would mean I wouldn’t have any screw holes, but the further I got into that project, the more daunting it seemed.  (It makes me appreciate the precision that IKEA engineering must have!)

4x4 with dowels

Eventually, I drove screws through the poplar boards to attach them, and filled the holes with wood filler before staining it. I also wanted to make sure that, once assembled, the table would fit in its intended location.  So we brought it inside to test it out before staining it.

Couch table with outlets

It looks like it is going to be perfect!  I’m still debating whether or not I want to use a router to accommodate the trim on the bottom of the wall.  It would allow the table to sit flush against the wall, but I don’t have the tools I’d need to do this in an efficient manner, and it looks pretty good without it.  I can always do this later if I change my mind.

Here’s a photo of the assembled table, with stain, but before the polyurethane has been applied.

Stained table.

To cut the holes in the top board for the power outlets, I started by tracing the box I wanted to cut.  Then, with a 3/4″ drill bit, I drilled a hole in the corner of my intended box.  From there, I used my jigsaw to work my way around the edges of the box.  It was certainly not as precise as I would have liked it, but it definitely got the job done.

The Final Product

This turned out even better than I could have hoped for.  As I said at the beginning, I’m no expert on any of this, but it was a fun project to put together.

ERohQFdWsAEBkI4

Questions about Careers in STEM (Science, Technology, Engineering and Math)

I was recently asked by a high school freshman about my thoughts on careers in STEM.  I thought maybe some of you might also be interested in my answers.

What is your job and what do you do in your job?  How does it relate to STEM?

I am a technology evangelist for Amazon Alexa.  First and foremost, I am a software developer, but the primary responsibilities in my job fall into three categories: learning, building, and teaching.

For the learning part, Alexa is constantly learning how to do new things.  It is my responsibility to be an expert on Alexa, so I am always keeping up with the latest news and releases.  It also means that I need to understand how to use the new technology to write better software.

For the building part, I spend almost 50% of my time creating new things for users to do with Alexa.  Two things I’m currently working on are a giant trivia game, and a Star Wars database.  The Star Wars database will be able to tell you about anything in the Star Wars universe, including droids, characters, vehicles, weapons, planets, etc.

Finally, the teaching part of my job is my favorite, but it’s only possible with the first two parts.  I have to spend a ton of time learning and building to become a credible expert to teach.  I travel all over the world speaking with software developers that want to make their own apps for Alexa.

My role really sits in the middle of all of the STEM letters.  Science is a big part of it, because we are experimenting with artificial intelligence to make Alexa work.  This requires things like hypotheses and controlled experiments to determine what works, and what doesn’t.  Technology is an obvious one, since we make technical devices, and run Alexa as software in the cloud.  Computer engineering is an important part of creating software for Alexa.  Understand what is (and isn’t) possible, and the mechanisms to accomplish them is important.  Finally, there’s math.  Any software developer will tell you that they use things like algebra every day, but this goes even deeper with voice applications for  Alexa, where we use math to determine what you said, the probabilities that it matches our expected outcomes, and to generate responses.

What education did you pursue to achieve your job?

My educational path was a little different than most people in the software industry.  I got a bachelor of science degree in Psychology, where most of my peers have degrees in Computer Science or something similar.  Most of my knowledge and experience in software development is self-taught.  I would take apart the source code of interesting websites, or read books about software development to get better at it.

What are the advantages and disadvantages of working in the STEM field?

There are a couple of obvious advantages: STEM jobs pay really well.  Last I checked, a software developer fresh out of college can make over $70,000 a year.  Even more with some experience.  STEM jobs also have the advantage of being flexible.  It is primarily “thought work,” which means you can often do it whenever and wherever you choose.  This allows me to live in Ohio but work on a team located in Seattle, for example.  We have different time zones and locations, but still work well together.

One of the disadvantages is that most STEM careers require a commitment to constant learning.  If you stop keeping up, even for a few years, it’s easy to get so far behind that you almost feel out-of-date.  The software industry moves incredibly fast, and you really need to keep up to maintain success and relevance.  STEM roles also tend to not be very diverse, which is a huge disadvantage for those involved.  Diversity in the workplace makes software better, because it brings everyone’s perspectives together.  When there is a lack of diversity (85% of software developers are men, for example), the end product is worse for everyone.

Why do you believe STEM is important now?

I think people are talking about STEM today because the diversity problem needs to be solved at a much younger age.  Women and girls are often talked out of pursuing technical careers as early as 6th grade, which leads to the diversity problem I mentioned earlier.

I also think it’s important because it is estimated that there will be almost 2,000,000 STEM jobs that will go unfilled by 2022 because there won’t be enough people with the right education to do them.

How important do you see STEM jobs being in the future? What new jobs might need to be added to the field?

The future is science, technology, engineering, and math.  Every company will need software developers.  Those that avoid it will struggle to compete against those that do.  It adds efficiency, streamlining, and accuracy.  Many of the jobs that require physical labor will be replaced by robotics.  Many of the jobs that involve drivers will be replaced by self-driving cars and trucks.  But this also means there will be a huge need for robotics experts and mechanics to maintain all of this automation.  (It also means scientists will need to figure out how to create human organs soon, because 20% of all organ donations today come from traffic accidents, and self-driving cars will ultimately eliminate those!)

I can see a very near future where an entire restaurant is supervised by one person, but run by computers and robots.  A future where nobody owns or drives a car anymore, but just calls for a self-driving robot to take them where they need to go.

And with voice, where scheduling appointments with your dentist is as easy as telling your voice assistant to schedule one.  The assistant compares your calendar with your dentist’s calendar, checks your dental insurance to make sure it is covered, and makes the appointment.  It probably also books you that self-driving car to get there. 🙂

#21: Han Solo, Hardware, and Hoodies

Han Solo

Speaking of Han Solo, you may have already gathered that I am a pretty big Star Wars fan.  I fell in love with the films as a kid, survived the prequel trilogy enough to defend it, and have really enjoyed sharing the sequel trilogy with my children.

So it might seem natural for a guy that works at Alexa to want to make sure Alexa knows everything about Star Wars the same way that I claim to.  So I am.

A few weeks ago, I started a new project on my Twitch channel, where I spend time live-streaming software development, smart home stuff, drones, and technology in general.  It’s a great outlet for me, because I get to share my passion with others, record it for those that couldn’t tune in live, and explaining things is the best way I’ve found to be sure that I understand something.

So far, it is able to tell you about nearly every character, droid, creature, vehicle, weapon, technology, species, location, and organization.  It can also play the original trailer and opening crawl videos from each of the films and television shows.  It can also quiz you.  So you can say “Quiz me on Episode 5” and it will choose a random thing from that film to give you clues about.  Or you can say “quiz me about vehicles” and test your knowledge about vehicles from around the Star Wars universe.

It’s not done yet (so you can’t ask Alexa for all of these awesome things yet), but it should be coming soon.  In the meantime, if you want to have some input on what it does, or just see how it is constructed (like a Death Star), come join me sometime!  I live stream every Monday and Wednesday from 10am – 12pm Eastern time.  You can also subscribe, so you’ll get a notification when it happens.

Hardware

I love computer hardware.  I’ve built my own Alexa device from a Raspberry Pi.  I have a device attached to my garage to open and close it.  I have a ceiling fan I can operate with my voice.  The point is, I love to make cool hardware do cool things.  And this January, I’m taking that one step further.

At one of my favorite technology conferences, Codemash, I’m working with a good friend of mine, Brandon Satrom, to run a 4-hour technology workshop that combines my passion for hardware with my passion for voice technology.  The first two hours, you will assemble and create your own IoT device, complete with sensors and lights.  In the second two hours, you will build an Alexa skill that is specifically designed to control your newly created hardware.  Change the color of the lights, ask for the status of a sensor.  You get the idea.

I’ll be publishing all of the instructions, code, and tutorials as we get closer to the event, so keep an eye on my GitHub.  And then even if you couldn’t make it to Codemash, you’ll be ready to build some cool hardware for yourself.

Hooded Sweatshirts

I fought the term “hoodie” for the longest time, but it appears to have stuck, and I’ve been caught using it from time to time.  It’s not my favorite word, by far, but it IS one of my favorite articles of clothing.  I’m very particular about the types of hoodies I’ll wear, though.  I tend to aim for lightweight, and generally prefer polyester to cotton.  (Cotton is generally thicker, and it never sits nicely, so it gives my bulgy body extra bulges.) There are a few models of sweatshirt that I really like, so I thought I’d share my nuanced take on the most comfortable hoodies available.


Nike is the king of athletic wear, and this hoodie is at the top.  The biggest problem I have with it is that it’s expensive.  But that’s the ONLY problem.  The Nike Showtime Hoodie is generally at $100 or more.  It’s soft, and has a really smooth texture.  It keeps you warm in the winter, and cool in the summer.  And it just looks fantastic.  This one is white, but I’ve seen it in red, black, and gray, too.

This is Nike’s 2nd best effort.  The Nike Dry Training Hoodie is just excellent.  It’s usually around $60.  The polyester in this one is spun to feel like cotton (rather than the others which are that more “athletic” feel.) . It’s warmer than the others, but you’ll also note that both of the Nike entries here have a higher neck.  I love that higher neck.  It just feels cooler.

This is the Champion AO100.  It’s $22.  You generally don’t see these in stores, because they’re generally used to make branded logo apparel.  That’s actually how I discovered them.  I generally get something made for my team at Alexa for our big events, and this was last year’s entry (in black.)

This is the thing I see most of my teammates wearing when I go to the office.  It’s just comfortable.  It’s a tri-blend material, made from polyester, rayon, and cotton.  It’s so soft, and super thin, almost like a t-shirt.  Can’t recommend this one enough.

This is made by Amazon Basics, actually.  It’s $29.  And I know what you’re thinking: “Jeff, that has a full zipper.”  I know, I know.  But because it’s made of a soft polyester, it hangs on my body properly.  I only wish I looked as good in it as this guy does.  It also has a higher neck, but it just fits “right.”  I own several of these, and at the price point, it’s hard not to.

Also, if you haven’t taken a look at Amazon Basics clothing, it’s actually pretty fantastic.  I just bought some undershirts, and I am very impressed with the quality, especially for the price!  ($20 for 6!)

#20: Growing Up, Goose Game, and Gumlines

Happy Tuesday!  Time for more ramblings from my brain!

Growing Up

I’ve been giving a lot of thought lately to what it means to be a grown-up.  An adult.  I sometimes question whether or not I’ve actually made it there yet.  I still make gross jokes.  I still think farts are funny.  I certainly don’t clean up after myself as well as other adults in my house might prefer.

But what does being an adult really mean?  We hear the word “adulting” all the time these days, as a reference to doing something that adults do, but fully insisting that we are not actually adults ourselves.  Opening a bank account.  Cleaning your carpets.  Starting a 401k.  I don’t think those are actions of adults, however.  Those are activities that are just boring, and nobody wants to be boring.

I want to assert that adulthood actually starts when you learn empathy.  The ability to put yourself in someone else’s shoes and understand how they feel.  Some never do.  Think about the adults in your life, and think about the things they do that seem childish.  They make selfish choices.  They unintentionally (or intentionally) hurt others.  They put their own superficial wants above those around them.  They don’t consider the advantages they have over those that are less fortunate.  I contend that most of the representatives in our government have yet to make it to adulthood, because they haven’t yet grasped empathy.  For example, with empathy, there isn’t a single situation in which separating families and putting children in cages should ever seem acceptable.

Selfishness is an attribute of a 3 year old.  Not someone in their 70s.

The entire point of humanity is to make being a human better.  For everyone.  Not just for yourself.  Find someone your junior at work, and offer to mentor them.  Volunteer with a non-profit.  Donate your time or money to a food bank.  Share your knowledge and experience with those that need it.  For free.

Lifting others up is far more rewarding than stepping on them for your own gain.  Think with empathy.  Be an adult.

Image result for empathy

Goose Game

I recently discovered Untitled Goose Game on the Nintendo Switch.  What a delightful, simple, amazing game.  My quick summary is this:  You are a goose, and you start by terrorizing a farmer in his small city farm.  You steal his crops, his keys, his radio, all while honking your head off and hoping not to get caught.  You have a simple checklist of tasks you need to complete, and then you move on to the next part of the city.

The personality and animation of this goose, though…it’s hilarious.  When you grab something heavy, his head stays low and drags the item across the ground.  When the item is light, he can sprint away, with his head bobbling along and his wings flapping.  Someone really studied geese to get this right, and I think it was worth it.  They invested their time in goose physics instead of game naming, and it’s fantastic.  I give it five honks.

Have you played it?  What’s your favorite thing to steal?  Did you name your goose?

Gumlines

Let me start this part with a couple of disclaimers:

  • My father was a dentist, and I grew up with excellent dental care.
  • I have never had a cavity.  I never wore braces of any kind.

One of the things that my current dentist tells me regularly (my father retired a few years ago, and let me tell you, going to my first non-father dentist in my late thirties was a weird experience), is that people with really good teeth tend to have problems with their gums as they get older.  Maybe it’s overconfidence, but for a while, I thought it was a long running sales pitch.

They’ve been monitoring my gumline for years, six months at a time, and I’ve observed that my gums tend to bleed a little when I’m at the dentist, or when I floss (which isn’t that often).  So I finally gave in, and took their offer to try something called periotherapy.

In short, periotherapy is about four hours of treatment.  (We divided it into two separate sessions of 2 hours.) . They have 5 different sonic pressure water tips that they use to flush out the spaces between your gums and your teeth.  So imagine using a high-pressure power washer to blast your gums away from your teeth briefly.  And then doing that, for your entire mouth, five times.  Once for each tip.

Your gums are sore for a few days.  It feels like you have a fever in your mouth.  You also have to use special toothpaste with a chemical called Xylitol to aid in the healing and prevention of bacteria.  There’s also a special mouthwash.  There’s also these anti-bacterial tablets that you need to dissolve in your mouth each night.  It’s awesome.

Now that it’s all done and healed, my gums don’t seem to bleed when I floss.  It removed any of the bacteria that was living inside my gumline.  But I have noticed that a couple of my molars seem to be a little more sensitive to cold drinks and ice cream.  I’m hoping as time progresses, that this sensitivity will subside.

Have you gotten anything like this done?  What did you think?

#19: Followers, Friends, Family, and Funko

Happy Wednesday!  How was yours?

Followers

I’ve been a technology evangelist for over 12 years now.  It started with Microsoft in 2007, and it continues with Amazon Alexa today.  Much of my time is spent using new technologies, and building things with them.  But the rest of my time is spent finding an audience, and talking to them about what they like, what they need, and what they want in the future.

Developing a “following” is obviously important to my job.  I want to be useful, educational, and relevant to the people (software developers) that I’m employed to help.  Most of the time, I know that if I create great content, and provide utility, people will find me.  And that has been true for this incredible ride I’ve been on.

But there’s also times where I wonder if I’m doing enough.  I start to compare myself to others in my industry, and wonder how they gathered such a huge following.  It takes a large heaping of self-confidence (and a dash of hubris) to be able to remind myself that I’m good at what I do, and that my follower count is not a direct reflection of that.  Followers are nice, but I’m writing this for what is currently an audience of 50 people.  Do I hope more people will read it?  Absolutely.  Am I going to be defeated if they don’t?  Nope.  I’m writing this for me.

But what if I was a teenager today?  I’ve been doing lots of reading about this subject, and it scares me.  Children are basing their entire personal esteem value systems on the number of likes, follows, and streaks they have.  It’s the currency of this generation.  Your value to others is measured by viral posts, not by your quality as a human.  I don’t think it’s limited to teens, either.  How many of you would say that your “social media persona” is the same as your real persona?  We shine up the rough edges, use just the right filters, with the right lighting and the right camera angles.  We only talk about our successes, and don’t bother with our failures.  (Not sure?  How many divorces have you seen posted on social media?  How many baby gender reveals have you seen?)

My point is that it seems to be getting out of control.  We need to remind our children (and our friends) that we are the only one that can measure our own value.  It is up to us as individuals to determine our own self worth.  By allowing this measurement to be determined by complete strangers on the internet, we are setting ourselves up for nothing short of disappointment and failure.  And you’re better than that.  We all are.

Friends

Why is it so freaking hard to have friends?  I don’t mean people I’m connected to on Facebook, or Instagram.  I mean real – I’ve seen you in person in the past 30 days – kinds of friends.  I can count the number of friends I’ve seen in the past 30 days on one hand.  And I don’t think I even need all of the fingers.

We’re all busy, I get that.  But what are you doing this Friday night?  Let’s DO something!  Board games?  I’m in.  Hockey game?  Definitely.  Dinner and drinks?  You betcha.  And that’s the real problem.

Did you see how I framed that?  I’m waiting for you to ask.  If you invited me to a hockey game, I would drop nearly anything to make that happen.  Why didn’t I call you?  Why didn’t I ask someone?  Because that’s harder.  You might say no.  You might not like me.  It’s just more difficult.  But it’s what I need to do.

My mom said something to me when I was in my early teens that I will never forget:

“If you don’t call and make plans with people, nothing will happen.  They’ll never call you.”

I don’t say this often, but she was absolutely right.  Nearly nothing has been more true in my life than that statement.  I need to plan things, I need to make the call.  And so do you.  Your friends like you, and they’d probably jump at the chance to hang out, but the daily hustle-and-bustle distracts from the important stuff.  Spending time with the people you love in your life is more important than nearly anything else.  And we do a really shitty job of actually making that happen.

Family

Speaking of spending time with the people you love, Thanksgiving is quickly approaching here in the United States.  An opportunity to eat the best comfort food your family lineage has invented.  An opportunity to be thankful for all that you have.  An opportunity to sit in awkward silence as your uncle defends his not-so-subtle racism through talking points he picked up on Fox News.

Are you looking forward to Thanksgiving?  What’s your favorite thing to eat on that day?

Funko

I have a problem in my life.  And its name is Funko.  For those of you unfamiliar with this word, Funko is a toy manufacturer based in Washington State, and their most successful line of products are called Pop!

If you haven’t heard of them before, you’ve certainly seen them on the shelves of nearly every store you can imagine.  There are exclusive figures at stores like Walgreens, Hot Topic, Barnes & Noble, Target, and even Foot Locker!  I started collecting these with my family five or six years ago, and it was a slow process.  We would find a character from something we loved, like Star Wars, Harry Potter, or Marvel, and we just had to have it.  And the collection grew.  And grew.

When it started exploding was sometime last year.  I discovered there was a Funko app, and it would allow you to track your entire collection digitally.  Here’s what got me, though: once I’d entered my collection, they also assigned a dollar value to each one, based on recent sale prices at websites like eBay and other auction sites.  Some of earlier figures we had purchased were worth close to $100 each!  This completely changed my perspective on this collection, and future purchases.  “Will this be worth anything?”  “Is it rare?”  And that’s how we ended up here:


I’ve generally slowed my collecting way down.  There’s a few times a year that something interesting will come out, and I’ll be quick on the trigger to get one before they sell out.  The most I’ve ever spent on one is $15.  The most recent additions are:

So I’ve shared my collection.  The good, bad, and the ugly of it.  Now it’s your turn!

What do you collect?  Do you have anything from Funko?  What’s your passion?  I’d love to hear from you, friend.

#18: Elephants, Energy, and Excuses

Elephants

I visited Denver, Colorado about a week ago, and with the proliferation of Safeway grocery stores there, I was reminded of a fantastic joke.

You: “How do you get an elephant into a Safeway?”
Them: <puzzled look>
You: “It’s easy.  You take the ‘F’ out of Safe, and the ‘F’ out of Way.”
Them: …

Them: “There’s no ‘F’ in Way.
You: You’re right!

Energy

I am 43 years old.  I’m old enough that I had to do the math to remember how old I am.  I have daily lower back pain, the hair in my nose and ears grows five times as fast as the hair on my head, and I groan every time I lean over or get up from a chair.  I’m an old man.

But it’s my energy level that’s the most concerning. I am tired ALL. THE. TIME.  I’ve been offsetting that with a daily Red Bull, but that’s no longer having much effect.  (Yes, I know it’s not a great choice.) . I don’t want to be tired.  I want the energy my children seem to have.  I started running every day a few months ago, and I think it helped a little.  I have been traveling a ton over the past month, and it has definitely slipped, but I got back at it this morning, and I noticed that I actually missed it.  I was still able to run at a good pace for a few minutes.  I was still able to catch my breath while walking at 4 miles an hour (a brisk pace).  I’m going back tomorrow, too.  I can get to the gym every day, right?

But I still think it’s more than that.  I’m heading to my doctor next week to figure this out.  Maybe it’s sleep apnea, maybe it’s allergies that have me congested all of the time, or maybe I’m just old and this is how it works.  I’ll just get more tired and grumpy until eventually I pull out of parking spaces without looking backwards, and yell at kids to get off of my lawn.

How are you feeling today?

Excuses

Much of the stuff I mentioned in the energy section of this letter have become my excuses in life.  I don’t like it.  I have a huge presentation I need to finish, and I always seem too tired to work on it.  I’ve been livestreaming a ton on Twitch (give me a follow!), and afterwards, I tell myself I need a break because I feel so tired.

My wonderful, talented wife has a ton of cool home improvement projects percolating in that beautiful head of hers, and I find myself making excuses for why we shouldn’t do it.  Bad timing, too much money, back hurts, you name it.

Why am I making excuses to avoid things I would normally LOVE to do?  It’s time to get my head on straight, focus on what is important, and keep building the life and home I want for my family and me.

What are your excuses?  If you hate your job, why do you stay?  Same goes for that relationship!  If you’ve been meaning to learn something new, what’s the excuse you use to skip it?

If I told you that your life would be exactly the same 10 years from now, would you be happy about that?
NO.
So why are you constantly avoiding change?

Stop making excuses.  Get your ass out there, TOMORROW, and make the change in your life that you want!

#17: Debt, Delivery, and Databases

Apple Card

Yes, it’s a credit card.  Yes, it’s from Apple.  But let’s get past all of the marketing hype and talk about what this card really is.

In short, the Apple Card is like any other credit card.  You can make purchases with it, and if you pay it off on time, it’s basically a free short-term loan.  If you don’t pay it off on time, you incur interest charges (and the reported interest rates I’ve heard around the web vary wildly.) . Mine is 12%, but I have one of the highest possible credit scores, so your mileage may vary.  If you pay it off every month (or day), the interest rate won’t matter.

There’s a couple of features that are nice, but as someone that uses several credit cards for travel and work, I’m constantly evaluating whether or not they’re actually worth using.

1) Cash Back.  If I just use the physical card (it’s gorgeous, super heavy, and made of titanium), you get 1% cash back on purchases.  If you use Apple Pay with the card, you get 2% back.  If you buy something directly from Apple, you get 3%.  You receive your cash immediately, as soon as you pay some of all of your balance.  It’s a cool software feature to pay your card, and receive an alert that they just gave you $2.94.

2) Daily Payment. I can pay my card once or several times a day.  I tend to like to make payments that are the same amounts as the transactions, so that I’m treating each transaction as its own item that I’ve “paid off.”  I actually wish they would implement some features to make this possible, so that I could just pick an individual transaction, and “pay it.”  It would be nice to see a list of my transactions, and which ones have actually been paid off, rather than trying to reconcile payments with transactions.

3) Reporting.  There’s some good reporting built into the Apple Wallet software too.  It lets me easily see how much I’ve spent, where the money went, and how much cash back I earned, all on one screen.  I still think this could be better, but for the first version, this is pretty decent.  (I’ve been using this card on my Lyft account while I travel for work, which is why my transportation category is so high this month.)


So that’s the quick highlights.  Now, if you’re looking for my guidance on whether you should get one?  I’m not sure.  I think there are better options, even if the software is cool.  I’ve been using my card a bit since August 2019, and I haven’t earned $100 in cash back yet.

I spent $1815.73 in August, and got $22.50. (1.23%)
I spent $2831.14 in September, and got $49.26. (1.74%)
I spent $545.11 in October, and got $11.00. (2.02%)

Because I travel quite a bit for work, I am also using the Delta Reserve American Express card, and the Marriott Bonvoy Visa.  These boost the miles and points I earn quite a bit, and the value of those points seems to far exceed the cash back value that I get from the Apple Card.  (As an example, in the last 6 months, I’ve earned enough Skymiles from Delta to fly my entire family of 4 to New York City roundtrip, first class.  That would be nearly $1600.)  Now, part of that is because I’m already flying on Delta a bunch, and my Diamond status with them also contributes.  But the credit card is really the multiplier that makes it all happen.

The most interesting part of my Apple Card experiment has been how much it’s changed my behavior around using Apple Pay.  I mean, I get an extra 1% just for tapping my phone instead of swiping my card!  I’ve found myself asking folks in the drive thru window if I can pay with my phone, and I’m disappointed when someone doesn’t offer it.  (I’ve even had Wendy’s give me my meal for free when I asked, because they couldn’t accommodate!) . We’re still in the early days of mobile payments, but I’ve been surprised how many places are equipped to handle it.  I’m definitely looking forward to the future!

Delivery

As I sit here waiting for my Echo Buds to arrive today, I’m really in awe of where we are today with our deliveries.  This isn’t a long section, but you might learn something new along the way.

1) Amazon now offers ONE-day delivery.  ONE DAY!  I’m sure I don’t need everything delivered the next day, but what an awesome option when I do.  I’m looking forward to enjoying my Alexa-enabled earbuds later today.

2) You can see your mail every day.  If you haven’t heard of USPS Informed Delivery, you should really check it out.  I get an email every morning with photos of all of the mail that will be delivered that day to my house.  This includes a list of packages and tracking numbers, too!  This is especially cool when someone mails you something you weren’t expecting (and weren’t told about), so that you can make sure to get home and grab it when it arrives.

3) UPS My Choice is also awesome.  UPS My Choice is similar to Informed Delivery, but with more data.  You can get a notification every time your package moves in the UPS network, and once it’s out for delivery, they even let you track the location of the truck it’s on.  Super awesome when you’re expecting something exciting.

Databases

For the last entry in this letter, I wanted to briefly talk about a database service that I’ve been using to build many of my Alexa skills.  It’s called AirTable, and it’s awesome, but maybe not for the reasons you think.

First, it’s mostly free.  At least at the volume that I’m using it for.

Second, I tend to collaborate with others on my software.  It’s really difficult to write the entire application, and gather and curate all of the necessary data to make the app work.  Airtable makes that kind of collaboration incredibly simple, and it does it with an interface that is friendly even to those that don’t regularly build software or work with technical tools.  It basically looks and acts like a spreadsheet!

The reason I, as a developer, like it so much, however, is because of what it provides that makes writing software easier.  I can use their API to make calls directly against my data, and retrieve what I need in a JSON format.  And it’s fast.  There’s also an SDK if I want to make targeted calls to update records, for example.  I tend to use the SDK for insert and update operations, but for read operations, I find it easier to make direct HTTPS calls thanks to some helper functions I wrote for myself.

Their technical documentation gives you actual code samples, using your data and structures, that you can copy and paste directly into your code, and it works!

There are lots of cloud database options out there, but I have yet to find one as user friendly, inexpensive, and powerful as Airtable.  I wish the other folks in this industry would take notice, because they’ve really figured it out.

Cutting the Cord – 7 Years Later

In April 2011, I wrote a post about how my family and I were going to cut the cord from cable.  Since that time, much has changed in the landscape of cord-cutting, so I thought I’d write a quick summary of where we are today, both in service subscriptions and hardware.

Subscriptions

Initially, we were subscribed to Hulu Plus and Netflix.  Netflix wasn’t even on my radar for the first article, because it was mostly older movies and television shows.  In 2011, it might have even been mailing us DVDs!  Today, we have a few more subscription services, but we also have access to much more programming.  Here’s the list (with prices, including tax):

Netflix ($14.97)

With a 14 and a 10 year old, we have the “4 screens + UltraHD” package.  There have been plenty of times where we are all watching something separately.  Netflix has really upped their game with original content in the past few years, and is absolutely a staple of our entertainment watching.

Hulu Plus ($12.97)

This is still the primary way we watch television.  We add the shows we watch to our queue, and Hulu gives us a managed list of recent episodes when we open the app.  It’s easy to see and review what you’ve still got available to watch.  We stepped up to their “No Commercials” plan, which is about $4 more per month, but is totally worth the time savings alone.  22-minute shows are 22 minutes, not 30.

DirecTV NOW ($42.80)

When this was announced, we jumped in to give it a try.  (Primarily because they gave us a brand-new Apple TV if we bought three months up front.)  We chose their “Go Big” option, which includes 105+ channels, but we get it as a grandfathered discount price of $40/month.  Here’s a picture of the included channels.

Screen Shot 2018-10-31 at 9.26.10 AM

We obviously don’t watch all of those channels (this is the primary problem with bundling this stuff in the first place), but we felt like we’re getting a good deal, so we haven’t stepped down yet.  I actually JUST reviewed the list of channels we would lose by moving down a step, and I think I’m going to make the switch to “Just Right” today.  This would drop my monthly bill another $15.

One of the biggest features of having a DirecTV NOW subscription is that your credentials unlock all of the other channel apps.  For example, if you use the ESPN app, you can log in and watch literally any college football game on Saturday.  If you like the Food Network, you can open their app and watch shows from your favorite series.  I like the shows “Better Call Saul” and “Walking Dead,” which I can catch on the AMC app.

HBO GO ($0.00)

Because we are AT&T customers with their Unlimited Plan, and also DirecTV NOW subscribers, they throw in HBO for free.  We don’t watch it a ton, but for free, I’ll watch John Oliver and Game of Thrones!

Hardware

We are really torn on this, and it’s really frustrating.  Primarily, we use a Roku Premiere+, which is outstanding, and has been our mainstay for years.  But the tide is turning, and there are a number of great devices out there.  We also have an Apple TV, and a Amazon Fire TV Cube.  There’s plusses and minuses to each.

Roku Premiere ($40)

Interface: Of all of the interfaces, this one wins.  The interface is just a grid of your installed apps.  Everything else you have to dig a little deeper to find.  It’s perfect.

Remote: The remote is also excellent.  Tactile, rubber buttons and volume control are huge.  It also has a headphone jack on the remote for when you want to watch without interrupting others.

Amazon Fire TV Cube ($120)

Interface: Sadly, this is probably my least favorite interface.  There’s too much retail focus, and not enough easy visibility into the apps, which is my core use case.  While I completely understand, since Amazon Video has a ton of amazing content, this creates an extra step every time that I want to watch TV.  The one big feature this device holds is that it’s also a full Alexa device, that can also control your TV.  “Switch to Input 3,” or “Turn off the TV” are amazing commands that get used regularly in our house.

Remote: The remote is great.  Very well thought out.  Voice search is awesome.  Voice commands are great.  It’s really the software interface that holds everything back, because hitting the “Home” button still leaves you one step from most of the things that you want to use.

Apple TV 4K ($179)

Interface: This comes close to the Roku interface: a giant scrolling list of apps. Where it starts to fall down is that it’s easy to get lost, especially with all of the default Apple apps that clutter up the list.  It’s the remote that makes everything fall apart.

Remote: This might be the worst remote control that has ever been created.  Because it mostly a trackpad, every time you pick it up, you can’t help but press a button.  All directional controls are done as swipes, which sounds awesome, but is actually much slower than pressing a physical button.  Add to all of that the fact that it’s wafer thin, and easier to lose in the couch than you’d like, and you’ll learn to hate it.  Not a fan.

 

Traveling with Alexa

As you might imagine, I spend a decent amount of my time traveling around the world talking about Alexa.  Because of this, I frequently find myself bringing a couple of devices with me where ever I’m headed.  Early on, I would just throw an Echo Dot in my bag, and coil up the power brick and cable.

I was always worried it was getting knocked around in my suitcase or backpack, so I started looking for a small container or bag to keep it in.  That’s when I discovered Khanka Cases on Amazon.  They make awesome hard-shell cases for each of the different Alexa devices (including the Fire TV Stick and the Echo Show!), and I now take most of the devices with me on every trip because they pack so nicely, and really protect the hardware.  I can’t recommend these enough.  Here they are:

Echo Dot Case – $7.99

echodot

Echo Case – $12.99

echo

Amazon Tap Case – $10.99

tap

Amazon Fire TV Stick Case –  $8.99

firetvstick

Echo Show Case – $22.99

echoshow

 

Finally, it’s a little obvious, but traveling with a Fire TV Stick ($40!) should become an absolute requirement for you if you travel any for work.  Having all of my streaming options, including movies and tv shows from Amazon/Netflix/Hulu/DirecTV NOW/HBO GO/Fox Sports Go/Plex available to me in every hotel room is lifechanging.