PostgreSQL Discussion - Toolkit for creating editable grid

Author

Toolkit for creating editable grid

Andrus

2005-12-13, 11:23 am

I want to create editable grid (client application) for large Postgres
table:

At startup this grid show first screenful of records and allows to edit
them.
When user presses page down key, this grid should read next screenful of
records and allow to edit them etc.
PgADMIN tries to read the whole table.

Is there any free toolkit or sample application for this ?

Andrus.

Richard Huxton

2005-12-13, 11:23 am

Andrus wrote:
> I want to create editable grid (client application) for large Postgres
> table:
>
> At startup this grid show first screenful of records and allows to edit
> them.
> When user presses page down key, this grid should read next screenful of
> records and allow to edit them etc.
> PgADMIN tries to read the whole table.
>
> Is there any free toolkit or sample application for this ?

Umm - running on what platform? Written in what language?

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Andrus

2005-12-13, 1:23 pm

> Andrus wrote:
>
> Umm - running on what platform?

In Microsoft Windows

> Written in what language?

I'm in progress of selecting development platform.

I prefer major (A status) programming language using classification from
http://www.tiobe.com/tpci.htm

Andrus.

David Welton

2005-12-15, 11:23 am

One thing you might consider is the 'Base' application from
openoffice. I'm not sure it's what you want, but it might work... In
any case it's likely worth looking at.

.... wandering off topic ...
[color=darkred]
> I'm not sure if I would trust a programming language ranking that is based
> on search-engine results. First, a higher rating might indicate that people
> have lots of trouble with the language (Because the search for, and post
> solution-x for the problems).

Well, if they're not using it, they're not going to have problems
either. Having used a slew of programming languages, including some
fancy, less popular ones myself, I am pretty sure that people run into
problems with all of them:-)

> Seconds, _any_ programming language comparision
> that doesn't say in what _context_ or for which _problems_ a language is
> good, and for which it is bad, is worthless IMHO.

Anyone who decides solely by looking at stats is kind of silly. That
said, though, I think there is some validity to these kinds of
things... Here's my attempt at something similar with more data
sources:

http://www.dedasys.com/articles/lan...popularity.html

As I say, though...take things with a grain of salt. I did those
stats with Tcl, and Hecl, which don't figure highly in the results;-)

Saluti,
--
David N. Welton
- http://www.dedasys.com/davidw/

Linux, Open Source Consulting
- http://www.dedasys.com/

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Andrus

2005-12-16, 11:23 am

Florian,

your reply is not is not in news.postgresql.org server.
How to receive all messages using news.postgresql.org server ? It is tedious
to check the newsgroup archives using web interface also.

>pgAdmin3 is written in C++, using the cross-plattform and free
GUI-Toolkit wxwindows (www.wxwindows.org I believe).
pgAdmin3 includes an editable grid-view (right-click a table, and
select "Edit Data").

be able to reuse some code.

pgAdmin does not have ability to fetch next
screenful on page down. It can fetch only first 100 or all rows for
editing.This would me major improvement and I dont have enough knowledge to
add this to pgadmin.

