PyCharm

The Python IDE for data science and web development

Download

sql

Repeatedly running queries that span multiple tables can be burdensome on your database. In this blog post, we’re going to talk about materialized views, how and why they help us cut down on query costs, and how to integrate them into your Django application. Read on to learn more or check out this …

In the previous blog post in this series, I created a Vagrant VM and provisioned it with Ansible for Python development. In this part, we’ll have a look at a larger application which is configured in the same way. In this post, I’ll introduce an application that I’ll be using for more blog posts in…

Redshift is Amazon Web Services’ data warehousing solution. They’ve extended PostgreSQL to better suit large datasets used for analysis. When you hear about this kind of technology as a Python developer, it just makes sense to then unleash Pandas on it. So let’s have a look to see how we can analyze…

We're probably done with new features for this release and have just published a new build which we call PyCharm 2.6 Beta. The major additions since the last EAP are the following: Diagrams support for SQLAlchemy Infer function return types from NumPy docstrings pyvenv & namespace package…

PyCharm 1.5 final release is now available for download. It's been an interesting version to work on. We've added a number of useful features that should make you more productive and your code better. Here are the main new features you will find inside PyCharm 1.5: Ultimate support for documenta…

PyCharm

sql

How to use Materialized Views in Django

Building an API using Flask-RESTful, and using the PyCharm HTTP Client

Analyzing Data in Amazon Redshift with Pandas

PyCharm 2.6 goes Beta and adds diagrams for SQLAlchemy

PyCharm 1.5 Released! Documentation, SQL/Database, Django templates debugging and more