SQL vs NoSQL, Web Technologies, and Holiday Recap
Whiskey Web and Whatnot · Skill Issue Studios
Audio is streamed directly from the publisher (op3.dev) as published in their RSS feed. Play Podcasts does not host this file. Rights-holders can request removal through the copyright & takedown page.
Show Notes
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
Subscribe and stay in touch
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.