Skip to content

macos application for viewing csv file via duckdb database, this one shows charts

Notifications You must be signed in to change notification settings

tusharxoxoxo/goodKnight

Repository files navigation

MacOS application, added .csv into duckdb and running queries on that, and creating charts of that

-> I have not included the .csv file, it was > 100 MB, for that i need to git lfs, that's why i have ignored uploading it to the github repo, i have excluded it in the .gitignore file

-> I have harded the exact location of .csv file in my machine, so for running this, u have update this https://github.com/tusharxoxoxo/goodKnight/blob/main/goodKnight/ExoplanetStore.swift line 161.

    161       let csvFileURL = URL(fileURLWithPath: "/(path)")
    //goodKnight/ExoplanetStore.swift

-> I've built a macOS application that uses DuckDB to query data from a local CSV file and generate charts. I based this application on the example iOS app provided in the DuckDB repository, which retrieves and visualizes exoplanetary data from an API.

image

-> While the example app works correctly, I'm encountering an issue when adapting it to query my local CSV file. When I run queries against the DuckDB database created from the CSV, I receive an unexpected error. I've searched online resources and the DuckDB documentation, but haven't found a solution. I suspect this might be a bug in DuckDB itself. To further debug this, I plan to contact the DuckDB team and potentially create an issue on their issue tracker.

image

About

macos application for viewing csv file via duckdb database, this one shows charts

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages