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

References	<7pt61a-am1.ln1@chris.zbmc.eu>
From	Ian Kelly <ian.g.kelly@gmail.com>
Date	2013-03-13 14:01 -0600
Subject	Re: What's the easiest Python datagrid GUI (preferably with easy database hooks as well)?
Newsgroups	comp.lang.python
Message-ID	<mailman.3270.1363205376.2939.python-list@python.org> (permalink)

Show all headers | 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