[color=darkred]
> Including C,C++,Visual Basic, PHP and PL/SQL(!) in the _same_ ranking is
just
insane. They serve vastly difference purposes (Just imagine a

"web-application in PL/SQL, "

Why not ?
I can create HTML output from pg/SQL and redirect it to browser.
I hope that XHTML capabilites will be added to Postgres also.

> "a kernel in Visual Basic"

VB has good complier which can be used kernel also.

> "GUI-Applikation in PHP"

To improve imagination you can download Agata Report from
http://www.agata.org.br/us/index.php

This is is GUI application written in PHP which allows to create reports
from Postgres database.

Andrus.

Eric E

2005-12-16, 11:23 am

Has anyone used OpenOffice Base? Just a thought. Or Rekall - it's a
bit immature, but it might do what you want. The dreaded MS Access
can do what you describe in about 4 minutes...

EE

>just
>insane. They serve vastly difference purposes (Just imagine a
>
>"web-application in PL/SQL, "
>
>Why not ?
>I can create HTML output from pg/SQL and redirect it to browser.
>I hope that XHTML capabilites will be added to Postgres also.
>
>
This is a terrible idea. For example, how does a browser request a new
page? There's a plethora of good ways to hook a browser up to a
database, having a webserver built into an RDBMS is not one of them.

>
>To improve imagination you can download Agata Report from
>http://www.agata.org.br/us/index.php
>
>This is is GUI application written in PHP which allows to create reports
>from Postgres database.
>
>
You might also want to look at PHP-Lens, which has a simple form-builder.

Cheers,

EE

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Andrus

2005-12-16, 8:24 pm

Florian,

>
> Bad, but I guess there is nothing I can do about that... I'm subscriber
> of the mailinglist, not of the newsgroup... Sorry..

Your messages are digitally signed.

Maybe this prevents them from distributing using news protocol ?

Andrus.

Scott Marlowe

2005-12-16, 8:24 pm

On Fri, 2005-12-16 at 13:11, Florian G. Pflug wrote:
> Andrus wrote:
>
> Bad, but I guess there is nothing I can do about that... I'm subscriber
> of the mailinglist, not of the newsgroup... Sorry..

You might want to consider setting up a gmail account. It's excellent
for reading email from the web. About 1,000 times nicer than the one
I've used that comes with Exchange Server (when accessing it with
firefox/mozilla)

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Andrus

2005-12-16, 8:24 pm

> Has anyone used OpenOffice Base? Just a thought. Or Rekall - it's a bit
> immature, but it might do what you want. The dreaded MS Access
> can do what you describe in about 4 minutes...

Postgres lacks easy GUI frontend with report generation capabilities like
Access.

To fix this pgAdmin should be implemented in OpenOffice. This will create a
very good Postgres management tool for both administrators and end users.
This reduces the development cost since ready-made OpenOffice components can
be used.

> You might also want to look at PHP-Lens, which has a simple form-builder.

I looked their web site. They have the following suggestion in
http://phplens.com/lens/product/ :
.... , you will need to ALTER TABLE phplens MODIFY id CHAR(40).

MODIFY clause causes error in Postgres. Does this mean that they do'nt
bother about Postgres compatibility at all ?

Andrus

Chris Browne

2005-12-16, 8:24 pm

"Andrus" <eetasoft@online.ee> writes:
>
> Postgres lacks easy GUI frontend with report generation capabilities
> like Access.
>
> To fix this pgAdmin should be implemented in OpenOffice. This will
> create a very good Postgres management tool for both administrators
> and end users. This reduces the development cost since ready-made
> OpenOffice components can be used.

Unfortunately, we don't run OpenOffice.org *or* pgAdmin on any of our
IBM pSeries clusters, so for us, that's a pretty much useless answer.

The folks I'm thinking of here *are* material to the matter, as we
have actually been trying to get some reasonably material budget put
together to come up with a report generation "solution," albeit with a
mandate that it can function in X-less environments.

The above biases aside, OpenOffice.org has seemed terribly heavyweight
any time I have used it for anything database-related.
--
"cbbrowne","@","ntlug.org"
http://cbbrowne.com/info/sgml.html
"Why use Windows, since there is a door?"
-- <fachat@galileo.rhein-neckar.de> Andre Fachat

Andrus

2005-12-19, 11:23 am

> You might want to consider setting up a gmail account. It's excellent
> for reading email from the web. About 1,000 times nicer than the one
> I've used that comes with Exchange Server (when accessing it with
> firefox/mozilla)

Scott,

I need to pgsql.general mails in my notebook offline when there is no
internet connection.

Since some messages does not appear in news.postgresql.org news server, I
must go to
http://archives.postgresql.org/pgsql-general/ and compare all threads one
by one manually and copy missing messages to my local computer.

Is there any simpler solution for offline reading ?

Andrus.

Michelle Konzack

2005-12-22, 9:23 am

Am 2005-12-16 21:52:07, schrieb Andrus:
>
> Postgres lacks easy GUI frontend with report generation capabilities like
> Access.

Sorry, but you compare apples with pears. I can not
remember that the Microsoft SQL Server has such things.

PostgreSQL != Access
PostgreSQL ~ MS SQL Server

Greetings
Michelle

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
####################
# Debian GNU/Linux Consultant ####################
#
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Jim C. Nasby

2005-12-22, 11:23 am

On Thu, Dec 22, 2005 at 03:52:36PM +0100, Michelle Konzack wrote:
> Am 2005-12-16 21:52:07, schrieb Andrus:
>
> Sorry, but you compare apples with pears. I can not
> remember that the Microsoft SQL Server has such things.
>
> PostgreSQL != Access
> PostgreSQL ~ MS SQL Server

Note that many people have had good results by using Access as a
front-end to PostgreSQL.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Michelle Konzack

2005-12-27, 7:23 am

Am 2005-12-22 10:11:48, schrieb Jim C. Nasby:

>
> Note that many people have had good results by using Access as a
> front-end to PostgreSQL.

I have stoped using Windows with WfW 3.11 and Access 2.0

Greetings
Michelle

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
####################
# Debian GNU/Linux Consultant ####################
#
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Sponsored Links