database

pg_parquet: Copy from/to Parquet files in PostgreSQL

Summary: pg_parquet is a PostgreSQL extension that allows you to read and write Parquet files.

Continue reading

pgCompare: A multi-database data comparison tool

Summary: pgCompare is a straightforward utility crafted to simplify the data comparison process, providing a robust solution for comparing data across various database platforms.

Continue reading

pg_duckdb: Unleashing PostgreSQL for Analytics with DuckDB Integration

Summary: pg_duckdb is a PostgreSQL extension that embeds DuckDB’s columnar-vectorized analytics engine and features into PostgreSQL.

Continue reading

parquet_s3_fdw: PostgreSQL Foreign Data Wrapper for Parquet S3

Summary: The parquet_s3_fdw extension is a Foreign Data Wrapper (FDW) for accessing Parquet file on local file system and Amazon S3.

Continue reading

duckdb_fdw: PostgreSQL Foreign Data Wrapper for DuckDB

Summary: duckdb_fdw is a foreign data wrapper (FDW) to connect PostgreSQL to DuckDB database file.

Continue reading

mysql_fdw: Foreign Data Wrapper for MySQL

Summary: mysql_fdw is a PostgreSQL extension, which implements a Foreign Data Wrapper (FDW) for MySQL.

Continue reading

Why PostgreSQL?

PostgreSQL is an open source relational database system that supports complex query optimization, triggers, stored procedures, and functions. It has gained a good reputation for openness, feature richness, user-friendliness, and more.

Continue reading

Leaving MySQL

Today was my last day at Oracle, and thus also in the MySQL team. When a decision comes to switch workplaces, there’s always the question of “why”, but that question always has multiple answers, and perhaps the simplest one is that I found another opportunity, and and as a whole, it was obvious it was time to move on when that arrived. But it doesn’t really explain why I did go looking for that somewhere else in the first place.

Continue reading