Thread: Re: development language

What about Python / wxPython and PyPgSQL?

I am using this now for a dental office managment programm. The programm runs
on Linux and Windows. The GNU-Med project too uses Python, wxPython, PyPgSQL
and PostgreSQL.

Before comming to Python/wxPython, I tryed Java but had to stop using it because
I found the Java Swing grid widget to be useless. (I needed a varying row
heigh and more, which Java swing did not have).

Python / wxPython works really great, although it took/takes some time to learn.

Bruce Eckel (Thinking in Java, Thinking in C) wrote that programming (and
maintaining programms) in Python is a about 10 times as fast as in C, and much
faster and easier than in Java
Robin Dunn's, the maintainer of wxPython.org has the following slogan:

Java give you jitters?  Relax with wxPython!

I guess it's right. I would appreciate a pgAdmin project based on
Python/wxPython since than I could and would contribute.

Christoph Becker

dave,

pga3 question

i can tell system columns easily (and hopefully correctly):

    // We need to know if we're going to show system objects
    wxString sysobjstr;
    if (!settings->GetShowSystemObjects())
        sysobjstr = " WHERE attnum >= 0 ";

but is this an adequate way to check for system tables/views? this is what
i'm using now.

    // We need to know if we're going to show system objects
    wxString sysobjstr;
    if (!settings->GetShowSystemObjects())
        sysobjstr = " AND relowner >= 1 ";

the other way i was going to do it was if the first three letters are "PG_"
but maybe you have a more correct way of doing this.

-keith

correction

relowner > 1 instead of >=1

    // We need to know if we're going to show system objects
    wxString sysobjstr;
    if (!settings->GetShowSystemObjects())
        sysobjstr = " AND relowner > 1 ";

-----Original Message-----
From: efesar [mailto:efesar@nmia.com]
Sent: Monday, March 03, 2003 5:18 PM
To: pgadmin-hackers
Subject: query builder / system objects



dave,

pga3 question

i can tell system columns easily (and hopefully correctly):

    // We need to know if we're going to show system objects
    wxString sysobjstr;
    if (!settings->GetShowSystemObjects())
        sysobjstr = " WHERE attnum >= 0 ";

but is this an adequate way to check for system tables/views? this is what
i'm using now.

    // We need to know if we're going to show system objects
    wxString sysobjstr;
    if (!settings->GetShowSystemObjects())
        sysobjstr = " AND relowner >= 1 ";

the other way i was going to do it was if the first three letters are "PG_"
but maybe you have a more correct way of doing this.

-keith