(I thought this was the closest forum where I could ask, but if
there's a better one, please tell me)
Hello
I'm learning about wxWidgets/wxPython, but before I go further, I need
to know what my options are regarding grid objects to display stuff
from a database. I write business apps, so a good grid is critical.
If no commercial offerings are available, are there grid objects that
come close to eg. DevExpress' QuantumGrid for Delphi?
Also, provided there are good objects available as wxWidgets but
haven't been made available for wxPython yet, can a newbie still
easily manage to write the ad hoc code and use those objects from
Python?
(I thought this was the closest forum where I could ask, but if
there's a better one, please tell me)
Hello
I'm learning about wxWidgets/wxPython, but before I go further, I need
to know what my options are regarding grid objects to display stuff
from a database. I write business apps, so a good grid is critical.
If no commercial offerings are available, are there grid objects that
come close to eg. DevExpress' QuantumGrid for Delphi?
Have you looked at the demo? If you load the demo and then search
in the search box for "grid" you can see what's available. I don't think
you can get that sort of grid within a grid display with wxPython. You
might be able to work something up that is sort of similar to the effect
shown by using multiple grids or popping up a new frame, but it would
not be within one grid object, AFAIK.
Also, provided there are good objects available as wxWidgets but
haven't been made available for wxPython yet, can a newbie still
easily manage to write the ad hoc code and use those objects from
Python?
I don't think so. I haven't read any discussion of that on the list ever,
but I really don't know what it entails. You may require a special
amulet that only Robin possesses.
Che
···
On Fri, Oct 23, 2009 at 11:24 AM, Fred <frdtheman@gmail.com> wrote:
(I thought this was the closest forum where I could ask, but if
there's a better one, please tell me)
Hello
I'm learning about wxWidgets/wxPython, but before I go further, I need
to know what my options are regarding grid objects to display stuff
from a database. I write business apps, so a good grid is critical.
If no commercial offerings are available, are there grid objects that
come close to eg. DevExpress' QuantumGrid for Delphi?
Have you looked at the demo? If you load the demo and then search
in the search box for "grid" you can see what's available. I don't think
you can get that sort of grid within a grid display with wxPython. You
might be able to work something up that is sort of similar to the effect
shown by using multiple grids or popping up a new frame, but it would
not be within one grid object, AFAIK.
I am not a wxGrid guru, but as far as I understand building that kind
of grid layout using wxWidgets/wxPython would be extremely hard at
best and plainly impossible at worst. Even assuming that someone
ported wxGrid to Python ( ) so that we could hack the source and
add as many features as we want, the C++ version gives us a high
performance widget which will undoubtely be far slower and sloppier in
pure Python.
Anyway, the screenshot is very nice and it would be nice if wxGrid
supported that kind of feature, but I am not sure how many wxPython
users are actually looking for such a specific and corner-case
feature.
I believe you could end up with something similar to that using a
hypertreelist and grids.
Someone else might be able to say with more authority whether or not
this is correct.
- michael
···
On Oct 23, 11:22 am, Andrea Gavana <andrea.gav...@gmail.com> wrote:
Hi,
2009/10/23 C M:
> On Fri, Oct 23, 2009 at 11:24 AM, Fred <frdthe...@gmail.com> wrote:
>> (I thought this was the closest forum where I could ask, but if
>> there's a better one, please tell me)
>> Hello
>> I'm learning about wxWidgets/wxPython, but before I go further, I need
>> to know what my options are regarding grid objects to display stuff
>> from a database. I write business apps, so a good grid is critical.
>> If no commercial offerings are available, are there grid objects that
>> come close to eg. DevExpress' QuantumGrid for Delphi?
> Have you looked at the demo? If you load the demo and then search
> in the search box for "grid" you can see what's available. I don't think
> you can get that sort of grid within a grid display with wxPython. You
> might be able to work something up that is sort of similar to the effect
> shown by using multiple grids or popping up a new frame, but it would
> not be within one grid object, AFAIK.
I am not a wxGrid guru, but as far as I understand building that kind
of grid layout using wxWidgets/wxPython would be extremely hard at
best and plainly impossible at worst. Even assuming that someone
ported wxGrid to Python ( ) so that we could hack the source and
add as many features as we want, the C++ version gives us a high
performance widget which will undoubtely be far slower and sloppier in
pure Python.
Anyway, the screenshot is very nice and it would be nice if wxGrid
supported that kind of feature, but I am not sure how many wxPython
users are actually looking for such a specific and corner-case
feature.
Dabo has a nice high level wrapper of wxGrid that is database centric
and performs well. Download dabo and then run the Appwizard against
your database for a two minute demo.
Sorry for the top posting, I haven't figured out how to deal with it
on my iPhone yet.
Paul
···
On Oct 23, 2009, at 10:24, michael h <michaelkenth@gmail.com> wrote:
I believe you could end up with something similar to that using a
hypertreelist and grids.
Someone else might be able to say with more authority whether or not
this is correct.
- michael
On Oct 23, 11:22 am, Andrea Gavana <andrea.gav...@gmail.com> wrote:
Hi,
2009/10/23 C M:
On Fri, Oct 23, 2009 at 11:24 AM, Fred <frdthe...@gmail.com> wrote:
(I thought this was the closest forum where I could ask, but if
there's a better one, please tell me)
Hello
I'm learning about wxWidgets/wxPython, but before I go further, I
need
to know what my options are regarding grid objects to display stuff
from a database. I write business apps, so a good grid is critical.
If no commercial offerings are available, are there grid objects
that
come close to eg. DevExpress' QuantumGrid for Delphi?
Have you looked at the demo? If you load the demo and then search
in the search box for "grid" you can see what's available. I
don't think
you can get that sort of grid within a grid display with
wxPython. You
might be able to work something up that is sort of similar to the
effect
shown by using multiple grids or popping up a new frame, but it
would
not be within one grid object, AFAIK.
I am not a wxGrid guru, but as far as I understand building that kind
of grid layout using wxWidgets/wxPython would be extremely hard at
best and plainly impossible at worst. Even assuming that someone
ported wxGrid to Python ( ) so that we could hack the source and
add as many features as we want, the C++ version gives us a high
performance widget which will undoubtely be far slower and sloppier
in
pure Python.
Anyway, the screenshot is very nice and it would be nice if wxGrid
supported that kind of feature, but I am not sure how many wxPython
users are actually looking for such a specific and corner-case
feature.
Anyway, the screenshot is very nice and it would be nice if wxGrid
supported that kind of feature, but I am not sure how many wxPython
users are actually looking for such a specific and corner-case
feature.
I wouldn't use wxGrid, but wxTreeListCtrl for browsing master/detail relationships in a database.
Which, btw., is not at all a "corner-case" feature for developing desktop (non-web) database applications, but rather a "bread-and-butter" feature. Another such "bread-and-butter" feature would be a multi-dimension-table like wxAdvTable.
Anyway, if you're developing database applications, better use Dabo than "pure" wxPython.
Anyway, the screenshot is very nice and it would be nice if wxGrid
supported that kind of feature, but I am not sure how many wxPython
users are actually looking for such a specific and corner-case
feature.
I wouldn't use wxGrid, but wxTreeListCtrl for browsing master/detail relationships in a database.
There is no way in the world to make wxTreeListCtrl behave like the
screenshot provided. As Michael said, you may use HyperTreeList but
then you may want to add a wxGrid to every row in HyperTreeList, and
if you even have few hundreds rows it will suck up all the resources
in your system (at least on Windows).
Which, btw., is not at all a "corner-case" feature for developing desktop (non-web) database applications, but rather a "bread-and-butter" feature. Another such "bread-and-butter" feature would be a multi-dimension-table like wxAdvTable.
I was referring to the screenshot only: I do work with databases but I
have never needed such a feature. In any case, it was just my opinion
and the fact that no one has ever asked for it before.
>> Anyway, the screenshot is very nice and it would be nice if wxGrid
>> supported that kind of feature, but I am not sure how many wxPython
>> users are actually looking for such a specific and corner-case
>> feature.
> I wouldn't use wxGrid, but wxTreeListCtrl for browsing master/detail relationships in a database.
There is no way in the world to make wxTreeListCtrl behave like the
screenshot provided. As Michael said, you may use HyperTreeList but
then you may want to add a wxGrid to every row in HyperTreeList, and
if you even have few hundreds rows it will suck up all the resources
in your system (at least on Windows).
> Which, btw., is not at all a "corner-case" feature for developing desktop (non-web) database applications, but rather a "bread-and-butter" feature. Another such "bread-and-butter" feature would be a multi-dimension-table like wxAdvTable.
I was referring to the screenshot only: I do work with databases but I
have never needed such a feature. In any case, it was just my opinion
and the fact that no one has ever asked for it before.
Based on the demo, wxGrid looks very basic, and unless there are other
grids for wxWidgets, I'm not sure it's good enough for applications
that use grids to display data in different ways.
As for using Dabo for increased features for wxGrid, I'm concerned
about adding yet another layer, and also, the fact that only two
people are working on this project :-/
···
On Oct 26, 7:25 pm, michael h <michaelke...@gmail.com> wrote:
I guess I was more thinking that the grids would be created on demand
and destroyed when collapsed...Again, i'm not sure if this is
feasible...
As for using Dabo for increased features for wxGrid, I'm concerned
about adding yet another layer,
What are your concerns about adding a layer, when that layer makes it possible to use the lower-down toolkit in a higher-level fashion, without sacrificing runtime performance? [1]
Sure, we are still fixing things and adding things.
Sure, we haven't wrapped everything in wx, but we also don't keep you from instantiating wxPython objects and making them parents or children of Dabo objects. We don't forbid you from calling the wxPython methods instead of the Dabo methods or properties.
and also, the fact that only two
people are working on this project :-/
There are two founders, but 15 committers, probably 5 semi-active, and 79 subscribers to the dabo-dev mailing list (255 to the dabo-users list). We've been around over 5 years now, and I've been using Dabo in my desktop commercial apps for around 3 years.
There's more to do (always will be) and we'd welcome more help.
Paul
[1] Nobody's complained that raw wxPython is faster than Dabo. I'd say there is a performance penalty, but probably only on object instantiation, and it doesn't add up to anything meaningful.
I didn't mean to offend anyone with the above. It's just that I need
to find a good alternative to move on from VBClassic that is already
mature because I don't have time/brain to improve tools that are still
under development.
Thanks everyone for the great feedback.
PS: I tried running Dabo to try its demo and check the improvements
made to wxGrid, but after prompting the user to download the latest
version of the framework, it just disappeared, and nothing happened
after double-clicking on daborun.exe to run the demo again.
I went through Task Manager to see if there was something that looked
liked Dabo-related, but didn't find anything. Unfortunately, I have
too much stuff up and running at this point to reboot Windows and try
again.
···
On Oct 27, 9:35 pm, Paul McNett <p...@ulmcnett.com> wrote:
What are your concerns about adding a layer, when that layer makes it possible to use the lower-down toolkit in a higher-level fashion, without sacrificing runtime performance? [1]
What are your concerns about adding a layer, when that layer makes it possible to use the lower-down toolkit in a higher-level fashion, without sacrificing runtime performance? [1]
I didn't mean to offend anyone with the above. It's just that I need
to find a good alternative to move on from VBClassic that is already
mature because I don't have time/brain to improve tools that are still
under development.
Don't worry, I wasn't offended, just wondering at the concern over adding a layer.
I think you aren't being realistic though in finding an alternative to classic VB: All tools everywhere are still under development, unless they aren't, in which case they are dead. I have a hunch you may be better off doing VB.NET, IOW a mature (well, as mature as they come) commercial environment.
PS: I tried running Dabo to try its demo and check the improvements
made to wxGrid, but after prompting the user to download the latest
version of the framework, it just disappeared, and nothing happened
after double-clicking on daborun.exe to run the demo again.
I went through Task Manager to see if there was something that looked
liked Dabo-related, but didn't find anything. Unfortunately, I have
too much stuff up and running at this point to reboot Windows and try
again.
Thanks for the report. Apparently daborun.exe hasn't been updated since 0.8.1 (current version is 0.9.2) and is unfortunately incompatible with the current web update service. We are going to be updating daborun.exe over the next few days, but in the meantime if you want to try Dabo again, just download the latest release and install it. You likely already have all the prerequisites installed anyway.
Paul
···
On Oct 27, 9:35 pm, Paul McNett <p...@ulmcnett.com> wrote:
