Search Postgresql Archives

Re: Postgresql Windows ODBC

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.





---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux