How can i grab the domain name from the firefox's places.sqlite file with python script

Question

How can anyone grab the list of URLs from the Firefox's places.sqlite file? Can anyone help me out with any python script.

Answer 1

import sqlite3
db = sqlite3.connect("<path_to>/places.sqlite")
urls = db.execute("select url from moz_places").fetchall()