Re: Postgresql Windows ODBC - Mailing list pgsql-general

From Tony Caduto
Subject Re: Postgresql Windows ODBC
Date
Msg-id 42690345.9070102@amsoftwaredesign.com
Whole thread Raw
In response to Re: Postgresql Windows ODBC  (John DeSoi <desoi@pgedit.com>)
List pgsql-general
In my opinion the easiest language for any database development is
Borland Delphi bar NONE.
You can get the pro version for for 499.99 as a upgrade or a personal
editon is also available for free or little cost.
You might even be able to get a copy of Delphi 7 on ebay for much less.

For Postgres development I use the Zeos components(www.zeoslib.net) and
PostgresDAC(www.micoolap.com).

Here is a quick example of how to execute a query with params in Delphi
with a tdataset compatible query component.

myquery.clear;
myquery.add('select firstname from companyinfo where lastname = :PARAM1');
parambyname('PARAM1').asstring:= 'smith';
myquery.open;

At this point if you have bound the query to a grid you will see the
data, or you could loop through the result set like this:

myquery.first;
while not myquery.eof do
   begin
         showmessage(myquery.fieldbyname('firstname').asstring);
         myquery.next;
   end;

The above code also works on Oracle, MS SQL, Mysql, DB2 etc etc as long
as you use a tdataset compatible component set.

I have used C#, VB.net and VB classic and NONE of them are as easy and
intuitive to use for database development as Delphi  NONE.

Delphi 2005 also includes Delphi.net and C# along with native win32
development in pascal, you can also use the Kylix with the Zeos
components for development on Linux, and while there has not been a
update to Kylix in awhile, it still works great.

You can do lots more stuff with Delphi as well, just about anything you
could do in C or C++ minus device drivers.


Tony Caduto
AM Software Design
Home of PG Lightning Admin for Postgresql 8.x
http://www.amsoftwaredesign.com



>> ?
>>
>> In Windows, what would you say is the easiest language to use which
>> can talk to Postgresql? Just curious....    e.g. I have Liberty Basic
>> which is very easy, but does not easily support ODBC...
>>
>> Is anyone working with some form of Python on Windows.  I downloaded
>> Python, but it seems to run only in some DOS window. I mentioned this
>> on a Dreamcard/Revolution board, and they said "Oh, you want PYTHON
>> CARD."
>>
>> Anyway, I would be interested to learn of an easy language which can
>> access Postgresql, together with some decent examples or tutorials to
>> get me going.  I have a feeling that Realbasic will do the trick.
>
>
>


pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: Install development headers/libraries Win32 v 8.0.2
Next
From: "Jeff Eckermann"
Date:
Subject: Re: psqlodbc MSAccess and Postgresql