Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.python > #105052

Any sqledit/sqlkit users here?

Path csiph.com!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From cl@isbd.net
Newsgroups comp.lang.python
Subject Any sqledit/sqlkit users here?
Date Wed, 16 Mar 2016 16:48:21 +0000
Lines 36
Message-ID <lbforc-p94.ln1@esprimo.zbmc.eu> (permalink)
Mime-Version 1.0
Content-Type text/plain; charset=UTF-8
Content-Transfer-Encoding 8bit
X-Trace individual.net iQrP/kGswWtVKx/B+2I5egQejGtKA79rTq91osbBBLe/7XiKk=
X-Orig-Path not-for-mail
Cancel-Lock sha1:E6C5jw/S+PbrRmjMpDEFhKqLnNQ=
User-Agent tin/2.3.1-20141224 ("Tallant") (UNIX) (Linux/4.2.0-34-generic (x86_64))
Xref csiph.com comp.lang.python:105052

Show key headers only | View raw


Does anyone here use sqledit/sqlkit?  It's a sqlite database
browser/editor which does most of its work by introspection (at least
I think that's the right name for it).

Thus it's trivially simple to write a gui program to edit data in a
database:-

    #!/usr/bin/python

    from sqlkit.widgets import SqlTable
    from sqlkit.db import proxy

    import gtk

    db = proxy.DbProxy(bind="sqlite:////home/chris/tmp/odinlog.db")

    t = SqlTable('tripLog',    dbproxy=db, order_by='Date' )
    t.reload()

    gtk.main()


(Yes, I know exit/close is missing)

Just run the above (against an existing database) and you get a very
neat looking, editable, grid view.

I was wondering if there are any active users with whom I could share
ideas, the mailing list is quite quiet though there is activity to
move the code to bitbucket and allow more contributions.

I'm just a bit overwhelmed by it at the moment and need some feedback.

-- 
Chris Green
ยท

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread


Thread

Any sqledit/sqlkit users here? cl@isbd.net - 2016-03-16 16:48 +0000

csiph-web