This is a good time to ask: is there any good SQL IDE for Oracle better than SQL Developer?
SQL Operations Studio
31–40 of 96 posts
Re: SQL Operations Studio
#32This is a good time to ask: is there any good SQL IDE for Oracle better than SQL Developer?
Toad used to be a great choice. I would look there.
Re: SQL Operations Studio
#33This is a good time to ask: is there any good SQL IDE for Oracle better than SQL Developer?
I'd be interested in something better as well. I was testing SQuirrel SQL the other day (have used it before for MSSQL), but the Oracle plugins for it seem to have succumb to bitrot over the past couple of years. UI can hang for minutes on new connections, CTE's aren't recognized as valid syntax, searching Objects is slow and cumbersome.
I know a few people who just use Intellij for it.
Re: SQL Operations Studio
#34Currently extracting the 16819 files in the archive.. ;-)
That said, the screenshots look decent and I've been looking for an alternative to the SQL Server Management Studio a couple times already. So I already applaud the effort.
Re: SQL Operations Studio
#35I guess it's a good thing I didn't do the project I was thinking about. I observed the fact that SQL Server had no management tool that was cross-platform, and thought perhaps I would build such a thing. Nice work Microsoft! On a side-note, I'd love to see an even more minimalist stripped-down, read-mostly query/tabular result only (with pivot tables) tool, which had some local columnar storage caching/query engine,…
DataGrip by JetBrains is cross-platform and supports a large variety of database servers.
Re: SQL Operations Studio
#36No Postgres support yet. Looks like a great app though. https://github.com/Microsoft/sqlopsstudio/issues/56
You're kidding, right? This is a Microsoft product. Microsoft have their own database. What value is it to them to help people continue using competitor's products? Besides, it's not like Postgres doesn't have plenty of GUI tools already: https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreS...
Not kidding. If my database is Postgres, I develop for it in Visual Studio Code and deploy it to Azure, why shouldn't I be able to explore it with another Microsoft product.
I grew up with the Microsoft you describe, but they've been gone for several years now. Not to say they can do no wrong, or that we shouldn't be wary, but to think it ridiculous that they could support multiple databases is not compatible with their actions lately.
Re: SQL Operations Studio
#37Finally, DBA's can experience the "wonders" of electron too. When you accidentally select * and get 100,000 items back how does the non-native table view hold up?
It works well for large data sets. The UI is indeed virtualized (using SlickGrid), and the backend streams query results to a temp file to avoid memory usage growing too high.
Note: As you might guess from the details, I work on this tool. Please try it out and let us know if you run into any issues!
Re: SQL Operations Studio
#38Finally, DBA's can experience the "wonders" of electron too. When you accidentally select * and get 100,000 items back how does the non-native table view hold up?
It works well for large data sets. The UI is indeed virtualized (using SlickGrid), and the backend streams query results to a temp file to avoid memory usage growing too high. Note: As you might guess from the details, I work on this tool. Please try it out and let us know if you run into any issues!
I'm loving it so far. Thanks for your work!
Re: SQL Operations Studio
#39No Postgres support yet. Looks like a great app though. https://github.com/Microsoft/sqlopsstudio/issues/56
You're kidding, right? This is a Microsoft product. Microsoft have their own database. What value is it to them to help people continue using competitor's products? Besides, it's not like Postgres doesn't have plenty of GUI tools already: https://wiki.postgresql.org/wiki/Community_Guide_to_PostgreS...
Then explain why Microsoft become platinum sponsor for MariaDB.
Re: SQL Operations Studio
#40Currently extracting the 16819 files in the archive.. ;-) That said, the screenshots look decent and I've been looking for an alternative to the SQL Server Management Studio a couple times already. So I already applaud the effort.
Same here - I'm glad I have a NVME drive, dread to think about the extract on a SATA one. :D
Very exciting development, looking forward to trying it out.