📄️ Importing Data
The first step to using a database system is to insert data into that system.
📄️ Data Sources
Goose sources several data sources, including file formats, network protocols and database systems:
🗃️ CSV Files
4 items
🗃️ JSON Files
10 items
🗃️ Multiply Files
2 items
🗃️ Parquet Files
4 items
🗃️ Partitioning Files
2 items
📄️ Appender
The Appender can be used to load bulk data into a Goose database. It is currently available in the C, C++, Go, Java and Rust APIs. The Appender is tied to a connection, and will use the transaction context of that connection when appending. An Appender always appends to a single table in the database file.
📄️ INSERT Statements
INSERT statements are the standard way of loading data into a relational database. When using INSERT statements, the values are supplied row-by-row. While simple, there is significant overhead involved in parsing and processing individual INSERT statements. This makes lots of individual row-by-row insertions very inefficient for bulk insertion.