On Wed, 1 Oct 2014 13:01:14 +0100 Chris Green cl@isbd.net wrote:
On Wed, Oct 01, 2014 at 11:34:59AM +0100, Ewan Slater wrote:
I'd be happy enough with a simple browse facility plus some sort of way of changing individual fields.
How about http://sqlitebrowser.org/ ?
It's a GUI, not command line.
Haven't you answered your own question earlier in this thread when you mentioned Python?
I have some Python code for a SQLIte database. It starts like this :- import os import sqlite3 import sys
args = sys.argv[1:]
action = args.pop(0)
if not action: sys.exit('Need an action')
filename = 'Beer_Database.sql'
if action == 'list': tablename = args.pop(0) mydb = sqlite3.connect(filename) c = mydb.cursor() for row in c.execute('select * from '+tablename): print row
......... and so on.