From kinyage_tony@yahoo.com Thu Jun 29 13:40:31 2006 X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 709159FA4A5 for ; Thu, 29 Jun 2006 10:40:31 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 94024-08 for ; Thu, 29 Jun 2006 10:40:26 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web51908.mail.yahoo.com (web51908.mail.yahoo.com [206.190.48.71]) by postgresql.org (Postfix) with SMTP id 54F109FA081 for ; Thu, 29 Jun 2006 10:40:26 -0300 (ADT) Received: (qmail 29095 invoked by uid 60001); 29 Jun 2006 13:40:24 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=Lwu4GwytA2mzu7iQupR+BSbYax8EsUSMsnrtPczoKJXvfeFCRkZy4/TXcXkO5u93XVfyudxNOOf2xc6+0PiYdyAj1a1VH+oqsac1WvXxJ6lTv9hiwOr/gdNGvNPq2FrWNzNXigpmlfqYouuGuJirJNkT5dx+CV86/E4eXFKhB0Q= ; Message-ID: <20060629134023.29093.qmail@web51908.mail.yahoo.com> Received: from [203.181.127.181] by web51908.mail.yahoo.com via HTTP; Thu, 29 Jun 2006 14:40:23 BST Date: Thu, 29 Jun 2006 14:40:23 +0100 (BST) From: Anthony Kinyage Subject: Data Entry and Query forms To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1414268042-1151588423=:27883" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/313 X-Sequence-Number: 25549 --0-1414268042-1151588423=:27883 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Hi I am new in PostgreSQL, I have just installed and created a database, I use MS-SQL 2000 and planning to Migrate to Open Source. PostgreSQL is installed on Linux Redhat Server. We have 50 Clients PC using WinXP. Before continuing our Plans, I need to know how can I do with PostgreSQL in order to have Data Entry and Query Forms on clients side (How can I design Data Entry and Query Forms). If you can advice me the open source Software to add on PostgreSQL to solve my problem will be better. This will help the Management to accept PostgreSQL and plan Migration from MS-SQL 2000. Thanx Anthony Kinyage --------------------------------- Try the all-new Yahoo! Mail . "The New Version is radically easier to use" – The Wall Street Journal --0-1414268042-1151588423=:27883 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit
Hi
I am new in PostgreSQL, I have just installed and created a database, I use MS-SQL 2000 and planning to  Migrate to Open Source.
 
PostgreSQL  is installed  on Linux Redhat Server. We have 50 Clients PC using WinXP.
 
Before continuing our Plans, I need to know how can I do with PostgreSQL in order to have Data Entry and Query Forms on clients side (How can I design Data Entry and Query Forms).
 
If you can advice me the open source Software to add on PostgreSQL to solve my problem will be better.
 
This will help the Management to accept PostgreSQL and plan Migration from
MS-SQL 2000.
 
Thanx
 
Anthony Kinyage


