ExcelToDatabase
mssql-cli
ExcelToDatabase | mssql-cli | |
---|---|---|
2 | 1 | |
47 | 1,340 | |
- | 0.4% | |
8.2 | 0.6 | |
8 days ago | 2 months ago | |
Python | Python | |
MIT License | BSD 3-clause "New" or "Revised" License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
ExcelToDatabase
-
Merging data from multiple Excel files
ExcelToDatabase - Automation tool for batch importing Excel files into MySQL/Oracle/SQL Server/PostgreSQL/Access/Hive/SQLite/Dameng database
-
ExcelToDatabase: batch import excel files into database
The source code on the Github.
mssql-cli
-
Has anyone used MSSQL with Flask or any other python framework?
I don't think this answers your question but here goes. I've used mssql-cli on a CentOS dev server at work pretty extensively and I haven't seen any performance issues with the exception of slow SQL passed to through to the DB.
What are some alternatives?
sqlglot - Python SQL Parser and Transpiler
sqltoolsservice - SQL Tools API service that provides SQL Server data management capabilities.
pysonDB - A Simple , ☁️ Lightweight , 💪 Efficent JSON based database for 🐍 Python. PysonDB-V2 has been released ⬇️
pgcli - Postgres CLI with autocompletion and syntax highlighting
data-profiling - a set of scripts to pull meta data and data profiling metrics from relational database systems
SQLMap - Automatic SQL injection and database takeover tool
TinyDB - TinyDB is a lightweight document oriented database optimized for your happiness :)
Python Fire - Python Fire is a library for automatically generating command line interfaces (CLIs) from absolutely any Python object.
notion-cli-list-manager - A simple command-line tool for managing Notion databases.
q - q - Run SQL directly on delimited files and multi-file sqlite databases
mycli - A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.