Connection to SQlite by using Colab

Mount Google drive

from google.colab import drive
drive.mount('/content/drive')

Download database from plus2net using wget

!wget https://www.plus2net.com/python/download/my_db.db

Database Connection using SQL Magic Extension

%load_ext sql
# we can use the magic extension to connect to our SQLite DB
%sql sqlite:///my_db.db

# use %sql to write an inline SQL command
# use %%sql to write SQL commands in a cell
%%sql
SELECT name FROM sqlite_master WHERE type='table' ;

Done.
name
category
subcategory
student

%sql PRAGMA table_info([student]);

 * sqlite:///my_db.db
Done.
cid	name	type	notnull	dflt_value	pk
0	id	INTEGER	0	None	1
1	name	TEXT	0	None	0
2	class	TEXT	0	None	0
3	mark	INTEGER	0	None	0
4	gender	TEXT	0	None	0

%%sql
SELECT * FROM student LIMIT 0,5

 * sqlite:///my_db.db
Done.
id	name	class	mark	gender
1	John Deo	Four	75	female
2	Max Ruin	Three	85	male
3	Arnold	Three	55	male
4	Krish Star	Four	60	female
5	John Mike	Four	60	female

result = %sql SELECT * FROM student LIMIT 0,5;
#result.DataFrame().loc[0, 'name'] # first name only 
result.DataFrame().loc[:,'name']   # all names

Connecting using SQLAlchemy

from sqlalchemy import create_engine
my_conn=create_engine("sqlite:////content/drive/MyDrive/my_db/my_db.db")

my_conn=create_engine("sqlite:////my_db.db")

r_set=my_conn.execute('''select name from sqlite_master 
		where type = 'table' ''')
for row in r_set:
    print(row)

('category',)
('subcategory',)
('student',)

r_set=my_conn.execute('''SELECT * from student''');
for row in r_set:
    print(row)

Connecting using sqlite3

# download my_db.db SQLite Database from plus2net.com
!wget https://www.plus2net.com/python/download/my_db.db

import sqlite3
my_conn = sqlite3.connect('my_db.db') # connect to db
query="SELECT *  FROM student LIMIT 0,5" # sql 
my_data=list(my_conn.execute(query)) # rows of data as list 
print(my_data)