You're reading from Hands-On Application Development with PyCharm Build applications like a pro with the ultimate python development tool

Product type Paperback

Published in Oct 2023

Publisher Packt

ISBN-13 9781837632350

Length 652 pages

Edition 2nd Edition

Languages

Python

Tools

PyCharm

Concepts

Application Development

Authors (2):

Quan Nguyen

Bruce M. Van Horn II

View More author details

Table of Contents (24) Chapters

Preface

1. Part 1: The Basics of PyCharm

2. Chapter 1: Introduction to PyCharm – the Most Popular IDE for Python FREE CHAPTER

3. Chapter 2: Installing and Configuring PyCharm

4. Part 2: Improving Your Productivity

5. Chapter 3: Customizing Interpreters and Virtual Environments

6. Chapter 4: Editing and Formatting with Ease in PyCharm

7. Chapter 5: Version Control with Git in PyCharm

8. Chapter 6: Seamless Testing, Debugging, and Profiling

9. Part 3: Web Development in PyCharm

10. Chapter 7: Web Development with JavaScript, HTML, and CSS

11. Chapter 8: Building a Dynamic Web Application with Flask

12. Chapter 9: Creating a RESTful API with FastAPI

13. Chapter 10: More Full Stack Frameworks – Django and Pyramid

14. Chapter 11: Understanding Database Management in PyCharm

15. Part 4: Data Science with PyCharm

16. Chapter 12: Turning On Scientific Mode

17. Chapter 13: Dynamic Data Viewing with SciView and Jupyter

18. Chapter 14: Building a Data Pipeline in PyCharm

19. Part 5: Plugins and Conclusion

20. Chapter 15: More Possibilities with Plugins

21. Chapter 16: Your Next Steps with PyCharm

22. Index

Why subscribe?

23. Other Books You May Enjoy

Connecting to data sources using PyCharm

Open PyCharm Professional and create a new Python project called database_fun. Now, locate the database tools. You can find them on the right side toolbar via the database icon that looks like a three-layer cake (yum!). Alternatively, you can find it via the hamburger (yum!) menu by clicking View | Tool Windows | Database. Both options are shown in Figure 11.4.

Figure 11.4: Two options for opening database tools – one from the menu, and the second by clicking the database tools icon

With the database tools open, you need to create a new data source. Note the generic terminology. PyCharm supports relational as well as non-relational databases, so the term data source is just a generic way of pointing that out. Click the + icon shown in Figure 11.5, then hover over Data Source. You’ll see a long list of supported data sources. Find MySQL and click it.