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. -- __ __| |_ __ __ .----------------------------------------------. / _/ _` \ V V / | mailto:alug_cdw@the-walker-household.co.uk | \__\__,_|\_/\_/ |______________________________________________|