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

Database tooling in PyCharm

The database tooling in PyCharm is complete but generic. By this, I mean that PyCharm attempts to support every database out there, and as such, it generally supports features common to all. You may find yourself sometimes leaning on more specific tools, such as SQL Server Management Studio (SSMS) for SQL Server. However, for general development work, the tooling in PyCharm is more than sufficient. The starting point for working with databases in PyCharm is opening the database tools and creating a connection. For this, you also need a database. PyCharm supports dozens of the most popular database servers. Since this is true, it would be impossible for me to predict which one you prefer, so I’m going to fall back on one that I know well: MySQL. Regardless of your favorite, the tooling in PyCharm is generic, so as long as you pick a relational database that is standards-compliant, the processes are the same.