CSV2SQLite: Building a database with SQLite using the UNESCO Intangible Cultural Heritage (ICH) dataset as an example.

Table of Contents

• Project Overview
• Installation
• Usage
• Acknowledgements

Project Overview

The UNESCO Intangible Cultural Heritage (ICH) dataset is a collection of valuable cultural heritage information in mostly text form. This project showcases how to create an SQLite database from CSV files, import data into the database, and perform basic SQL operations.

Key features of the project:

• Safe CSV data to a C struct
• Import the struct into SQLite
• Search and query the database

The dataset can be found on kaggle.com.

Installation

1. Clone the repository

  git clone https://github.com/3lle4/CSV2SQLite

2. Navigate to the folder

    cd src

3. Compile the code

    ./compile main.c

Usage

Use the given code to create a database from a CSV file and explore it with the given functions. Currently the following features are implemented:

• Creating a database
• Creating a table (from CSV file)
• Formatting the data types of columns
• Browsing and output of values

Acknowledgements

• C Tutorial on tutorialspoint.com
• SQLite Tutorial on tutorialspoint.com
• SQLite Tutorial from zetcode.com
• another SQLite Tutorial, algoLancer at YouTube