3 ms·
As for cross-platform, VS Code has a plugin for SQL Server. It doesn't provide all the graphical management tools that SSMS does but all the stored procedures a
by lowkeyokay 9y ago
As for cross-platform, VS Code has a plugin for SQL Server. It doesn't provide all the graphical management tools that SSMS does but all the stored procedures are available, naturally.
If you're on a Mac, i suggest [1] Hankinsoft's SQL Studio. I've been using it daily for a couple of years. It's very light weight and supports most db's. It has some neat functions too; like marking rows and columns, right click and get insert statements. It's not free, but for me, it has been well worth the price.
If you want something for quick data analysis, I would suggest looking into queryStorm [2]. It was on HN's front page [3] last week, but for it's C# capabilities. It started as as SQL query tool for excel. I have yet to try it but it seems very useful and fast. Although I don't think it has any column store caching.
[1] http://www.hankinsoft.com http://www.hankinsoft.com
[2] https://querystorm.com https://querystorm.com
[3] https://news.ycombinator.com/item?id=15670030 https://news.ycombinator.com/item?id=15670030
- wluu 9y agoThe VS Code plugin and SQL Operations Studio both use the SQL Tools API Service[1]. [1] https://github.com/Microsoft/sqltoolsservice https://github.com/Microsoft/sqltoolsservice
- sixdimensional 9y agoQueryStorm looks cool and appears to use SQLite for local joins on the desktop, which gets you pretty far (column store would probably get you further). My only gripe here is being tied to Excel and potentially what looks like limited data source support.