Designing your GUI MySQL database means first thinking about what you want your Python application to do with it and then choose names for your tables that match the intended purpose.
- [Instructor] In the previous video,…we looked at configuring the MySQL connection.…This video deals with designing…the Python GUI database.…We will do that by refactoring our GUI…in preparation to use our new database.…We'll then recreate a MySQL database…and create two tables within it.…After that, verify that the tables made into our database…by using both Python and the MySQL client…that ships with the MySQL server.…
Before we start creating tables…and inserting data into them,…we have to design the database.…Unlike changing local Python variable names,…changing a database schema,…once it has been created and loaded with data,…is not that easy.…We would have to drop the table, which means…we would lose all the data that was in the table.…So before dropping a table,…we would have to extract the data,…then, drop the table…and recreate it under a different name,…and, finally, reimport the original data.…
You get the picture, right?…Well, designing our GUI MySQL database means…first, thinking about what we want,…our Python application to do with it,…
Note: This course was created by Packt Publishing. We are pleased to host this training in our library.
- Creating buttons and widgets
- Adding labels and features
- Expanding a GUI dynamically
- Aligning frames and embedding frames
- Creating menu bars, message boxes, and tooltips
- Using module-level global variables
- Coding in classes
- Using Matplotlib to create charts
- Working with multiple threads, queues, and TCP/IP
- Using URLOpen to read data from websites
- Localizing a GUI and preparing for internationalization
- Testing a GUI using unit tests and Eclipse PyDev IDE
- Using the wxPython library
- Using Tkinter, PyOpenGL, and Pyglet
Skill Level Intermediate
1. Creating the GUI Form and Adding Widgets
2. Layout Management
3. Look and Feel Customization
4. Data and Classes
Using the StringVar() type8m 14s
5. Matplotlib Charts
6. Threads and Networking
7. Storing Data in Our MySQL Database via Our GUI
8. Internationalization and Testing
9. Extending Our GUI with the wxPython Library
10. Creating Amazing 3D GUIs with PyOpenGL and Pyglet
11. Best Practices
- 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.