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)
Sur cette page du site, vous pouvez voir la vidéo en ligne Python SQLite database connection and managing by using colab platform and mounting drive durée heure minute seconde en bonne qualité , qui a été Téléchargé par l'utilisateur plus2net 29 décembre 2020, Partagez le lien avec vos amis et connaissances, sur youtube cette vidéo a déjà été regardée 11,606 fois et il a aimé 114 téléspectateurs. Bon visionnage!
