40: Edd Mann - You Should Switch to Postgres

FromFull Stack Radio

Start listening View podcast show

40: Edd Mann - You Should Switch to Postgres

FromFull Stack Radio

ratings:

Length:

52 minutes

Released:

Apr 19, 2016

Format:

Podcast episode

Description

In this episode, Adam talks to Edd Mann, host of Three Devs and a Maybe, about the advantages of using PostgreSQL over MySQL, common obstacles people running into when switching to Postgres, and deciding when to push work into the database instead of doing it in code.

Released:

Apr 19, 2016

Format:

Podcast episode

Titles in the series (100)

A podcast for developers interested in building great software products. Every episode, Adam Wathan is joined by a guest to talk about everything from product design and user experience to unit testing and system administration.

Skip carousel

6: Chris Fidao - Servers for Hackers: In this episode, Adam talks with Chris Fidao of Userscape. They talk about things every web developer should know about server administration, platform-as-a-service vs. self-hosting, Ansible, Docker, and more. by Full Stack Radio
42 min listen
16: Kent Beck - Tiny Decisions and Emergent Design: In this episode, Adam talks to Kent Beck about Smalltalk vs. Java, low level design vs. big picture architecture, planning for the future vs. emergent design, and applying the principles of Extreme Programming in 2015. This episode is brought to you by H by Full Stack Radio
46 min listen
26: Josh Pigford - What do you need when you launch?: In this episode, Adam talks to Josh Pigford, founder of Baremetrics, about what you should have ready when you start a SaaS business. They also talk about how most businesses aren't doing as well as you think, content marketing, the benefits of different by Full Stack Radio
32 min listen
20: Ian Landsman - Code is not a business: In this episode, Adam talks to Ian Landsman, founder of Userscape and creator of HelpSpot. Ian talks about the biggest mistakes programmers make when trying to start their own business, where to find new ideas, and why your new software product shouldn't by Full Stack Radio
71 min listen
21: Chad Pytel - Sticking to your guns: In this episode, Adam talks to Chad Pytel, CEO of thoughtbot. Chad gives tips for balancing client work with internal product work, growing your client-base without compromising your principles, and applying Jobs to be Done to new client projects. This e by Full Stack Radio
49 min listen
12: Jack McDade - Building Photoshoot.io and Getting Stuff Done: In this episode, Adam talks to Jack McDade creator of Statamic, about building his latest project Photoshoot.io. They also talk about how Jack juggles design and development, and how to buckle down and get things done. This episode is brought to you by H by Full Stack Radio
49 min listen
8: Sean Devine - Ember and API first: In this episode, Adam talks with Sean Devine, host of the Ruby on Rails podcast. Sean gives Adam an introduction to building applications with Ember, and how it's different than the way you might sprinkle AngularJS into a mostly server-side app. They talk by Full Stack Radio
58 min listen
1: Matt Stauffer - CSS Semantics: In our very first episode, Adam talks with Matt Stauffer of Tighten Co about OOCSS, BEM, SMACSS, preprocessors, common architecture pitfalls, and CSS semantics. by Full Stack Radio
49 min listen
4: Alex Bilbie - OAuth 2 and API Security: In this episode, Adam gets super technical with Alex Bilbie about the OAuth 2 specification. They talk about the different grant types and what they're each appropriate for, as well as discuss some potential API security strategies for one of Adam's perso by Full Stack Radio
56 min listen
13: Phil Sturgeon - Designing and Testing APIs, Go and PHP 7: In this episode, Adam talks to Philip J. Sturgeon about designing and testing APIs at Ride. They also talk about building microservices with Go, and some of the new features coming in PHP 7. This episode is brought to you by Hired. by Full Stack Radio
75 min listen
7: Shawn McCool - BDD and DDD: In this episode, Adam talks with Shawn McCool about Behavior Driven Development and Domain Driven Design. They talk about how you can use these ideas to better understand your clients' needs and to build software that closely models their business. They a by Full Stack Radio
61 min listen
28: Jeffrey Way and Dave Marshall - "Don't mock what you don't own": In this episode, Adam talks to recurring guests Jeffrey Way and Dave Marshall about "don't mock what you don't own". They talk about how to design code that needs to work with external services, how you should test that code, and the pitfalls you run into by Full Stack Radio
58 min listen
2: Eric Barnes - Wardrobe, Javascript and Writing: In this episode, Adam talks with Eric Barnes of Userscape about rebuilding WardrobeCMS, trends in Javascript development, and building an audience. by Full Stack Radio
40 min listen
9: David Heinemeier Hansson - Architecture, Patterns and Design: In this episode, Adam talks with David Heinemeier Hansson, partner at Basecamp and creator of Ruby on Rails. They talk about the pursuit of "purity", Domain Driven Design, ActiveRecord vs DataMapper, and developing an eye for "good code". by Full Stack Radio
53 min listen
10: Type Safety Roundtable with Ryan Tablada and Matt Machuga: In this episode, Adam talks with Ryan Tablada and Matt Machuga about the philosophical differences between programming in a statically typed language vs. a dynamically typed language. They talk about things like explicit interfaces vs. duck typing, functi by Full Stack Radio
70 min listen
5: Ryan Singer - Jobs-to-be-Done and Product Design: In this episode, Adam talks with Ryan Singer of Basecamp about Jobs-to-be-Done thinking, UX, and product design. by Full Stack Radio
47 min listen
23: Chris Hunt - How GitHub does remote work: In this episode, Adam talks to the Healthy Hacker, Chris Hunt, about how his team at GitHub works remotely. They also talk about entertaining your audience at conferences, taking a Codecation, and adventure motorcycling. This episode is brought to you by by Full Stack Radio
38 min listen
30: Evan You - Diving Deep into Vue.js: In this episode, Adam talks to Evan You, the creator of Vue.js. Evan talks about his time at Google Creative Lab and the sort of work that inspired him to create Vue. He also explains in depth how data binding works in Vue, and how it's different and more by Full Stack Radio
37 min listen
43: Jonathan Snook - Managing Complexity, Design Systems, and Container Queries: In this episode, Adam talks to Jonathan Snook, author of SMACSS, about finding the balance between utility and component driven CSS approaches, design systems engineering, and using container queries to build better responsive web experiences. by Full Stack Radio
67 min listen
19: Dave Marshall - Designing Effective Tests: In this episode, Adam talks to Dave Marshall, testing guru and host of That Podcast. Dave talks to Adam about the upcoming Mockery 1.0 release and some interesting API changes destined for 2.0. They also talk about how fakes can improve your tests, fixtur by Full Stack Radio
70 min listen
11: Jeffrey Way - "But how does it feel?": In this episode, Adam talks with Jeffrey Way of Laracasts about learning, object oriented design, testing, API usability, and whole bunch of other stuff. This episode is brought to you by Hired. by Full Stack Radio
68 min listen
17: Adam Culp - Maximizing Your Conference Experience: In this episode, Adam talks to Adam Culp, organizer of Sunshine PHP and ZendCon. They talk about how to get into conference speaking, how to make the most of a conference as an attendee, as well as tips for running a great local user group. This episode by Full Stack Radio
46 min listen
3: Matt Machuga - Ruby, PHP, object oriented design, testing and other crap: In this episode, Adam talks with Matt Machuga of Think Through Math about being a Rubyist who still writes PHP and the differences between writing PHP like a Rubyist vs. writing PHP like a Java developer. They also talk about common struggles when learnin by Full Stack Radio
62 min listen
29: Mark Otto - Bootstrap 4 and CSS architecture at scale: In this episode, Adam talks to Mark Otto, creator of Bootstrap and director of design at GitHub. They talk about the brand new alpha release of Bootstrap 4 and some of the most significant changes. They also talk about choosing units, when to use utility by Full Stack Radio
48 min listen
51: Matt Wynne - Building the Right Thing with BDD: In this episode, Adam talks to Matt Wynne about Behavior Driven Development with Cucumber. Topics include: What exactly is BDD? Is BDD a technical or non-technical practice? How do you get started with BDD? How do you keep the number of system tests lo by Full Stack Radio
65 min listen
38: J.B. Rainsberger - Unit Testability and the Universal Architecture: In this episode, Adam talks to J.B. Rainsberger about how to keep your adapter layer thin, designing unit testable code, and the importance of paying attention to how your code is changing vs. how your code looks today. This episode is brought to you by by Full Stack Radio
65 min listen
32: DHH - Building Basecamp 3 like a Porsche 911: DHH returns to the podcast to talk in-depth about how Basecamp 3 is designed and implemented! Topics include: Why Basecamp is a "majestic monolith", and the impact of organizational shape and size on technical decision making in product development How by Full Stack Radio
63 min listen
18: Katie Cerar - Designing and Prototyping for Clients: In this episode, Adam talks to Katie Cerar, user experience designer at Boltmade. Katie talks to Adam about running a successful kick off meeting, understanding the problems your client is trying to solve, and strategies for getting clients to keep their by Full Stack Radio
40 min listen
40: Edd Mann - You Should Switch to Postgres: In this episode, Adam talks to Edd Mann, host of Three Devs and a Maybe, about the advantages of using PostgreSQL over MySQL, common obstacles people running into when switching to Postgres, and deciding when to push work into the database instead of doin by Full Stack Radio
52 min listen
39: Michael Feathers - First Class Error Handling, Tell Don't Ask, and Collection Pipelines: In this episode, Adam talks to Michael Feathers, author of Working Effectively with Legacy Code, about strategies for writing cleaner error handling code, the "tell don't ask" principle, and transforming data with collection pipelines. by Full Stack Radio
59 min listen

