Rocksolid Light

Welcome to novaBBS (click a section below)

mail  files  register  newsreader  groups  login

Message-ID:  

"Consistency requires you to be as ignorant today as you were a year ago." -- Bernard Berenson


devel / comp.lang.python / Re: tkinter: tksheet

SubjectAuthor
o Re: tkinter: tksheetAlan Gauld

1
Re: tkinter: tksheet

<mailman.98.1623946413.4164.python-list@python.org>

  copy mid

https://www.novabbs.com/devel/article-flat.php?id=13751&group=comp.lang.python#13751

  copy link   Newsgroups: comp.lang.python
Path: i2pn2.org!i2pn.org!news.swapon.de!fu-berlin.de!uni-berlin.de!not-for-mail
From: alan.ga...@yahoo.co.uk (Alan Gauld)
Newsgroups: comp.lang.python
Subject: Re: tkinter: tksheet
Date: Thu, 17 Jun 2021 09:34:49 +0100
Lines: 36
Message-ID: <mailman.98.1623946413.4164.python-list@python.org>
References: <alpine.LNX.2.20.2106160928120.6174@salmo.appl-ecosys.com>
<sadea0$kjp$1@ciao.gmane.io>
<alpine.LNX.2.20.2106161343590.6174@salmo.appl-ecosys.com>
<sadtn0$sbq$1@ciao.gmane.io>
<alpine.LNX.2.20.2106161608440.6174@salmo.appl-ecosys.com>
<saf1f9$c7q$1@ciao.gmane.io>
Mime-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Trace: news.uni-berlin.de zrApq9s0T/Pd94Afj3mxsQ8xezdSqUUkklf1i3AaMC/Q==
Return-Path: <python-python-list@m.gmane-mx.org>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
Authentication-Results: mail.python.org; dkim=none reason="no signature";
dkim-adsp=none (unprotected policy); dkim-atps=neutral
X-Spam-Status: OK 0.003
X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; 'tkinter': 0.05; 'url-
ip:65/8': 0.05; 'simple.': 0.07; 'message-id:@ciao.gmane.io':
0.09; 'received:ciao.gmane.io': 0.09; 'received:gmane.io': 0.09;
'received:list': 0.09; 'attributes': 0.16; 'columns': 0.16;
'downside': 0.16; 'fetch': 0.16; 'flickr': 0.16;
'from:addr:alan.gauld': 0.16; 'from:name:alan gauld': 0.16;
'hosts': 0.16; 'photo-blog': 0.16; 'received:116.202': 0.16;
'received:116.202.254': 0.16; 'received:116.202.254.214': 0.16;
'refresh': 0.16; 'shepard': 0.16; 'sounds': 0.16;
'subject:tkinter': 0.16; 'url-ip:79.170.44.132/32': 0.16; 'url-
ip:79.170.44/24': 0.16; 'url-ip:79.170/16': 0.16; 'url-ip:79/8':
0.16; 'url:alan-g': 0.16; 'url:alan_gauld': 0.16;
'url:alangauldphotos': 0.16; 'view.': 0.16; 'wrote:': 0.16;
'modify': 0.20; 'url:amazon': 0.20; "i've": 0.22; 'install': 0.22;
'to:addr:python-list': 0.23; 'run': 0.24; 'done': 0.28; 'mostly':
0.28; 'header:User-Agent:1': 0.31; 'maintain': 0.32; 'program':
0.33; 'header:In-Reply-To:1': 0.33; 'one.': 0.35; 'windows': 0.36;
'at:': 0.37; 'table': 0.37; 'changes': 0.37; "that's": 0.37;
'author': 0.38; 'use': 0.38; 'main': 0.40; 'reason': 0.40;
'could': 0.40; 'ago': 0.40; 'miss': 0.63; 'follow': 0.63; 'your':
0.64; 'too.': 0.65; 'years': 0.67; 'decided': 0.67; 'order': 0.68;
'site': 0.69; 'url:author': 0.69; 'person.': 0.71; 'received:116':
0.71; 'reasons': 0.75; 'database': 0.77; 'contacts': 0.82;
'sqlite': 0.84; 'tables': 0.84; 'holds': 0.91; 'trick': 0.91;
'company,': 0.95
X-Injected-Via-Gmane: http://gmane.org/
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:78.0) Gecko/20100101
Thunderbird/78.8.1
In-Reply-To: <alpine.LNX.2.20.2106161608440.6174@salmo.appl-ecosys.com>
Content-Language: en-GB
X-Mailman-Approved-At: Thu, 17 Jun 2021 12:13:32 -0400
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.34
Precedence: list
List-Id: General discussion list for the Python programming language
<python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>,
<mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <https://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: <https://mail.python.org/mailman/listinfo/python-list>,
<mailto:python-list-request@python.org?subject=subscribe>
X-Mailman-Original-Message-ID: <saf1f9$c7q$1@ciao.gmane.io>
X-Mailman-Original-References: <alpine.LNX.2.20.2106160928120.6174@salmo.appl-ecosys.com>
<sadea0$kjp$1@ciao.gmane.io>
<alpine.LNX.2.20.2106161343590.6174@salmo.appl-ecosys.com>
<sadtn0$sbq$1@ciao.gmane.io>
<alpine.LNX.2.20.2106161608440.6174@salmo.appl-ecosys.com>
 by: Alan Gauld - Thu, 17 Jun 2021 08:34 UTC

On 17/06/2021 00:15, Rich Shepard wrote:

> When I view my contacts table it needs to includes attributes from the
> company, people, and contacts tables so I can view all prior contacts with
> that person.

Sounds like a job for a database view.
Can you modify the database schema? Could you create a
view - even a temporary one just while your app is running?

Alternatively, and I've done this trick myself, create an
in-memory SqlLite database with a table that holds all the
columns you want then fetch the data from the master and
manipulate/view it from Sqlite - this makes sorting by
different columns fast and simple.

The downside is you have to refresh it periodically or
you will miss all changes in the master.

> Many years ago I used wxPython. For several reasons I decided to learn and
> use tkinter from now one. One reason is that the application for my clients
> will run mostly on windows hosts and I want to limit the software they need
> to install and maintain in order to run it.

Sure, that's the main reason I use tkinter too.

--
Alan G
Author of the Learn to Program web site
http://www.alan-g.me.uk/
http://www.amazon.com/author/alan_gauld
Follow my photo-blog on Flickr at:
http://www.flickr.com/photos/alangauldphotos


devel / comp.lang.python / Re: tkinter: tksheet

1
server_pubkey.txt

rocksolid light 0.9.81
clearnet tor