Skip to content

Instantly share code, notes, and snippets.

@marsam
Created June 21, 2013 21:56
Show Gist options
  • Select an option

  • Save marsam/5834649 to your computer and use it in GitHub Desktop.

Select an option

Save marsam/5834649 to your computer and use it in GitHub Desktop.
useless example of mozilla places
#!/usr/bin/env python
# -*- coding: utf-8 -*-
"""
https://developer.mozilla.org/en/docs/The_Places_database
"""
import os
import sqlite3
db = os.path.expanduser('~/.mozilla/firefox/jepqyb8q.default/places.sqlite')
conn = sqlite3.connect(db)
with conn:
for title, last_modified in conn.execute("select title, lastModified from moz_bookmarks where title like ? limit 20", (u'%ñ%',)).fetchall():
print(title)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment