chumaky/datero_engine repository overview

⁠About

Postgres database image with different foreign data wrapper (FDW) extensions installed. Multiple FDWs allow to execute Federated SQL over different by nature data sources within single SELECT statement.

Included FDWs:

• Oracle: oracle_fdw
• TDS (MSSQL & Sybase): tds_fdw
• Mysql: mysql_fdw
• Mongo: mongo_fdw
• Redis: redis_fdw
• SQLite: sqlite_fdw
• DuckDB: duckdb_fdw
• Postgres (built-in): postgres_fdw
• Flat Files (built-in): file_fdw

This approach is implemented in Datero⁠ data platform. It's built on top of postgres database image with multiple FDWs isntalled. It also provides GUI for setting up datasource connections and SQL editor. Without any coding you could quickly setup data hub and start exploring your data.

For docker source files, please check GitHub⁠ repo.