More Episodes from Full Stack Radio

Skip carousel

152: Ben Orenstein - How to Stand Out When Applying for a Job at a Small Company: In this episode Adam talks to Ben Orenstein about what you can do to stand out if you’re trying to get a job at a small company. by Full Stack Radio
48 min listen
151: DHH – Building HEY with Hotwire: In this episode Adam talks to DHH about using Hotwire to develop Basecamp's new email service HEY while shipping only 40kb of JavaScript to the client. by Full Stack Radio
74 min listen
150: Secret Screencasting Tips & Behind the Scenes of Tailwind CSS 2.0: In this episode, Adam and Jack talk about all the secret tips you need to know to screencast like a pro. Then they go deep into some of the things Adam is working on for Tailwind CSS 2.0, like the new default config file. by Full Stack Radio
59 min listen
149: Choosing a Payment Processor, Radical Icons & W3C Hype: Adam and Jack discuss how it sucks when you're forced to change billing platforms, and embark upon a deep dive on the merits of Adam's favorite solutions. We also talk about Jack's recent Radical Icon launch and promotional strategy regrets, which thankfu by Full Stack Radio
57 min listen
148: Accessible Focus Styles, Tailwind Labs on YouTube, and Secret Projects: Adam and Jack talk about accessible focus styles, Headless UI, the new Tailwind Labs YouTube channel, Tailwind presets, and the progress on the great Statamic Bug-Fix-a-Thon of 2020. They also kick around what "Tailwind Lite" could be and where it might l by Full Stack Radio
60 min listen
147: Surviving GitHub Issues, the Statamic 3 Launch Aftermath, Tailwind 1.8, and Headless UI: Adam and Jack talk about strategies for keeping up with GitHub issues and coping with customer criticism, and how life is going after the Statamic 3 launch. They also talk about the new features in Tailwind 1.8, and work through some branding problems for by Full Stack Radio
80 min listen
146: Launching Statamic 3, GitHub Sponsors, Tailwind CSS v1.7, and Preparing for Laracon: Adam and Jack talk about how the Statamic 3 launch went, and adding GitHub Sponsor tiers to the Statamic GitHub organization and what to give people in exchange for sponsoring. They also talk about the new Tailwind CSS v1.7 release, and the new features l by Full Stack Radio
81 min listen
145: Statamic 3.0 and Tailwind CSS 2.0: Jack McDade joins Adam to talk about what he's been up to building up to the Statamic 3.0 launch (it's out now!) and Adam shares a bunch of ideas he's been working on for Tailwind CSS v2.0. by Full Stack Radio
76 min listen
144: Gary Bernhardt - TypeScript and Testing: In this episode, Adam talks to Gary Bernhardt about building Execute Program, why he chose to build it as a full-stack TypeScript application, and the implications using TypeScript has on what you need to test. by Full Stack Radio
85 min listen
143: Rich Harris - Svelte and Defending the Modern Web: In this episode, Adam talks to Rich Harris about Svelte, and why we should keep pushing forward with the modern web even if it's not perfect yet. by Full Stack Radio
76 min listen
142: Jason Cohen - Learning to Hire and Manage a Team: In this episode, Adam talks to Jason Cohen of WP Engine about hiring people to join the Tailwind team, figuring out what to focus on, and learning how to manage. by Full Stack Radio
55 min listen
141: Jason Fried - Running the Tailwind Business on Basecamp: In this episode, Adam talks to Jason Fried about growing the Tailwind team and how to best use Basecamp to keep his particular company organized. He also walks through tons of real examples from their recent work on HEY, sharing lots of behind-the-scenes stuff about how Basecamp use Basecamp themselves. by Full Stack Radio
67 min listen
140: Evan You - Reimagining the Modern Dev Server with Vite: In this episode, Adam is talks to Evan You about Vite, a new dev server and build tool for modern JavaScript projects. by Full Stack Radio
48 min listen
139: Alex DeBrie - DynamoDB for Relational Database Diehards: In this episode, Adam is talks to Alex DeBrie about DynamoDB, and how it compares to relational databases like MySQL. by Full Stack Radio
59 min listen
138: Tom Preston-Werner - Building Full-Stack JS Apps with Redwood.js: In this episode, Adam is talks to Tom Preston-Werner about Redwood.js, a new full-stack JavaScript framework for building edge-ready web applications. by Full Stack Radio
73 min listen
137: Tim Neutkens - Continuing to Innovate with Next.js 9.3: In this episode, Adam is talks to Tim Neutkens about what's new in Next.js 9.3 and how it's changing the way applications are built at ZEIT. by Full Stack Radio
83 min listen
136: Michael Chan - React Is Not a Rails Competitor: In this episode, Adam is joined by Michael Chan to talk about how people who identify as React developers are building real web applications, and why it seems like nobody is talking about databases or background jobs anymore. by Full Stack Radio
68 min listen
135: Lessons Learned Building Tailwind UI: In this episode, Adam is joined by Sam Selikoff to talk about some of the interesting technical challenges he faced building Tailwind UI, and how working on the project has influenced how he will build layouts in the future. by Full Stack Radio
98 min listen
134: Mark Dalgleish - You Should Be Using Layout Components: In this episode, Adam talks to Mark Dalgleish about common mistakes people make in their approach to constructing layouts, and how dedicated layout components can make your component system much easier to work with. by Full Stack Radio
57 min listen
133: Sam Selikoff - Building Production-Ready SPAs Fast with Mirage.js: In this episode, Adam talks to Sam Selikoff about Mirage.js and how to use it to build production-ready front-end applications, even if your back-end API isn't ready yet. by Full Stack Radio
63 min listen
132: Caleb Porzio - Just Enough JavaScript with Alpine.js: In this episode, Adam talks to Caleb Porzio about his new UI library Alpine.js. by Full Stack Radio
86 min listen
131: Ryan Singer - How Basecamp Builds Software: In this episode, Adam talks to Ryan Singer of Basecamp about how they plan, structure, and execute on new features. by Full Stack Radio
73 min listen
130: David Khourshid - Building Better UI Components with State Machines: In this episode, Adam talks to David Khourshid about using state machines to build UI components that are simpler and more resilient to bugs. by Full Stack Radio
54 min listen
129: Evan You - What's Coming in Vue.js 3.0: In this episode, Adam talks to Evan You about all of the changes and improvements coming to Vue.js 3.0. by Full Stack Radio
78 min listen
128: Alasdair Monk - Scaling CSS at Heroku with Utility Classes: In this episode, Adam talks to Alasdair Monk about how they approach CSS at Heroku, and how using a utility-based approach has kept their team happy for the last three years. by Full Stack Radio
61 min listen
127: Jonathan Reinink - Building Modern Monoliths with Inertia.js: In this episode, Adam talks to Jonathan Reinink about Inertia.js, a new framework he recently released that lets you build single page applications with Vue, React, or Svelte, without having to give up the productivity benefits of traditional server-side by Full Stack Radio
96 min listen
126: James Long - Building Distributed Local-First JavaScript Applications: In this episode, Adam talks to James Long (creator of Prettier) about building Actual, a local-first Electron application with no central database that syncs data peer-to-peer. by Full Stack Radio
61 min listen
125: Rob Walling - Choosing the Right Product Idea: In this episode, Adam talks to Rob Walling about choosing, validating, and marketing a viable software product. by Full Stack Radio
55 min listen
124: Leslie Cohn-Wein & Rafael Conde - Designing the User Interface at Netlify: In this episode, Adam talks to Leslie Cohn-Wein and Rafael Conde about designing and implementing new UI features at Netlify. by Full Stack Radio
56 min listen
123: Ian Landsman - Marketing and Positioning a New Tailwind CSS Product: In this episode, Adam gets some advice from Ian Landsman of Userscape on marketing and positioning a new Tailwind CSS components directory project he's working on with Steve Schoger. by Full Stack Radio
66 min listen

