Oracle SQL Developer vs. PyCharm

[Oracle SQL Developer is] best suited if your company works with different databases and needs a common SQL editor to manage and query data for its user. Oracle SQL Developer works very well with Oracle but also some other relational databases. If you do lot of querying and import/export in database, then this is tool for you. It's ideal for DBAs as well for data modeling, management, session monitoring, logging, versioning, etc. It’s not ideal for no relational/noSQL or big data. It is not tool for visualization. It’s best suited for querying using SQL. Companies that are looking for free tools that are robust and most useful should definitely look at it.

Incentivized

It's easy to create virtual environments and install packages for different projects as we may need project-specific packages for doing our experiments, also it's easy to see what changes we have made and create pull requests faster. But sometimes we want some light python editor like Jupiter notebook as PyCharm is relatively heavier, also Jupiter notebooks are a good option when we need to run remote code on local machines.

Incentivized

• Export SQL results to a spreadsheet. After a query is run, you are able to export the results to a spreadsheet
• Easily preview data columns on an Oracle table or view and the metadata on those columns.
• SQL Editor is color-coded so that you can tell easily what are keywords.
• You can set up SQL code templates to be able to use shortcut keys to format your SQL query easily in a readable format that you prefer.

Incentivized

• Git integration is really essential as it allows anyone to visually see the local and remote changes, compare revisions without the need for complex commands.
• Complex debugging tools are basked into the IDE. Controls like break on exception are sometimes very helpful to identify errors quickly.
• Multiple runtimes - Python, Flask, Django, Docker are native the to IDE. This makes development and debugging and even more seamless.
• Integrates with Jupyter and Markdown files as well. Side by side rendering and editing makes it simple to develop such files.

Incentivized

• Setup can be challenging if your schemas aren't well formed or managed. Also, the ability to model/develop extensions for an existing database solution will depend on how robust the DBA provisioned roles and designed the respective schemas.
• Detailed analysis of models can be clunky for complex relational models.

Incentivized

• PyCharm text editor automatically inserts whitespace at the end of each line which can cause issues when doing text comparisons.
• The package requirement checker and installer does not work well all the time and can be improved
• Integration with GitLab pipelines can be made better.

Incentivized

It allows most users to perform daily activities in a simple way, with no cost since the tool is free.

Incentivized

It's perfect for our needs, cuts development time, is really helpful for newbies to understand projects structure

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

It's pretty easy to use, but if it's your first time using it, you need time to adapt. Nevertheless, it has a lot of options, and everything is pretty easy to find. The console has a lot of advantages and lets you accelerate your development from the first day.

Incentivized

Large user community support

Incentivized

I rate 10/10 because I have never needed a direct customer support from the JetBrains so far. Whenever and for whatever kind of problems I came across, I have been able to resolve it within the internet community, simply by Googling because turns out most of the time, it was me who lacked the proper information to use the IDE or simply make the proper configuration. I have never came across a bug in PyCharm either so it deserves 10/10 for overall support

Incentivized

Just download and uncompress!

Incentivized

Oracle SQL Developer is available on multiple platforms, Windows Mac Linux and it's free. SQL Developer is best suited for a big cross functional globally based team. SQL Developer is less resource intensive, compared to other IDEs. SQL Developer has the capability to manage and develop Oracle Database in both on premise and Cloud deployments. SQL Developer can also connect and interact with non oracle database like MS SQL server and MySQL etc.

Incentivized

It is more complete and can handle more projects at the same time. On the other hand, Visual Studio Code has better integration with LMS to help you code. PyCharm allows you to integrate with many external tools and external servers that Visual Studio Code has difficulties with.

Incentivized

• No impact on the organization's budget as Oracle SQL Developer is free.
• With the increased productivity of our database administrators, they are able to better assist the software developers in prototyping future products.
• Through Oracle SQL Developer, our administrators were able to normalize many of our databases, reducing the amount of redundancy, and hence increasing the performance of our main application.

Incentivized

• Improved efficiency with coding assistance (templates, code completion, documentation), which helps us avoid 'reinventing the wheel' with new projects.
• Extensive support for other packages/integrations: Docker support to test code, Git repo creation (for version control), and integration with different database systems (Postgres, MySQL).

Incentivized