Postgres Data Warehouse with Josh Drake and Thomas Richter

A data warehouse is a centralized repository that an enterprise may use to store selected data from production systems. Data is transformed into a structured form that makes it easily accessible for business intelligence or other operational users. SQL-compliant databases are frequently used for data warehouses due to the popularity of SQL as a tool in business data analytics.

PostgreSQL is a free and open-source relational database management system. Postgres-based databases are widespread and are used by a variety of organizations, from Reddit to the International Space Station, and Postgres databases are a common offering from cloud providers such as AWS, Alibaba Cloud, and Heroku. 

Josh Drake and Thomas Richter are experts on Postgres data warehousing. They join the show today to talk about the staying power of Postgres, why Postgres is a good choice for data warehousing, and how cloud technology is changing relational database management systems.

Sponsorship inquiries: sponsor@softwareengineeringdaily.com

Transcript

Transcript provided by We Edit Podcasts. Software Engineering Daily listeners can go to weeditpodcasts.com/sed to get 20% off the first two months of audio editing and transcription services. Thanks to We Edit Podcasts for partnering with SE Daily. Please click here to view this show’s transcript.


Sponsors

Imagine if you could search ALL your code, across every repo, every language, every code host. You can with Sourcegraph universal code search. Quickly navigate code with contextual hover tool tips that show definitions, references, and usage examples. Construct complex queries and filter code in ways that IDEs and code hosts can’t. Find and fix code fast, without losing your flow. Sourcegraph universal code search is a dev’s superpower. Get it now at info.sourcegraph.com/sedaily

From their recent report on serverless adoption and trends, Datadog found half of their customer base using EC2s have now adopted AWS Lambda. You can easily monitor all your serverless functions in one place and generate serverless metrics straight from Datadog. Check it out yourself by signing up for a free 14-day trial and get a free t-shirt at softwareengineeringdaily.com/datadog

Come help Granicus build a new product vision, enabling local governments to help manage the short-term rental landscape in their community. We offer an engaging, modern technical stack: built with AWS, containers, python, and GraphQL. As a lead member of the Granicus team, you’ll be leveraging your skills as a technologist to build flexible, extendable solutions across our compliance platform. These features will directly impact our customer’s ability to address problems within their community as it relates to the short-term rental industry. If you are a product-focused engineer with experience building web applications in Python, search and apply at https://granicus.com/sedaily.

Our friends at Flatfile are working on Concierge, which offers no-code, collaborative workspaces for onboarding data. Invite customers to securely import, format, or merge spreadsheet data. No fumbling with FTP uploads, emailing sensitive Excel files back and forth, or formatting yet another CSV template. Flatfile is on a mission to help companies spend less time formatting spreadsheet data, and more time using it. Curious of how they can help your business? Visit: softwareengineeringdaily.com/flatfile

 

Software Weekly

Software Weekly

Subscribe to Software Weekly, a curated weekly newsletter featuring the best and newest from the software engineering community.