SQL vs NoSQL, Web Technologies, and Holiday Recap

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.