Try the all-new Yahoo! Mail . "The New Version is radically easier to use" – The Wall Street Journal --0-1414268042-1151588423=:27883-- From schabi@logix-tt.com Thu Jun 29 13:50:20 2006 X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 2CD049FA4A5 for ; Thu, 29 Jun 2006 10:50:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 94560-10 for ; Thu, 29 Jun 2006 10:50:13 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.logix-tt.com (mail.logix-tt.com [212.211.145.186]) by postgresql.org (Postfix) with ESMTP id 3618A9FA081 for ; Thu, 29 Jun 2006 10:50:12 -0300 (ADT) Received: from kingfisher.intern.logix-tt.com (T82eb.t.pppool.de [89.55.130.235]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logix-tt.com (Postfix) with ESMTP id 5E9DC65875; Thu, 29 Jun 2006 15:51:48 +0200 (CEST) Received: from [127.0.0.1] (localhost [127.0.0.1]) by kingfisher.intern.logix-tt.com (Postfix) with ESMTP id BBCE4184DBA09; Thu, 29 Jun 2006 15:50:21 +0200 (CEST) Message-ID: <44A3DA9D.2040909@logix-tt.com> Date: Thu, 29 Jun 2006 15:50:21 +0200 From: Markus Schaber Organization: Logical Tracking and Tracing International AG, Switzerland User-Agent: Thunderbird 1.5.0.2 (X11/20060516) MIME-Version: 1.0 To: Anthony Kinyage Cc: pgsql-sql@postgresql.org Subject: Re: Data Entry and Query forms References: <20060629134023.29093.qmail@web51908.mail.yahoo.com> In-Reply-To: <20060629134023.29093.qmail@web51908.mail.yahoo.com> X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=ISO-8859-15 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/314 X-Sequence-Number: 25550 Hi, Anthony, Anthony Kinyage wrote: > Before continuing our Plans, I need to know how can I do with PostgreSQL > in order to have Data Entry and Query Forms on clients side (How can I > design Data Entry and Query Forms). PostgreSQL itsself is a database server, not a front-end form designer. However, using the PostgreSQL ODBC driver, you should be able to continue using your current front-ends (like Access). If you don't like this, maybe you can look at GNU Enterprise, OpenOffice.org database module, Delphi/Kylix or others. (I admit I've used none of those yet, we use PostgreSQL as backend for "real" applications.) HTH, Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org From postgresql@aranya.com Thu Jun 29 15:42:04 2006 X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 8CA5D9FA081 for ; Thu, 29 Jun 2006 12:42:04 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 09551-08 for ; Thu, 29 Jun 2006 12:41:59 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.172]) by postgresql.org (Postfix) with ESMTP id 141F69FA4A5 for ; Thu, 29 Jun 2006 12:41:58 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id a2so400877ugf for ; Thu, 29 Jun 2006 08:41:57 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:sender:to:subject:cc:in-reply-to:mime-version:content-type:references:x-google-sender-auth; b=EY6lFUfUUaSeyU5qzwL4fVZSjdmJDqvM3Nwk0m4DPrfNDEyLEvQyEz1U+tK9bin94ksOYTyg5Wdm94uxyp6TDWEa7ZxzqrM1Izfi4j/f11MJKLxCUBiq/Z68AicN+CVeLlt2GDV+ltbXiHCrIl/O6bzauuLbRpaXgybS5MtG7zo= Received: by 10.78.140.17 with SMTP id n17mr1026846hud; Thu, 29 Jun 2006 08:41:57 -0700 (PDT) Received: by 10.78.29.2 with HTTP; Thu, 29 Jun 2006 08:41:57 -0700 (PDT) Message-ID: Date: Thu, 29 Jun 2006 10:41:57 -0500 From: "Aaron Bono" To: "Markus Schaber" Subject: Re: Data Entry and Query forms Cc: "Anthony Kinyage" , pgsql-sql@postgresql.org In-Reply-To: <44A3DA9D.2040909@logix-tt.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_22036_29840903.1151595717472" References: <20060629134023.29093.qmail@web51908.mail.yahoo.com> <44A3DA9D.2040909@logix-tt.com> X-Google-Sender-Auth: 12e31bad940692b8 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/317 X-Sequence-Number: 25553 ------=_Part_22036_29840903.1151595717472 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline I agree, using ODBC is probably a good first step. Especially for M$Access. For developers I recommend the EMS Manager tools. They are a commercial product but I have been very pleased with them and we use the tools every day. They are not exactly like SQL Manager but they serve the same purpose. See http://www.sqlmanager.net/ . Are there any web based management tools for PostgreSQL (like Mysql PHP Admin except for PostgreSQL)? I thought I saw a post sometime back about one but don't remember the name. -Aaron On 6/29/06, Markus Schaber wrote: > > Hi, Anthony, > > Anthony Kinyage wrote: > > > Before continuing our Plans, I need to know how can I do with PostgreSQL > > in order to have Data Entry and Query Forms on clients side (How can I > > design Data Entry and Query Forms). > > PostgreSQL itsself is a database server, not a front-end form designer. > > However, using the PostgreSQL ODBC driver, you should be able to > continue using your current front-ends (like Access). > > If you don't like this, maybe you can look at GNU Enterprise, > OpenOffice.org database module, Delphi/Kylix or others. (I admit I've > used none of those yet, we use PostgreSQL as backend for "real" > applications.) > > HTH, > Markus > > -- > Markus Schaber | Logical Tracking&Tracing International AG > Dipl. Inf. | Software Development GIS > > Fight against software patents in EU! www.ffii.org > www.nosoftwarepatents.org > > ------=_Part_22036_29840903.1151595717472 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I agree, using ODBC is probably a good first step.  Especially for M$Access.

For developers I recommend the EMS Manager tools.  They are a commercial product but I have been very pleased with them and we use the tools every day.  They are not exactly like SQL Manager but they serve the same purpose.  See http://www.sqlmanager.net/ .

