Skip to content

Latest commit

Β 

History

2 Commits

Folders and files

NameName
Last commit message
Last commit date
Β 
Β 
Β 
Β 

Repository files navigation

πŸ“‚ File-Based SQL Executor

A powerful command-line tool built in Python that enables users to import structured data files (CSV or TXT) into an SQLite database and execute SQL commands instantly. Designed for quick data exploration and transformation without requiring complex setup.

πŸš€ Features

  • πŸ“ Flexible File Import

    • Supports .csv and .txt file formats
    • User-defined delimiters (e.g., comma, tab) for customization
    • Automatically creates and populates SQLite tables based on file contents
  • πŸ’» Command-Line Interface

    • Easy-to-use terminal prompts for file selection, delimiter input, and SQL query execution
    • Clean and interactive CLI that guides the user through each step
  • πŸ›  SQL Execution Engine

    • Run custom SQL commands directly on the imported dataset
    • View results instantly
  • 🧹 Quick Error Handling

    • Validates file format, structure, and SQL syntax
    • Catches and reports exceptions (e.g., incorrect queries, missing files) with helpful messages
    • Prevents program crashes through error recovery

πŸ›  Technologies Used

  • Python 3
  • SQLite
  • CSV/TXT Handling
  • Exception Handling (try/except structures)

About

A database program that imports a CSV or Text File from the user and executes the requested SQL commands

Resources

Stars

0 stars

Watchers

1 watching

Forks

Releases

Packages

Contributors

Languages