Re: What's the easiest Python datagrid GUI (preferably with easy database hooks as well)?

Path	csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path	<ian.g.kelly@gmail.com>
X-Original-To	python-list@python.org
Delivered-To	python-list@mail.python.org
X-Spam-Status	OK 0.001
X-Spam-Evidence	'H': 1.00; 'S': 0.00; 'subject:Python': 0.05; 'beginner': 0.05; 'column': 0.07; 'framework.': 0.07; 'python': 0.09; '1300': 0.09; 'dropdown': 0.09; 'orm': 0.09; 'rows,': 0.09; 'subclass': 0.09; 'gui': 0.11; 'programmer': 0.11; 'columns': 0.16; 'reasonably': 0.16; 'sorting.': 0.16; 'sqlalchemy': 0.16; 'subject: \n ': 0.16; 'subject:)?': 0.16; 'subject:GUI': 0.16; 'subject:preferably': 0.16; 'wxpython': 0.16; 'wed,': 0.16; 'wrote:': 0.17; 'basically': 0.17; 'sort': 0.21; 'fairly': 0.21; 'driven': 0.22; 'filtering': 0.22; 'keys': 0.22; "i've": 0.23; 'least': 0.25; 'header:In-Reply-To:1': 0.25; 'values': 0.26; 'done.': 0.27; 'easiest': 0.27; 'necessary.': 0.27; 'message- id:@mail.gmail.com': 0.27; 'lines': 0.28; 'cells': 0.29; 'toolkit': 0.29; 'probably': 0.29; "i'm": 0.29; 'stuff': 0.30; 'code': 0.31; 'etc.)': 0.32; 'to:addr:python-list': 0.33; 'received:google.com': 0.34; 'done': 0.34; 'doing': 0.35; 'pm,': 0.35; 'similar': 0.35; 'received:209.85': 0.35; 'something': 0.35; 'there': 0.35; 'add': 0.36; 'but': 0.36; 'data.': 0.36; 'subject:with': 0.36; 'subject: (': 0.36; 'keeps': 0.37; 'being': 0.37; 'quite': 0.37; 'received:209': 0.37; 'data': 0.37; 'subject:: ': 0.38; 'supports': 0.38; 'some': 0.38; 'things': 0.38; 'to:addr:python.org': 0.39; 'application': 0.40; 'help': 0.40; 'back': 0.62; 'different': 0.63; 'more': 0.63; 'show': 0.63; 'friendly': 0.71; 'foreign': 0.72; 'absolutely': 0.84; '2013': 0.84; 'to:name:python': 0.84
DKIM-Signature	v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=x-received:mime-version:in-reply-to:references:from:date:message-id :subject:to:content-type; bh=alnVKZKWF4DwvUbxrS7b76aw5i/iMuKRJDohpDq7mEY=; b=S1WrDRrGaXdmGoG9BdWH4/1XjWw0W9x6KxfaY4BQ2G62uURV6sn+xxKQeskmmgh6Rn UKBJ1iR8ZhaHrqPDXmdqTzuI5DFVHYT2QKXX55H7v+kjCaXaVN+HdL0NVWhUN9I7+myW 78mbXtWaGToZlIXiEdMiJhj9m0DUWKy3Wh2MGCrvua25osLko9S1XHUhROuCvY9S1Fd8 VOzeIaPhwsrLU8mf4SAu5EtTYCYtXhtEjtScjV77A1/lKmWyqE5AMfZZ1lw6grEPWsz2 jlEe074cqO23TwYCq/5kQ4BGFRgvfeYL4gKDB7jor8tycQNdyfF62LJPAnylT2bcSAJI OtLA==
X-Received	by 10.52.76.103 with SMTP id j7mr7678618vdw.90.1363204909501; Wed, 13 Mar 2013 13:01:49 -0700 (PDT)
MIME-Version	1.0
In-Reply-To	<7pt61a-am1.ln1@chris.zbmc.eu>
References	<7pt61a-am1.ln1@chris.zbmc.eu>
From	Ian Kelly <ian.g.kelly@gmail.com>
Date	Wed, 13 Mar 2013 14:01:09 -0600
Subject	Re: What's the easiest Python datagrid GUI (preferably with easy database hooks as well)?
To	Python <python-list@python.org>
Content-Type	text/plain; charset=ISO-8859-1
X-BeenThere	python-list@python.org
X-Mailman-Version	2.1.15
Precedence	list
List-Id	General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe	<http://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive	<http://mail.python.org/pipermail/python-list/>
List-Post	<mailto:python-list@python.org>
List-Help	<mailto:python-list-request@python.org?subject=help>
List-Subscribe	<http://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups	comp.lang.python
Message-ID	<mailman.3270.1363205376.2939.python-list@python.org> (permalink)
Lines	28
NNTP-Posting-Host	2001:888:2000:d::a6
X-Trace	1363205376 news.xs4all.nl 6851 [2001:888:2000:d::a6]:50384
X-Complaints-To	abuse@xs4all.nl
Xref	csiph.com comp.lang.python:41193

