csvcatalog 1.5

tool for creating catalog from .csv tables in duckdb/sqlite storage

Catalog

Catalog made for wrangling CSV files and shoving them into a database. Makes the tedious task of managing CSV data a breeze. No more manual scripts, no more headaches

What's this? 🤔

Tired of messing around with CSVs and databases separately? Me too. That's why I built Catalog. It's a simple, no-nonsense tool that lets you:

• Import CSV files into a single SQLite database
• Manage your data with a set of easy-to-use commands
• Export your data back to CSV whenever you need it

Features 🔥

• Interactive CLI: A user-friendly interface that feels like you're chatting with a buddy
• CSV Parsing: Automatically handles CSV files, with options to customize the separator and headers
• Database Storage: Uses SQLite to store your data, so it's all in one place
• Data Management: A rich set of commands to manage your tables
• Data Export: Easily export your tables back to CSV files, with the ability to select specific columns and a limited number of rows

Getting Started 🚀

1. Install

pip install csvcatalog

2. Run the cli

csvcatalog

2.1 You can also specify a custom database file if you want:

csvcatalog --db /path/to/your/database.db

Commands 🕹️

Here's a quick rundown of the commands you'll be using

Commands

List of commands

• help: Shows you all the available commands
• clear: Clears the screen
• exit: Quits the application
• system <command>: Lets you run any shell command without leaving the CLI
• extract <file.csv>: Setup and process extraction data from csv table to database

Actions with database

• db <path_to_db>: Switches to a different database file
• tables: Lists all the tables in your database
• del <table_name>: Deletes a table
• purge: Wipes the entire database clean
• sql <stmt>: Executes a pure SQL statement on the database
• export <table_name>: Exports a table to a CSV file
• search <value> <opt: table_name.<opt: column>,<...>>: Search a value in table(s)
• search <value> *.<opt: column>,<...>: Search a value in all tables with n column (2nd example)

Redirect stdout (save command output to file):

You can redirect any stdout to specific file using default > symbol

search Germany geoip > florida_ips.txt

Contributing are welcome 🤝