Whiskey Web and Whatnot: Web Development, Neat

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.

          See Privacy Policy at https://art19.com/privacy and California Privacy Notice at https://art19.com/privacy#do-not-sell-my-info.

          ...more
          View all episodesView all episodes
          Download on the App Store

          Whiskey Web and Whatnot: Web Development, NeatBy RobbieTheWagner and Charles William Carpenter III, The Radcast Network

          • 4.8
          • 4.8
          • 4.8
          • 4.8
          • 4.8

          4.8

          53 ratings


          More shows like Whiskey Web and Whatnot: Web Development, Neat

          View all
          The Changelog: Software Development, Open Source by Changelog Media

          The Changelog: Software Development, Open Source

          284 Listeners

          Software Engineering Daily by Software Engineering Daily

          Software Engineering Daily

          624 Listeners

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

          Syntax - Tasty Web Development Treats

          986 Listeners

          REWORK by 37signals

          REWORK

          209 Listeners

          The freeCodeCamp Podcast by freeCodeCamp.org

          The freeCodeCamp Podcast

          484 Listeners

          CoRecursive: Coding Stories by Adam Gordon Bell - Software Developer

          CoRecursive: Coding Stories

          190 Listeners

          Practical AI by Practical AI LLC

          Practical AI

          188 Listeners

          The Stack Overflow Podcast by The Stack Overflow Podcast

          The Stack Overflow Podcast

          63 Listeners

          Last Week in AI by Skynet Today

          Last Week in AI

          298 Listeners

          Dwarkesh Podcast by Dwarkesh Patel

          Dwarkesh Podcast

          425 Listeners

          Big Technology Podcast by Alex Kantrowitz

          Big Technology Podcast

          456 Listeners

          PodRocket - A web development podcast from LogRocket by LogRocket

          PodRocket - A web development podcast from LogRocket

          57 Listeners

          How About Tomorrow? by Adam Elmore & Dax Raad

          How About Tomorrow?

          20 Listeners

          Latent Space: The AI Engineer Podcast by swyx + Alessio

          Latent Space: The AI Engineer Podcast

          71 Listeners

          The Pragmatic Engineer by Gergely Orosz

          The Pragmatic Engineer

          62 Listeners