sqltoolsservice
mssql-cli
| sqltoolsservice | mssql-cli | |
|---|---|---|
| 3 | 1 | |
| 424 | 1,340 | |
| 2.8% | 0.4% | |
| 9.3 | 0.6 | |
| 6 days ago | 3 months ago | |
| C# | Python | |
| GNU General Public License v3.0 or later | 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.
sqltoolsservice
-
Neovim as an alternative to SSMS or Azure Data Studio - is it a pipe dream?
The state of mssql support in text editors is not very good as far as I've seen. I think the shortest path would be getting sqltoolservice working, but there are some bumps in the emacs attempt. (For instance, I can't get completions to work at all).
-
I have been using the SPX as my main machine for two months...
I have found a workaround using the VS Code SQL Tools extension. The extension depends on the Microsoft SQL Tools Service which does have an ARM64 build. You can grab the latest ARM64 build of the SQL Tools here.
-
Has anyone used MSSQL with Flask or any other python framework?
Technically (or pedantically?) speaking, mssql-cli requires mssqltoolservice which is written in dotnet core, so I guess that's cheating.
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?
lsp-mssql - lsp-mode :heart: MSSQL Server
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.
ExcelToDatabase - Automated tool for bulk importing Excel into the database
q - q - Run SQL directly on delimited files and multi-file sqlite databases
mycli - A Terminal Client for MySQL with AutoCompletion and Syntax Highlighting.