Libpq on iPad?

Has anyone looked at the feasibility of building libpq as a first step towards building
An iPad app that can talk to postgresql dbs ?

Thanks

Jerry

Trapped in Steve Jobs Reality Distortion Field

On 2 Aug 2010, at 00:44, Jerry LeVan <jerry(dot)levan(at)gmail(dot)com> wrote:

> Has anyone looked at the feasibility of building libpq as a first
> step towards building
> An iPad app that can talk to postgresql dbs ?
>
> Thanks
>
> Jerry
>
> Trapped in Steve Jobs Reality Distortion Field
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

I would have thought that only backend apps would talk to pgsql?

Maybe there is a case to allow an ipad app to talk directly to a pgsql
database? Admin work?

On Aug 1, 2010, at 8:00 PM, ABPNI wrote:

>
>
> On 2 Aug 2010, at 00:44, Jerry LeVan <jerry(dot)levan(at)gmail(dot)com> wrote:
>
>> Has anyone looked at the feasibility of building libpq as a first step towards building
>> An iPad app that can talk to postgresql dbs ?
>>
>> Thanks
>>
>> Jerry
>>
>> Trapped in Steve Jobs Reality Distortion Field
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
> I would have thought that only backend apps would talk to pgsql?
>
> Maybe there is a case to allow an ipad app to talk directly to a pgsql database? Admin work?

Once upon a time in a galaxy far, far away, I wrote gui apps ( Cocoa/Python/Tk) that allowed
me to interact with Postgresql databases ( Think stripped down PgAdmin).

It would be nice to be able to do the same on my iPad...but I guess that Python and Tk are
out as developmental tools.

(I have a ssh app that I can use but it is a bit clumsy...)

Jerry

> I would have thought that only backend apps would talk to pgsql?
>
> Maybe there is a case to allow an ipad app to talk directly to a pgsql
> database? Admin work?
>
Postgresql is the backend. An iPad app that uses the database, needs libpq.
If you wanted to scratch the left side of your head with your right
hand, you could build a server script that a web app could talk to using
the http protocol to speak with apache, maybe even with javascript using
ajax on the client.
If you had a web server for your app and didn't want to change it, then
you wouldn't need an iPad app at all, just browser access.

Using a direct client-server model using libpq would be far more efficient

On Aug 1, 2010, at 4:44 PM, Jerry LeVan wrote:

> Has anyone looked at the feasibility of building libpq as a first step towards building
> An iPad app that can talk to postgresql dbs ?

Apparently, yes. http://www.spanware.com/iphonedb/MobileCan/MobileCan.html

ISTR someone discussing it on IRC or on one of the mailing lists, and it being a fairly naive port of libpq to cocoa rather than being a new native implementation of the protocol.

If you google for "iphone postgresql" you'll find a fair bit of discussion, and some example build scripts for libpq on iphone.

The EnterpriseDB folks also did an iphone friendly webapp as part of stackbuilder, I think.

Cheers,
Steve