Tkinter Autocomplete options using date sources from Google sheets or MySQL database or CSV file

01:09 Using google sheets data as options for Autocomplete
08:23 Using MySql student table names as options for autocomplete
We can collect data from different sources to create the list. This list is used to pickup the matching options for the Autocomplete based on the user input.
This list can be prepared by taking sources from google sheets.
How to connect and collect data from google sheet is here

The same list can be created by using data from MySQL table, here we are reading names of our student table and the names we are selecting based on the matching string. This part is common to previous part of the tutorial but only the data source is changed from static list to MySQL records.
Part I : Design , adding options and selection
https://youtu.be/HulO1qiEn78
Part II : Navigation and selection by arrows
https://youtu.be/QYeYi4LBpIU
Part III : Different data sources, Pygsheets , MySQL database
https://youtu.be/uKj4Py_At3w
Part IV : Displaying all product attributes on selection
https://youtu.be/c8DRdVDGV40
Part V: Using colour names as source
https://youtu.be/RBKNM_uzGwg

Source code is here
https://www.plus2net.com/python/tkinter-autocomplete-source.php

Connecting to google sheets and using google api authorization key
https://youtu.be/LYAKsaUiDJI
https://www.plus2net.com/python/pygsheets.php

Connections and reading data from MySQL database using SQLAlchemy
https://youtu.be/1V8Uf4XaQU4
Article on connection string to MySQL and collecting rows
https://www.plus2net.com/python/mysql-sqlalchemy.php

MySQL dump of student table
https://www.plus2net.com/sql_tutorial/sql_student_dump.php
#AutocompleteDataSource #PygsheetsDataSourceAutocomplete #OptionsMySQL #MySQLAutocomplete #DataSources #plus2net #Tkinter #Python

Видео Tkinter Autocomplete options using date sources from Google sheets or MySQL database or CSV file канала plus2net