Show key headers only | View raw

On Wed, Mar 13, 2013 at 12:40 PM,  <tinnews@isbd.co.uk> wrote:
> I want to write a fairly trivial database driven application, it will
> basically present a few columns from a database, allow the user to add
> and/or edit rows, recalculate the values in one column and write the
> data back to the database.
>
> I want to show the data and allow editing of the data in a datagrid as
> being able to see adjacent/previous data will help a huge amount when
> entering data.
>
> So what toolkits are there out there for doing this sort of thing?  A
> GUI toolkit would be lovely (allowing layout etc.) but isn't
> absolutely necessary.
>
> I'm a reasonably experienced programmer and know python quite well
> but I'm fairly much a beginner with event driven GUI stuff so I need
> a user friendly framework.

I've done something similar using wxPython and sqlalchemy.  I use a
wxGrid with a wxGridTableBase subclass that keeps a sqlalchemy ORM
Session to access the database.  The whole application is around 1300
lines of code but is probably more complex than what you need -- it
currently has five different views built in and supports some fancier
things like dropdown editing of foreign keys and many-to-many
relations; cells with type-ahead; filtering and sorting.

I don't know if that's the easiest way to do it, but I can at least
report that it can be done.

Thread

What's the easiest Python datagrid GUI (preferably with easy database hooks as well)? tinnews@isbd.co.uk - 2013-03-13 18:40 +0000
  Re: What's the easiest Python datagrid GUI (preferably with easy database hooks as well)? Walter Hurry <walterhurry@lavabit.com> - 2013-03-13 19:35 +0000
    Re: What's the easiest Python datagrid GUI (preferably with easy database hooks as well)? tinnews@isbd.co.uk - 2013-03-13 21:03 +0000
  Re: What's the easiest Python datagrid GUI (preferably with easy database hooks as well)? Ian Kelly <ian.g.kelly@gmail.com> - 2013-03-13 14:01 -0600
  Re: What's the easiest Python datagrid GUI (preferably with easy database hooks as well)? Wolfgang Keller <feliphil@gmx.net> - 2013-03-14 14:24 +0100
    Re: What's the easiest Python datagrid GUI (preferably with easy database hooks as well)? Sibylle Koczian <nulla.epistola@web.de> - 2013-03-15 13:36 +0100
      Re: What's the easiest Python datagrid GUI (preferably with easy database hooks as well)? Wolfgang Keller <feliphil@gmx.net> - 2013-03-16 21:30 +0100
        Re: What's the easiest Python datagrid GUI (preferably with easy database hooks as well)? Sibylle Koczian <nulla.epistola@web.de> - 2013-03-17 12:06 +0100
          Re: What's the easiest Python datagrid GUI (preferably with easy database hooks as well)? rusi <rustompmody@gmail.com> - 2013-03-17 08:50 -0700
            Re: What's the easiest Python datagrid GUI (preferably with easy database hooks as well)? Sibylle Koczian <nulla.epistola@web.de> - 2013-03-18 15:09 +0100
              Re: What's the easiest Python datagrid GUI (preferably with easy database hooks as well)? Wolfgang Keller <feliphil@gmx.net> - 2013-03-19 15:16 +0100
          Re: What's the easiest Python datagrid GUI (preferably with easy database hooks as well)? Wolfgang Keller <feliphil@gmx.net> - 2013-03-19 15:17 +0100
    Re: What's the easiest Python datagrid GUI (preferably with easy database hooks as well)? Mark Lawrence <breamoreboy@yahoo.co.uk> - 2013-03-15 17:15 +0000

csiph-web