Attaching external RDBMS systems
KoreDB supports directly scanning from a variety of relational databases using the LOAD FROM statement.
Because RDBMSs are a common source of structured data, KoreDB provides a set of
extensions to allow users to both scan data from external RDBMSs without having to copy it
into KoreDB and also to simplify copying data from an external RDBMS into KoreDB.
The currently available relational database extensions are shown below:
| Extension Name | Description | Minimum Version |
|---|---|---|
duckdb | Scan from an attached DuckDB database | 0.10.0 |
postgres | Scan from an attached PostgreSQL database | 14.0 |
sqlite | Scan from an attached SQLite database | 3.3.0 |