This is a Java application that allows users to run SQL queries on CSV files
This is WIP, preview available here: https://icecoldaswin.github.io/csvsql/
The preview page queries an existing csv file (with random generated values).
csvql/csvsql$ gradle jar > Task :compileJava Note: Some input files use unchecked or unsafe operations. Note: Recompile with -Xlint:unchecked for details. BUILD SUCCESSFUL in 3s 2 actionable tasks: 2 executed csvql/csvsql$ ls build build.gradle gradle gradlew gradlew.bat local.properties README.md settings.gradle src test-output.vim csvql/csvsql$ ls build/libs/ csvql-1.0-SNAPSHOT.jar csvql/csvsql$ java -jar build/libs/csvql-1.0-SNAPSHOT.jar csvsql > select country, city from src/test/data/mycsv2.csv Task 'ParseCommand' completed in 9 milli seconds. city state country ------------------------------------------------ INDIA Nellore INDIA Hyderabad INDIA Chennai INDIA Bengaluru INDIA Trivandrum United States of America Bellevue United States of America Las Vegas Rows processed: 7. Task 'StreamData' completed in 24 milli seconds. csvsql > ^C I'm starting with simple SELECT statements, run on one CSV file (no joins as of yet).
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
Please make sure to update tests as appropriate.