Book Image

Hands-On Application Development with PyCharm - Second Edition

By : Bruce M. Van Horn II, Quan Nguyen
5 (1)
Book Image

Hands-On Application Development with PyCharm - Second Edition

5 (1)
By: Bruce M. Van Horn II, Quan Nguyen

Overview of this book

In the quest to develop robust, professional-grade software with Python and meet tight deadlines, it’s crucial to have the best tools at your disposal. In this second edition of Hands-on Application Development with PyCharm, you’ll learn tips and tricks to work at a speed and proficiency previously reserved only for elite developers. To achieve that, you’ll be introduced to PyCharm, the premiere professional integrated development environment for Python programmers among the myriad of IDEs available. Regardless of how Python is utilized, whether for general automation scripting, utility creation, web applications, data analytics, machine learning, or business applications, PyCharm offers tooling that simplifies complex tasks and streamlines common ones. In this book, you'll find everything you need to harness PyCharm's full potential and make the most of Pycharm's productivity shortcuts. The book comprehensively covers topics ranging from installation and customization to web development, database management, and data analysis pipeline development helping you become proficient in Python application development in diverse domains. By the end of this book, you’ll have discovered the remarkable capabilities of PyCharm and how you can achieve a new level of capability and productivity.
Table of Contents (24 chapters)
1
Part 1: The Basics of PyCharm
4
Part 2: Improving Your Productivity
9
Part 3: Web Development in PyCharm
15
Part 4: Data Science with PyCharm
19
Part 5: Plugins and Conclusion

Querying the data source using SQL

Querying the database is probably the second most useful feature of having database tooling built right into the IDE. As with many of the features in PyCharm, this one ensures you never need to leave PyCharm to get your work done.

There are several places that allow you to run queries. You can run ad hoc queries in a query console, or you can run queries directly from .sql files.

Ad hoc queries

Ad hoc queries are simply queries for an immediate purpose. An ad hoc query has a number of characteristics:

  • Unplanned: Ad hoc queries are not part of a predefined set of queries. They are written on the spot to address a particular need.
  • Temporary: They are used to retrieve data for a specific task or situation and are not saved for future use. They aren’t part of your application, though after some experimentation and tweaking, you might formalize them in your code.
  • No optimization: Ad hoc queries might not be optimized for...