Anaconda vs. erwin Data Modeler vs. PyCharm

I have asked all my juniors to work with Anaconda and Pycharm only, as this is the best combination for now. Coming to use cases: 1. When you have multiple applications using multiple Python variants, it is a really good tool instead of Venv (I never like it). 2. If you have to work on multiple tools and you are someone who needs to work on data analytics, development, and machine learning, this is good. 3. If you have to work with both R and Python, then also this is a good tool, and it provides support for both.

Incentivized

I have had a chance to use few other data modeling tools from Quest and Oracle, but I am most comfortable using erwin Data Modeler. They understand your data modeling needs and have designed the software to give you a feeling of completeness when you are designing a data model.

Incentivized

PyCharm is well suited to developing and deploying Python applications in the cloud using Kubernetes or serverless pipelines. The integration with GitLab is great; merges and rebates are easily done and help the developer move quickly. The search engine that allows you to search inside your code is also great. It is less appropriate for other languages.

Incentivized

• Anaconda is a one-stop destination for important data science and programming tools such as Jupyter, Spider, R etc.
• Anaconda command prompt gave flexibility to use and install multiple libraries in Python easily.
• Jupyter Notebook, a famous Anaconda product is still one of the best and easy to use product for students like me out there who want to practice coding without spending too much money.

Incentivized

• Reverse Engineering: I love the way we can import an SQL file containing schema meta data and generate ER diagram out of it. This is specifically useful if you are implementing erwin Data Modeler for an existing database.
• Forward Engineering: We use this feature very frequently. Where we do database changes in our physical and logical data models and then generate deployment scripts for the changes made.
• Physical vs Logical Models: I like to have my database model split into physical and logical models and at the same time still linked to each other. Any changes you make to logical model or physical model shows up in the other.

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

• It can have a cloud interface to store the work.
• Compatible for large size files.
• I used R Studio for building Machine Learning models, Many times when I tried to run the entire code together the software would crash. It would lead to loss of data and changes I made.

Incentivized

• Cost is the single largest barrier to entry with this tool.
• Would like to see a greater variety of export options available for use outside of the tool, for example as a vector graphic.
• Support has been uneven at times.

Incentivized

• The biggest complaint I have about PyCharm is that it can use a lot of RAM which slows down the computer / IDE. I use the paid version, and have otherwise found nothing to complain about the interface, utility, and capabilities.

Incentivized

It's really good at data processing, but needs to grow more in publishing in a way that a non-programmer can interact with. It also introduces confusion for programmers that are familiar with normal Python processes which are slightly different in Anaconda such as virtualenvs.

Incentivized

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

Incentivized

I am giving this rating because I have been using this tool since 2017, and I was in college at that time. Initially, I hesitated to use it as I was not very aware of the workings of Python and how difficult it is to manage its dependency from project to project. Anaconda really helped me with that. The first machine-learning model that I deployed on the Live server was with Anaconda only. It was so managed that I only installed libraries from the requirement.txt file, and it started working. There was no need to manually install cuda or tensor flow as it was a very difficult job at that time. Graphical data modeling also provides tools for it, and they can be easily saved to the system and used anywhere.

Incentivized

I had a lot of experience using erwin Data Modeler for designing data models. I think it's pretty intuitive and easy to use. It has enough features to represent your database requirements in form of a model.

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

Anaconda provides fast support, and a large number of users moderate its online community. This enables any questions you may have to be answered in a timely fashion, regardless of the topic. The fact that it is based in a Python environment only adds to the size of the online community.

Incentivized

CA customer support and our account manager have been able to support us with any issues that we have had, from managing our serial keys to issues we logged tickets to resolve. There are aspects of key management that have made it difficult over the years but support usually has worked with us.

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

I have experience using RStudio oustide of Anaconda. RStudio can be installed via anaconda, but I like to use RStudio separate from Anaconda when I am worin in R. I tend to use Anaconda for python and RStudio for working in R. Although installing libraries and packages can sometimes be tricky with both RStudio and Anaconda, I like installing R packages via RStudio. However, for anything python-related, Anaconda is my go to!

Incentivized

Not listed, but I've only used alternatives built into something like the Squirrel SQL editor. That one is semi-functional but lacking many features and, in some instances, just plain wrong. The only pro there is that it's freely available and works over ODBC. I've tried some of the other free ones like Creately but didn't have much success.

Incentivized

When it comes to development and debugging PyCharm is better than Spyder as it provides good debugging support and top-quality code completion suggestions. Compared to Jupiter notebook it's easy to install required packages in PyCharm, also PyChram is a good option when we want to write production-grade code because it provides required suggestions.

Incentivized

• It has helped our organization to work collectively faster by using Anaconda's collaborative capabilities and adding other collaboration tools over.
• By having an easy access and immediate use of libraries, developing times has decreased more than 20 %
• There's an enormous data scientist shortage. Since Anaconda is very easy to use, we have to be able to convert several professionals into the data scientist. This is especially true for an economist, and this my case. I convert myself to Data Scientist thanks to my econometrics knowledge applied with Anaconda.

Incentivized

• It is difficult to assign a monetary value to it. The initial learning curve was fairly long.
• It allows us to have better support documentation.
• It allows ease of communications between functional units.

Incentivized

• PyCharm has a very positive ROI for our BU. It has increased developer productivity exponentially.
• Software quality has significantly improved. We are able to refactor/test/debug the code quicker/faster/better.
• Our business unit is able to deliver faster. Customers are happier than ever.

Incentivized