Databases are ubiquitous, not only in web applications but also in data and business analytics projects. Throughout this chapter, we will learn about the various tools and features available in PyCharm that facilitate the process of working with the database systems used by your Python projects. These tools include powerful features such as the SQL editor, graphical interfaces with data sources, and making query diagrams.
All web developers should have a solid understanding of how to work with databases, and learning how to do that with PyCharm will be a good conclusion to our discussions on the process of web development in Python with PyCharm.
The following topics will be covered in this chapter:
- Connecting PyCharm to a given database
- Relational databases
- Utilizing the Database panel in PyCharm
- Data manipulation via the SQL console...