Q.Daten (qdaten) is a command line application enabling you to run SQL queries against a CSV file. It starts by converting your CSV file into a SQLite database, you can then run SQL queries against the database in either interative TUI or non-interative mode. You can also open existing SQLite databases.
Open CSV file with the delimiter set to ; in interative mode
qdaten example.csv --delimiter=";"Run query in non-interative mode
qdaten example.csv -c="SELECT * FROM table LIMIT 10" Open SQLite in interactive mode
qdaten example.db --file-type=sqlite" While inside the interactive terminal, there are a few built-in commands that you can run besides normal sql queries.
| Command | Result |
|---|---|
| exit | Exit interactive mode |
| .tables | Get a list of all tables |
| .save | Save to SQLite database file |
Pull requests are welcome. For major changes, please open an issue first to discuss what you would like to change.
Q.Daten is licensed under the Apache License, Version 2.0. See LICENSE for the full license text.