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.