Skip to content

CSV Storage

Introducing CSVStorage: a utility to process *.csv files, enabling SQL-like query operations such as SELECT, INSERT, and UPDATE.

Key Features:

  1. SQL Queries on CSV: Directly parse and operate on *.csv files using familiar SQL query operations.

  2. Optional Schema Support: An associated schema can be provided for each CSV file. For instance, for a data file named Book.csv, its corresponding schema file should be named Book.sql.

  3. If an associated schema file is found, it will be read and applied.

  4. In the absence of a schema file, the first row of the data file will be treated as column headers and all column types will default to TEXT.

  5. Type Info File for Schemaless Data: An auxiliary types file (*.types.csv) can be used to support data type recognition for schemaless data.

  6. For a CSV data file named Book.csv, its corresponding types file will be Book.types.csv.
  7. The types file will have a 1:1 mapping with the CSV data file entries, specifying the data type for each entry in alignment with the GlueSQL conventions.