DBeaver vs. Oracle SQL Developer vs. Sublime Text

If you are connecting to Snowflake and want to query from your laptop, I find that this is much easier to use than Snowflake's IDE. It allows us as a business intelligence team to more easily connect to our servers, and code with much less hassle. It would be less appropriate if you are only on an on-premises SQL server, in that case, I would just use SSMS.

Incentivized

Almost all development activities (the tool is called "SQL Developer", not "DBA Toolset") can be done easily and quick with [Oracle] SQL Developer. From data model creation (tables, views) to development (creation of procedures, functions, packages) and then testing (SQL Developer includes an easy to use debugger), all tasks can be performed in a single tool.

It may not be as complete as other solutions for DBA tasks like instance monitoring, but it is usually OK for development and testing environments if you want to do some basic troubleshooting.

Incentivized

My CMS has a small window in which I can edit custom HTML/CSS. It can be expanded some, but not as much as I would like. It also displays all code as dark text on a white background. On a page where I am doing extensive custom coding, it is helpful to see it in a larger window and in a color-coded display so that I don't have to strain my eyes as hard. Especially when I'm trying to scan for specific elements and target issues and so that I don't have to scroll endlessly in a tiny window.

Incentivized

• Identify types of DB connections by color code: development, testing and production.
• Predictive typing, it is incredibly accurate and saves me a lot of time.
• Jump between different simultaneous DB connections.
• Navigate through the schema object tree.
• Provide all the tools I need in one window.

• Object Browser in SQL Developer allows you to explore the contents of your database using the connection tree.
• The SQL Worksheet is an editor that allows for execution of SQL statements, scripts, and PL/SQL anonymous blocks. SELECT statements can be executed to return results in a spreadsheet-like 'grid' or can be executed as a script such to emulate SQL*Plus behavior and output
• DBA Console allows users with administrative privileges to access DBA features such as database init file configuration, RMAN backup, storage, etc.

Incentivized

• It is very light and boots up instantaneously.
• It has tons of plugins that will help you to customize sublime entirely according to your needs and thereby is not bloated
• Package control is really easy to work with and most plugins can be installed in 2 just clicks.
• Free version has nearly all the features of the paid version.
• Its User Interface is simple and makes it easy to located many features.
• It gives you a ton of control over your ide setting through User-settings where you can customize almost everything.

Incentivized

• Schema editing is not very intuitive. Editing a single column forces you into multiple tab windows when trying to change something simple like a column name.
• Sorting and filtering in data is nice, but buried in long right-click menus.
• Some things are definitely non-standard UI for a Windows application, so it might be hard for die-hard Windows fans to get used to.

Incentivized

• Inability to run multiple queries on the same database. You can only run one query on a given database.
• Analytical models created from complex tables isn't accurate, and needs work.
• Inability to view multiple tables of a database side-by-side. When trying to find correlations between tables, it would help to be able to see them at once on the same page.

Incentivized

• Plugins are easier to use and less complicated but transferring your license to a new computer isn't as simple as it sounds.
• Sublime has an automatic file comparison feature, but it's challenging to use and should be improved.
• Adding the ability to mark or highlight the text with different colors would be an excellent application.

We had already thought of changing to TOAD, but we decided to stick with Oracle SQL Developer until the end.

Incentivized

I love this application. It has helped to improve my work. Also, I became so used to the shortcuts that It's hard for me to change to another editor.

Incentivized

It's perfectly easy to use. Not super new and shiny with lots of accessibility tailored tools, but does the job

Incentivized

Oracle SQL Developer is very easy to use and there are a wide range of courses available which can help you get started just within a day. Data can be exported in multiple formats based on user requirements. Organizational data can be stored and management effectively using Oracle SQL Developer. All the data, tables, sequences, indexes can be easily created and updated in Oracle SQL Developer.

Incentivized

This is a programmers tool. As such a lot of the features and benefits are lost on a non-technical user. To get the most out of the tool you need to have a basic crash course in how it works and what it can do. The documentation and community are good, but it takes a bit of time to get up to speed.

Incentivized

It has many handy hacks and shortcuts which enhances its performace.

Incentivized

Not a lot of users have DBeaver so fewer resources are available online to help you if you have any issues. When I was trying to figure out how to create my own ER diagrams, it was a little tough to find resources

Incentivized

Large user community support

Incentivized

Never had to use their customer support before. There is ample documentation online so it's straightforward to find a solution to any problem you might encounter. For example, I needed to convert a string of HTML code to a properly formatted HTML file to "modify." Easy to do when there are so many users of the product who have needed to do that same thing before.

Incentivized

Just download and uncompress!

Incentivized

MySQL workbench from MySQL only supports MySQL databases and it only provides basic functionality. On top of that, the user experience could be quite confusing for first-time users. SSMS from SQL server doesn't support inline editing nicely. The view for inline editing and view data is different, making it uncomfortable to use. All in all, DBeaver is the best tool when you manage a lot of databases with different types.

Incentivized

I have started to use Toad for Oracle recently because it is easier to sort and filter results, due to their memory sort feature that puts the results from your query in memory so that you don't have to rerun your query. I have used SQL Developer to easily update records in tables that I need to fix. I haven't found an easy way to do this in Toad other than writing SQL insert statements.

Incentivized

We've used both Notepad++ and Atom; both are great but nothing really beats the Sublime Text UI; super intuitive and friendly and does everything you need without overwhelming you with stuff you don't. Other options are free, but for our organization, it was well worth the small license cost for the persistent use of a great product.

Incentivized

• Positive Ability to manage DBeaver and query ad-hoc quickly
• By having the queries saved it has saved developer time and thereby increased the ROI on the investment on the tool
• This has made firefighting quicker and freed up resources for more development work.

Incentivized

• It gives 100% return on investment as it is free of cost.
• No need to have multiple tools for each database
• Considering the employee training, so one can save money on training, as it is not very hard to use so still savings.

Incentivized

• Sublime Text has helped me to focus on specific tasks, cutting out the clutter that many other IDEs have. As such, it has helped me be a more productive employee because I don't get dazed by hundreds of buttons. I can focus on just the code.
• Sublime Text is so affordable that it's a no-brainer to have an extra tool in your toolset.
• The Search features of Sublime Text are so useful that it has saved me a great amount of time compared to using Find & Replace menus in Xcode, Android Studio, or Eclipse.

Incentivized