article thumbnail

Building Your Data Warehouse On Top Of PostgreSQL

Data Engineering Podcast

If you want to build a warehouse that gives you both control and flexibility then you might consider building on top of the venerable PostgreSQL project. How would you categorize the different systems and what is PostgreSQL’s position in that ecosystem? Links PostgreSQL Podcast Episode Swarm64 Podcast Episode Command Prompt Inc.

article thumbnail

Citus Data: Distributed PostGreSQL for Big Data with Ozgun Erdogan and Craig Kerstiens - Episode 13

Data Engineering Podcast

Summary PostGreSQL has become one of the most popular and widely used databases, and for good reason. In this episode Ozgun Erdogan, the CTO of Citus, and Craig Kerstiens, Citus Product Manager, discuss how the company got started, the work that they are doing to scale out PostGreSQL, and how you can start using it in your environment.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Data Classification: A Step-by-Step Guide

Monte Carlo

Let’s walk through how to build this system step by step, using PostgreSQL examples to make it real and actionable. Once youve got a good grip on whats in your database and what counts as sensitive, youre ready to start digging into PostgreSQL. You can even book a demo with just an email. What sensitive data does it hide?

article thumbnail

PostgreSQL vs. MySQL: 10 Key Differences 

Meltano

PostgreSQL and MySQL are among the most popular open-source relational database management systems (RDMS) worldwide. For all of their similarities, PostgreSQL and MySQL differ from one another in many ways. That’s because MySQL isn’t fully SQL-compliant, while PostgreSQL is.

article thumbnail

Inside Agoda’s Private Cloud - Exclusive

The Pragmatic Engineer

Agoda is a leading online travel booking platform in Asia. It’s owned by Booking Holdings Inc, which also owns the popular travel sites, Kayak and Booking.com. For transactional databases, it’s mostly the Microsoft SQL Server, but also other databases like PostgreSQL, ScyllaDB and Couchbase.

Cloud 251
article thumbnail

Building a Kimball dimensional model with dbt

dbt Developer Hub

Part 1: Setup dbt project and database ​ Step 1: Install project dependencies ​ Before you can get started: You must have either DuckDB or PostgreSQL installed. Choose one, and download and install the database using one of the following links: Download DuckDB Download PostgreSQL You must have Python 3.8

Building 145
article thumbnail

Data News — Week 24.30

Christophe Blefari

He his currently writing his second book about data modeling. Snowflake brings seamless PostgreSQL and MySQL — It has been announce at the Snowflake summit, now you can directly ingest Postgres and MySQL from Snowflake UI, removing the need of any other tool for these sources. This articles tries to explain why and what to do.

MySQL 130