May 15, 2023
Ryan is an Advocate at Redgate focusing on PostgreSQL. Ryan has been working as a PostgreSQL advocate, developer, DBA, and product manager for more than 20 years, primarily working with time-series data on PostgreSQL and the Microsoft Data Platform.
Ryan is a long-time DBA, starting with MySQL and Postgres in the late ’90s. He spent more than 15 years working with SQL Server before returning to PostgreSQL full-time in 2018. He’s at the top of his game when he's learning something new about the data platform or teaching others about the technology he loves.
Topics of Discussion:
[1:23] Ryan’s background and his love of helping people with their data.
[6:06] What are some features of Postgres that really intrigued Ryan?
[6:12] What are some of the choices in the database world that people should be well versed in?
[11:00] Is there a marketplace for these extensions?
[15:00] Google, Amazon, Microsoft, and many others have been very interested over the last 3‒4 years in the open-source code base.
[15:50] Is there any environment or platform where Postgres can’t run?
[17:24] Can we use a downsized database engine?
[19:19] Ryan discusses Amazon Redshift.
[23:58] What’s the state of the modern Redgate tools?
[26:42] What are the top three tools developers should reach for?
[27:00] What are the features of Flyway?
Mentioned in this Episode:
Programming with Palermo — New Video Podcast! Email us at programming@palermo.network
Clear Measure, Inc. (Sponsor)
.NET DevOps for Azure: A Developer’s Guide to DevOps Architecture the Right Way, by Jeffrey Palermo — Available on Amazon!
Jeffrey Palermo’s Twitter — Follow to stay informed about future events!
Architect Tips — Video podcast!
Want to Learn More?
Visit AzureDevOps.Show for show notes and additional episodes.