Python SQLite database connection and managing by using colab platform and mounting drive
https://www.plus2net.com/python/sqlit...
List of all Python SQLite tutorials
https://www.plus2net.com/python/pytho...
As SQLite is a file based database and there is no client server network system, to manage this we can use google drive to keep our database file and connect to it from our Colab platform. For this we need to mount the google drive to our colab platform. Run this code in your Jupiter notebook to mount google drive. from google.colab import drive drive.mount('/content/drive') Now google will ask for authorization, this can be given by using following the link and using the authorization code. After mounting the drive we can copy the path of the database file and then use the path to connect to SQLite database by using SQLalchem library. After successful connection we can run the code below to check the tables available in our database file. r_set=my_conn.execute('''select name from sqlite_master where type = 'table' ''') for row in r_set: print(row) This will list all the tables available. Let us run this code to get all records of student table. r_set=my_conn.execute('''SELECT * from student'''); for row in r_set: print(row)
Auf dieser Seite können Sie das Online-Video Python SQLite database connection and managing by using colab platform and mounting drive mit der Dauer stunde minuten sekunde in guter Qualität ansehen, das der Benutzer plus2net 29 Dezember 2020 hochgeladen hat, den Link mit Freunden und Bekannten teilen, dieses Video wurde auf Youtube bereits 11,606 Mal angesehen und es wurde von 114 den Zuschauern gefallen. Viel Spaß beim Betrachtenden Zuschauern gefallen!
