Skip to content

Instantly share code, notes, and snippets.

@tashrifbillah

tashrifbillah/sqlite_db_browser.py

Last active November 18, 2020 18:56
Show Gist options
  • Save tashrifbillah/1d01e38ac3dafef7ac916bb30849fc16 to your computer and use it in GitHub Desktop.
Save tashrifbillah/1d01e38ac3dafef7ac916bb30849fc16 to your computer and use it in GitHub Desktop.
Download ZIP
db file browser
Raw
sqlite_db_browser.py
#!/usr/bin/env python
import sqlite3
from os.path import abspath
import sys
conn= sqlite3.connect(abspath(sys.argv[1]))
cur = conn.cursor()
cur.execute("SELECT * FROM tasks")
rows= cur.fetchall()
for row in rows:
print(row)
conn.close()
@tashrifbillah
Copy link
Author

See https://www.w3schools.com/sql/sql_where.asp for smarter queries!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment