Whiskey Web and Whatnot

SQL vs NoSQL, Web Technologies, and Holiday Recap

Listen Later

If you’re like Robbie and you haven’t dug into SQL since college, learning the basics of SQL vs NoSQL is a great place to start. Working with data isn’t a part of every developer’s day-to-day, but it can’t hurt to understand the differences.

NoSQL is gaining popularity among engineers because of the ease and flexibility of updating fields with new data. Some engineers prefer taking unstructured data and using a programming language they already know, like Python, to write their queries. SQL is far more structured and requires strict rules for writing queries. As with most things in tech, whether SQL is better than NoSQL depends on your business and use cases.

In this episode, Robbie and Chuck talk about the pros and cons of SQL vs NoSQL, why they like SQL databases like Prisma and Postgres, and their Christmas and New Year festivities.

Key Takeaways

  • [00:56] - Chuck and Robbie wrap up the Advent of Whiskey.
  • [01:35] - A whiskey Review: Yellowstone Select Kentucky Straight Bourbon Whiskey.
  • [04:47] - SQL versus NoSQL.
  • [13:24] - Using Prisma and MySQL.
  • [28:56] - Chuck and Robbie discuss the holidays and family life.

    • Quotes

    [16:40] - “I don't have to touch databases much, but when I do, I like that they are Postgres.” ~ Robbie Wagner

    [17:13] - “I never really remember having fun with a project that was in SQL Server or MySQL.” ~ Robbie Wagner

    [22:26] - “This project is using Prisma, and Prisma has nice sugar around accessing entities.” ~ Chuck Carpenter

    Links

    • Yellowstone Select Kentucky Straight Bourbon Whiskey
    • Lime Stone Branch
    • Buffalo Trace
    • MySQL
    • DynamoDB
    • PostgresSQL
    • Prisma
    • PostGIS
    • Supabase
    • Postico
    • SQL Server
    • Ember Data
    • Astro
    • SolidJS
    • Next.js
    • SolidStart
    • Remix
    • Shopify
    • Spotify
    • Michael Jackson
    • Roka Akor
    • Pepsi
    • 90-Day Finance
    • Andor
    • Peaky Blinders
    • Spirited
    • The Greatest Showman
    • Everyone Says I Love You
    • Woody Allen
    • Edward Norton
    • Drew Barrymore
    • Hamilton
    • Disney
    • Book of Mormon
    • Deadpool
    • Ryan Reynolds
    • Welcome to Wrexham
    • Mint Mobile
    • My Next Guest Needs No Introduction
    • Comedians in Cars Getting Coffee
    • Kim Kardashian
    • Kanye
    • Titanic
    • House of Cards
    • James Dean
    • Sharpie
    • Porsche
    • iPhone
    • CNN
    • Don Lemon
    • Anderson Cooper
    • Kevin Hart

      • Connect with our hosts

      • Robbie Wagner
      • Chuck Carpenter
      • Ship Shape

        • Subscribe and stay in touch

        • Apple Podcasts
        • Spotify
        • Google Podcasts
        • Whiskey Web and Whatnot

          • Top-Tier, Full-Stack Software Consultants

          This show is brought to you by Ship Shape. Ship Shape’s software consultants solve complex software and app development problems with top-tier coding expertise, superior service, and speed. In a sea of choices, our senior-level development crew rises above the rest by delivering the best solutions for fintech, cybersecurity, and other fast-growing industries. Check us out at shipshape.io.

          ...more
          View all episodesView all episodes
          Download on the App Store
          Whiskey Web and WhatnotBy Skill Issue Studios
          • 4.8
          • 4.8
          • 4.8
          • 4.8
          • 4.8

          4.8

          55 ratings

          More shows like Whiskey Web and Whatnot

          View all
          Planet Money by NPR

          Planet Money

          30,609 Listeners

          The Changelog: Software Development, Open Source by Changelog Media

          The Changelog: Software Development, Open Source

          288 Listeners

          ShopTalk by Chris Coyier & Dave Rupert

          ShopTalk

          500 Listeners

          Soft Skills Engineering by Jamison Dance and Dave Smith

          Soft Skills Engineering

          287 Listeners

          Syntax - Tasty Web Development Treats by Wes Bos & Scott Tolinski - Full Stack JavaScript Web Developers

          Syntax - Tasty Web Development Treats

          985 Listeners

          Darknet Diaries by Jack Rhysider

          Darknet Diaries

          8,077 Listeners