[AccessD] python - getting started

On that note; I have been told that running an Access FE to Postgres using
pass-through through queries is painful... It was further suggested that all
database SQL should be run through PGs' SPs.

Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Saturday, May 05, 2007 6:03 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] python - getting started

Guilty, your honour.

There's a version of Python that runs on .NET, but before suggesting that
you go there, the first thing I would do in your place is satisfy yourself
that it's not PostGres that is responsible for your performance problems.
What happens performance-wise if you create an Access FE and an ODBC link
and do direct queries against the database? How is performance there?

Arthur


On 5/5/07, Bruce Bruen <bbruen at unwired.com.au> wrote:
>
> hi all,
> someone mentioned python a few minutes ago, ?arthur?
>
> whoever it was, have they got a link for a decent howto or getting
> started?
>
> I'm looking to port an A2K3 to (ahem) a more "significant" platform.  The
> data
> has already been ported to postgresql and after some hysteria is now ANSI
> compliant.  The FE exists in access and has been partially ported to C#,
> but
> I'm not really happy with the C# implementation.  The data abstraction is
> a
> PITA (waiting hopefully on Charlottes tutorial), the performance is
> somewhat
> slack from a perception basis (i.e. perceptively slower than
> access-postgres
> and bordering on infuriatingly slower than access FE/BE architecture) and
> the
> IDE's are all a royal PITA (VB5, eclipse and #develop), as mentioned
> elsewhere they all want to / support direct data binding.
>
> I have read some (i.e. 1-2%) of the available info on python and it looks
> pretty rich, but is there something between HelloWorld and pyQt?
>
> --
> regards
>
> Bruce
>
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com