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

Understanding Database Management in PyCharm

What do horseshoe crabs, coelacanths, crocodiles, and relational databases have in common? I’ll wait while you go look up coelacanth. All four of these have been around for millions of years and yet have evolved very little. OK, databases haven’t been around for millions of years, but they have been around for millions of internet years. Everybody knows that internet years are very short. JavaScript developers often joke that before lunchtime, anywhere in the world, dozens of new frameworks have been invented, risen to prominence, fallen out of favor, and then been abandoned all before you finish your noodles.

In the early 1970s, a researcher named E. F. Codd was working at IBM’s San Jose Research Laboratory in California. He developed a revolutionary concept called the relational model of data. In his seminal paper titled A Relational Model of Data for Large Shared Data Banks, published in 1970, Codd outlined the...