Is there such a thing?
Of course I know and use the sqlite3 command line utility but that's just a way of running SQL from the command line. What I want is some sort of wrapper/utility that reads the data from the database, presents it to me in some sort of reasonably editable format and then, when I've changed something writes it back.
I'd be happy enough with a simple browse facility plus some sort of way of changing individual fields. So "dbedit xyz.db table1" just presents me with the data in some sort of reasonable, scrollable column layout. Then some sort of command says "change column 10, row 4 to 'ABCDE'".
I'd be happy enough with a simple browse facility plus some sort of way of changing individual fields.
How about http://sqlitebrowser.org/ ?
https://apps.ubuntu.com/cat/applications/sqlitebrowser/ so it looks like it is/was in the repositories (or at least you should be able to build it on Ubuntu)
On 1 October 2014 11:34, Ewan Slater ewan.slater@gmail.com 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/ ?
On 1 October 2014 11:42, Ewan Slater ewan.slater@gmail.com wrote:
https://apps.ubuntu.com/cat/applications/sqlitebrowser/ so it looks like it is/was in the repositories (or at least you should be able to build it on Ubuntu)
On 1 October 2014 11:34, Ewan Slater ewan.slater@gmail.com 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/ ?
On Wed, Oct 01, 2014 at 11:44:04AM +0100, Ewan Slater wrote:
On 1 October 2014 11:42, Ewan Slater ewan.slater@gmail.com wrote:
https://apps.ubuntu.com/cat/applications/sqlitebrowser/ so it looks like it is/was in the repositories (or at least you should be able to build it on Ubuntu)
On 1 October 2014 11:34, Ewan Slater ewan.slater@gmail.com 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/ ?
Er, again, it's a GUI, not command line.
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.
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.
On Wed, Oct 01, 2014 at 05:31:53PM +0100, Chris Walker wrote:
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?
Yes, however it's quite a heavyweight chunk of code to write a database browser/editor. The big problem is that it's decidely non-trivial to take a sort of table view of the data as created by a "SELECT * FROM x" and write it back to the database.
-
Chris Green -
Chris Walker -
Ewan Slater