Related podcast episodes

Skip carousel

Episode 454: RR 446: Development Environments by Ruby Rogues
59 min listen
Episode 446: RR 438: Deviating from the Rails Core by Ruby Rogues
43 min listen
Episode 23: Most Likely to be Misunderstood: The Myth of Cloud Agnosticism: It is easy to pick apart the general premise of Cloud agnosticism being a myth. What about reasonable use cases? Well, generally, when you have a workload that you want to put on multiple Cloud providers, it is a bad idea. It’s difficult to build and main by Screaming in the Cloud
36 min listen
Episode 421: RR 413: When Your Tools Interrupt Your Coding Process by Ruby Rogues
67 min listen
No Handwaving Away the DBA: There's a great quote I read, at the end of this article. It says: "...if you think that switching to NoSQL will just let you hand-wave away all of the challenges of running a database, you are terribly misguided." The context is that all too... by Voice of the DBA
3 min listen
How long does good code last?: This week we chat about the half-life of the software you create. Why does some get refactored after six weeks while another program goes untouched for years? How do you know when it's time to say goodbye to your codebase and try a new architecture? by The Stack Overflow Podcast
21 min listen
Ahmed Elsamadisi, Narrator CEO, is a roboticist by training and one of the first engineers at WeWork. Now he's changing how the world tells stories with data. by AI and the Future of Work
52 min listen
[MINI] Parallel Algorithms: When computers became commodity hardware and storage became incredibly cheap, we entered the era of so-call "big" data. Most definitions of big data will include something about not being able to process all the data on a single machine. Distributed... by Data Skeptic
21 min listen
112: Responsive Images Get Real: Mat Marquis, chair of the W3C Responsive Images Community Group, sits down with Zeldman to discuss guidelines for responsive images in multi-device design. by The Big Web Show
61 min listen
34: Matt Machuga - Dealing with Dependencies in Active Record Models: In this episode, Matt Machuga of Think Through Math returns to talk with Adam about design options when you find yourself wanting access to a collaborator in an Active Record or Eloquent model. They discuss the pros and cons of four specific designs, and by Full Stack Radio
39 min listen
Vertical Scaling vs. Horizontal Scaling for the Non-technical listener: Alan and Jim talk about the ins and outs of making applications run faster and scale to handle lots of users by Private Equity Funcast
54 min listen
915: The Story Behind Nasuni & How to Get Your Cloud Ready For AI by The Tech Talks Daily Podcast
47 min listen
JavaScript needs a model layer by Frontend First
43 min listen
Episode 403: JSJ 398: Node 12 with Paige Niedringhaus by JavaScript Jabber
65 min listen
Unleash The Power Of Dataframes At Any Scale With Modin: An interview with Devin Petersohn about his work on Modin to make scaling Pandas workflows effortless from a single laptop to an entire datacenter. by The Python Podcast.__init__
39 min listen
This week Al and Ahmed Elsamadisi discuss autonomous cars, exoskeletons, the Iron Man Suit, We Work, and Narrator by Making Data Simple
44 min listen
Episode 420: RR 412: Asynchronous Jobs on Client Side and Server Side by Ruby Rogues
50 min listen
Episode 13: Serverlessly Storing my Dad Jokes in a Dadabase: Aurora, from Amazon Web Services (AWS), is a MySQL-compatible service for complex database structures. It offers capabilities and opportunities. But with Aurora, you’re putting a lot of trust in AWS to “just work” in ways not traditional to relational dat by Screaming in the Cloud
34 min listen
The Cloudcast (.net) #72 - Cloud-Enabling Memcached and Redis for NoSQL: Brian talks with Ofer Bengal (Co-Founder/CEO @Garantiadata) about the challenges and realities of NoSQL databases in the cloud and the value of cloud-enabling services such as Memcached and Redis. We also talked about backing up NoSQL databases and the... by The Cloudcast
19 min listen
331: Why Computers Suck: How learning OpenBSD makes computers suck a little less, How Unix works, FreeBSD 12.1 Runs Well on Ryzen Threadripper 3970X, BSDCan CFP, HardenedBSD Infrastructure Goals, and more. by BSD Now
70 min listen
Postgres.js: with Rasmus Porsager by JS Party: JavaScript, CSS, Web Development
50 min listen
Moving up a level of abstraction with serverless on MongoDB Atlas and AWS by The Stack Overflow Podcast
26 min listen
25: Matt Machuga - Tips and tricks to make your code awesome: In this episode, Adam talks to recurring guest Matt Machuga about tips and tricks that lead to better code. They talk about bringing functional programming concepts to OO, simple patterns for cleaning up typical MVC web app code, and about how imposing c by Full Stack Radio
50 min listen
Building Your Data Warehouse On Top Of PostgreSQL: An interview about how you can build your data warehouse on top of PostgreSQL for flexibility and full control over your data. by Data Engineering Podcast
75 min listen
544: Valid in a Marco Way: Casey attempts to submit his app to the App Store. by Accidental Tech Podcast
144 min listen
Performance Engineering on Hard Mode with Andrew Hunter: Andrew Hunter makes code really, really fast. Before joining Jane Street, he worked for seven years at Google on multithreaded architecture, and was a tech lead for tcmalloc, Google’s world-class scalable malloc implementation. In this episode, Andrew and Ron discuss how, paradoxically, it can be easier to optimize systems at hyperscale because of the impact that even miniscule changes can have. Finding performance wins in trading systems—which operate at a smaller scale, but which have bursty, low-latency workloads—is often trickier. Andrew explains how he approaches the problem, including his favorite profiling techniques and tools for visualizing traces; the unique challenges of optimizing OCaml versus C++; and when you should and shouldn’t care about nanoseconds. They also touch on the joys of musical theater, and how to pass an interview when you’re sleep-deprived. by Signals and Threads
56 min listen
The All-Mac Edition: The Episode For Mac-Curious Attorneys by New Solo
85 min listen
Unleashing the Power of Postgres with Andrew Atkinson by Remote Ruby
50 min listen
33: David Hemphill - Building PushSilver with Vue.js and Beard: In this episode, Adam talks to David Hemphill about his latest project PushSilver. Topics include: Deciding when to build something yourself vs. paying for something off the shelf Choosing a Javascript framework for more traditional server rendered app by Full Stack Radio
43 min listen
S17:E9 - What are some database architectures and their use cases (Kyle Bernhardy): Time to dive deep into databases by CodeNewbie
49 min listen

Discover this podcast and so much more

40: Edd Mann - You Should Switch to Postgres

40: Edd Mann - You Should Switch to Postgres

Description

Titles in the series (100)

More Episodes from Full Stack Radio

Related podcast episodes