Join Bruce Van Horn for an in-depth discussion in this video Creating the database, part of Learning Python with PyCharm.
- [Instructor] In our project so far…we've been using PyCharm and Python…to create our very own PageSpider.…Essentially it reads a list of URLS…from a text file and then parses up…all the words that are in those URLs…and we're to that point in the project…where we really want to save all of those words…and the result of our analysis to a database.…PyCharm Professional has a collection…of database tools built into it.…These are going to be similar if not identical…to their companion tool called DataGrip…which is an IDE geared specially for database programming.…
Since working with databases…is so integral to building professional grade software…particularly software for the web…most of the functionality you'll find in DataGrip…is also in PyCharm Professional.…For our videos we're going to be using…a database called SQLite.…SQLite is a file-based database…meaning I don't have to install a server…or set up any sort of network infrastructure…in order to use it.…It still uses SQL tables…and all the usual relational structures…
AuthorBruce Van Horn
- Installing the PyCharm, Git, and Pypy packages
- Adding functions
- Refactoring code
- Calling packages
- Debugging code
- Creating databases
- Working with in-line SQL
- Creating web projects with PyCharm
Skill Level Beginner
1. First Steps with PyCharm
2. Code Quality
3. Working with Databases
4. Web Projects
Odds and ends5m 42s
Next steps1m 42s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.