Are there any web based management tools for PostgreSQL (like Mysql PHP Admin except for PostgreSQL)?  I thought I saw a post sometime back about one but don't remember the name.

-Aaron

On 6/29/06, Markus Schaber <schabi@logix-tt.com> wrote:
Hi, Anthony,

Anthony Kinyage wrote:

> Before continuing our Plans, I need to know how can I do with PostgreSQL
> in order to have Data Entry and Query Forms on clients side (How can I
> design Data Entry and Query Forms).

PostgreSQL itsself is a database server, not a front-end form designer.

However, using the PostgreSQL ODBC driver, you should be able to
continue using your current front-ends (like Access).

If you don't like this, maybe you can look at GNU Enterprise,
OpenOffice.org database module, Delphi/Kylix or others. (I admit I've
used none of those yet, we use PostgreSQL as backend for "real"
applications.)

HTH,
Markus

--
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org

------=_Part_22036_29840903.1151595717472-- From dev@freedomcircle.net Thu Jun 29 15:58:23 2006 X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 57CC69FA4A5 for ; Thu, 29 Jun 2006 12:58:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 13528-02 for ; Thu, 29 Jun 2006 12:58:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from vms040pub.verizon.net (vms040pub.verizon.net [206.46.252.40]) by postgresql.org (Postfix) with ESMTP id BD7E39FA081 for ; Thu, 29 Jun 2006 12:58:12 -0300 (ADT) Received: from [192.168.7.2] ([71.101.5.108]) by vms040.mailsrvcs.net (Sun Java System Messaging Server 6.2-4.02 (built Sep 9 2005)) with ESMTPA id <0J1M00038PMSS444@vms040.mailsrvcs.net> for pgsql-sql@postgresql.org; Thu, 29 Jun 2006 10:56:53 -0500 (CDT) Date: Thu, 29 Jun 2006 11:57:56 -0400 From: Joe Subject: Re: Data Entry and Query forms In-reply-to: To: Aaron Bono Cc: Markus Schaber , Anthony Kinyage , pgsql-sql@postgresql.org Message-id: <44A3F884.7020608@freedomcircle.net> Organization: Freedom Circle, LLC MIME-version: 1.0 Content-type: text/plain; charset=ISO-8859-1; format=flowed Content-transfer-encoding: 7bit References: <20060629134023.29093.qmail@web51908.mail.yahoo.com> <44A3DA9D.2040909@logix-tt.com> User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/318 X-Sequence-Number: 25554 Aaron Bono wrote: > Are there any web based management tools for PostgreSQL (like Mysql PHP > Admin except for PostgreSQL)? I thought I saw a post sometime back > about one but don't remember the name. Yes, that's phpPgAdmin (http://phppgadmin.com). Joe From operationsengineer1@yahoo.com Thu Jun 29 18:09:47 2006 X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C7A239FA31F for ; Thu, 29 Jun 2006 15:09:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 26207-10 for ; Thu, 29 Jun 2006 15:09:42 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web33310.mail.mud.yahoo.com (web33310.mail.mud.yahoo.com [68.142.206.125]) by postgresql.org (Postfix) with SMTP id 8290F9FA081 for ; Thu, 29 Jun 2006 15:09:42 -0300 (ADT) Received: (qmail 1908 invoked by uid 60001); 29 Jun 2006 18:02:44 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=Ri4lEuy+H4dBvrvyUgiG5Jw9cfuMK4zIjEyVKGplBQnzTY4E2WrIXH/8TkYXx0ztPrNqJuXyOAhaMdee8ZoMsyX8h5KumqzzIZMRbpMvAPWKQfzeUMtLKi8WQOObzZNL+xsnO7ozb4xXJ8sEoEZJEwyhU2Rvfwlfl5+G32df9Xk= ; Message-ID: <20060629180244.1906.qmail@web33310.mail.mud.yahoo.com> Received: from [12.9.179.126] by web33310.mail.mud.yahoo.com via HTTP; Thu, 29 Jun 2006 11:02:44 PDT Date: Thu, 29 Jun 2006 11:02:44 -0700 (PDT) From: Subject: Re: Data Entry and Query forms To: Anthony Kinyage , pgsql-sql@postgresql.org In-Reply-To: <20060629134023.29093.qmail@web51908.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/319 X-Sequence-Number: 25555 > Hi > I am new in PostgreSQL, I have just installed and > created a database, I use MS-SQL 2000 and planning > to Migrate to Open Source. > > PostgreSQL is installed on Linux Redhat Server. > We have 50 Clients PC using WinXP. > > Before continuing our Plans, I need to know how > can I do with PostgreSQL in order to have Data Entry > and Query Forms on clients side (How can I design > Data Entry and Query Forms). > > If you can advice me the open source Software to > add on PostgreSQL to solve my problem will be > better. > > This will help the Management to accept PostgreSQL > and plan Migration from > MS-SQL 2000. > > Thanx > > Anthony Kinyage Anthony, welcome to the world of open source! you can continue to use windows programs (like msaccess) as your front end by connecting with odbc. however, i chose to use php (open source, too), html and css. it has worked out well. i use two php classes that have pretty dramatically increased my productivity. 1. Manuel Lemos' forms class (phpclasses.org) - this is a powerful class that enables lots of useful forms features. 2. adodb db abstraction layer php is relatively easy to pick up if someone has a desire to do so. i could even send you sample scripts to help guide you get started with adodb, the forms class and the code layout structure. i'm seriously looking into migrating my skills over to ruby on rails. you can review some screencasts here: http://www.rubyonrails.org/screencasts i'll be using postgresql as my db for any rails projects, too (many people use mysql). once one becomes proficient in ruby (language) and rails (framework), development becomes more efficient for many apps. many of the concepts (including object oriented programming) are more complex and require more up front planning - which may be more difficult for someone new to OO programming. so, i think php and ruby on rails would both likely work as front end programming languages / frameworks. of course, you'd need to work in html and css to display a layout. cross browser css code is difficult, but if you were interested, i will let you know about a resource that will help you a lot. good luck. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com From jure@plsavez.hr Fri Jun 30 10:16:27 2006 X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D45EB9FA4A7 for ; Fri, 30 Jun 2006 07:16:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 39746-04 for ; Fri, 30 Jun 2006 07:16:10 -0300 (ADT) X-Greylist: delayed 00:24:29.217789 by SQLgrey- Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 0F6319FA6B3 for ; Fri, 30 Jun 2006 07:16:01 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from avs2.arnes.si (avs2.arnes.si [193.2.1.75]) by svr4.postgresql.org (Postfix) with ESMTP id 9B6E45AF054 for ; Fri, 30 Jun 2006 09:51:31 +0000 (GMT) Received: from localhost (unknown [193.2.1.75]) by avs2.arnes.si (Postfix) with ESMTP id 7D0DD4703DF; Fri, 30 Jun 2006 11:51:28 +0200 (CEST) Received: from avs2.arnes.si ([193.2.1.75]) by localhost (avs2.arnes.si [193.2.1.75]) (amavisd-new, port 10024) with ESMTP id 29692-04; Fri, 30 Jun 2006 11:51:28 +0200 (CEST) Received: from dhcp-212-235-229-194.sd.uni-lj.si (unknown [212.235.229.194]) by avs2.arnes.si (Postfix) with ESMTP id 0FC904703CC; Fri, 30 Jun 2006 11:51:26 +0200 (CEST) Subject: Re: Data Entry and Query forms From: Jure Kodzoman To: Anthony Kinyage Cc: pgsql-sql@postgresql.org In-Reply-To: <20060629134023.29093.qmail@web51908.mail.yahoo.com> References: <20060629134023.29093.qmail@web51908.mail.yahoo.com> Content-Type: text/plain Organization: Hrvatski planinarski savez Date: Fri, 30 Jun 2006 11:51:25 +0200 Message-Id: <1151661085.5464.9.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.6.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at arnes.si X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/329 X-Sequence-Number: 25565 > > Before continuing our Plans, I need to know how can I do with > PostgreSQL in order to have Data Entry and Query Forms on clients side > (How can I design Data Entry and Query Forms). > Hy. You could try using BOND framework which works for both linux and win32. It is rather bad documented but is also very simple to use, and there are examples. Mailing list is low traffic, but if you ask you will get your anwser quick. The BOND developers are great guys, really :) The link is http://www.treshna.com/bond/ the is also gnue, which is longer in production, and offers more features at the moment, but requires some python knowledge http://www.gnuenterprise.org/ Hope this helps and welcome to the wonderful world of opensource, Jure