Re: pgsql on a PDA running Microsoft CE

<div align="left"><font face="Arial" size="2"> <span style=" font-size:10pt"> I think you
mis-understood...</span></font></div><divalign="left"><font face="Arial" size="2"> <span style=" font-size:10pt"><br
/></span></font></div><div align="left"><font face="Arial" size="2"> <span style=" font-size:10pt"> The think I wish to
dois: ACCESSING a Postgres/PostGIS database.</span></font></div><div align="left"><font face="Arial" size="2"> <span
style="font-size:10pt"><br /></span> </font></div><div align="left"><font face="Arial" size="2"> <span style="
font-size:10pt">PDAs and Pocket PCs run .NET CF but npgslq Provider doesn't support this
platform.</span></font></div><divalign="left"><font face="Arial" size="2"> <span style=" font-size:10pt"><br /></span>
</font></div><divalign="left"><font face="Arial" size="2"> <span style=" font-size:10pt"> <b>Anybody already considered
(oreven implemented) the following option?: wrapping npgslq in a .NET Web Service; adding this as a Web Service
Referencein the .NET CF application.</b></span></font></div><div align="left"><font face="Arial" size="2"> <span
style="font-size:10pt"><br /></span> </font></div><div align="left"><font face="Arial" size="2"> <span style="
font-size:10pt">Or should I just use a plain ADO.NET interface? Is this possible?</span></font></div><div
align="left"><fontface="Arial" size="2"> <span style=" font-size:10pt"> Or would you suggest using
JDBC?</span></font></div><divalign="left"><font face="Arial" size="2"> <span style=" font-size:10pt"><br /></span>
</font></div><divalign="left"><font face="Arial" size="2"> <span style=" font-size:10pt"> Thanks for replyíng
y'all!</span></font></div><divalign="left"><font face="Arial" size="2"> <span style=" font-size:10pt"><br /></span>
</font></div><divalign="left"><font face="Arial" size="2"> <span style=" font-size:10pt"> Rob</span></font></div><div
align="left"><fontface="Arial" size="2"> <span style=" font-size:10pt"><br /></span> </font></div><div
align="left"><fontface="Arial" size="2"> <span style=" font-size:10pt"> Date sent:                  </span></font>
<fontcolor="#000080" face="Arial" size="2"> <span style=" font-size:10pt"> Thu, 15 Mar 2007 08:29:16
-0700</span></font></div><divalign="left"><font face="Arial" size="2"> <span style=" font-size:10pt"> From:          
              </span></font><font color="#000080" face="Arial" size="2"> <span style=" font-size:10pt"> "Joshua D.
Drake"<jd@commandprompt.com></span></font></div><div align="left"><font face="Arial" size="2"> <span style="
font-size:10pt">Organization:              </span></font> <font color="#000080" face="Arial" size="2"> <span style="
font-size:10pt">Command Prompt, Inc.</span></font></div><div align="left"><font face="Arial" size="2"> <span style="
font-size:10pt">To:                             </span></font> <font color="#000080" face="Arial" size="2"> <span
style="font-size:10pt"> Rob Marjot <rob@marjot-multisoft.com></span></font></div><div align="left"><font
face="Arial"size="2"> <span style=" font-size:10pt"> Copies to:                   </span></font> <font color="#000080"
face="Arial"size="2"> <span style=" font-size:10pt"> pgsql-interfaces@postgresql.org</span></font></div><div
align="left"><fontface="Arial" size="2"> <span style=" font-size:10pt"> <b>Subject:       
             </b></span></font><font color="#000080" face="Arial" size="2"> <span style=" font-size:10pt"> <b>Re:
[INTERFACES]pgsql on a PDA running Microsoft CE</b></span></font></div><div align="left"><font face="Arial" size="2">
<spanstyle=" font-size:10pt"><br /></span> </font></div><div align="left"><font face="Arial" size="2"> <span style="
font-size:10pt">Rob Marjot wrote:</span></font></div><div align="left"><font color="#7f0000" face="Arial" size="2">
<spanstyle=" font-size:10pt"> > Dear all,</span></font></div><div align="left"><font color="#7f0000" face="Arial"
size="2"><span style=" font-size:10pt"> > </span></font></div><div align="left"><font color="#7f0000" face="Arial"
size="2"><span style=" font-size:10pt"> > I know similar issues have been raised before, but I couldn't find
a</span></font></div><divalign="left"><font color="#7f0000" face="Arial" size="2"> <span style=" font-size:10pt"> >
nice(and clear-cut) answer...</span></font></div><div align="left"><font color="#7f0000" face="Arial" size="2"> <span
style="font-size:10pt"> > </span></font></div><div align="left"><font color="#7f0000" face="Arial" size="2"> <span
style="font-size:10pt"> > I wish to develop an application on a HP iPaq PDA running Windows</span></font></div><div
align="left"><fontcolor="#7f0000" face="Arial" size="2"> <span style=" font-size:10pt"> > CE, accessing a
Postgres+PostGISdatabase. What would be the best</span></font></div><div align="left"><font color="#7f0000"
face="Arial"size="2"> <span style=" font-size:10pt"> > way doing this?</span></font></div><div align="left"><font
face="Arial"size="2"> <span style=" font-size:10pt"><br /></span> </font></div><div align="left"><font face="Arial"
size="2"><span style=" font-size:10pt"> Not doing it? All due respect but PostgreSQL+PostGIS is a very
heavy</span></font></div><divalign="left"><font face="Arial" size="2"> <span style=" font-size:10pt"> solution for a
verylight device ;)</span></font></div><div align="left"><font face="Arial" size="2"> <span style=" font-size:10pt"><br
/></span></font></div><div align="left"><font face="Arial" size="2"> <span style=" font-size:10pt">
J</span></font></div><divalign="left"><font face="Arial" size="2"> <span style=" font-size:10pt"><br /></span>
</font></div><divalign="left"><font face="Arial" size="2"> <span style=" font-size:10pt"><br /></span>
</font></div><divalign="left"><font color="#7f0000" face="Arial" size="2"> <span style=" font-size:10pt"> >
</span></font></div><divalign="left"><font color="#7f0000" face="Arial" size="2"> <span style=" font-size:10pt"> > -
Cannpgsql be compiled for CF? Or;</span></font></div><div align="left"><font color="#7f0000" face="Arial" size="2">
<spanstyle=" font-size:10pt"> > - Should I change the PL for my Postgres database (i.e. PL/SQL)
and</span></font></div><divalign="left"><font color="#7f0000" face="Arial" size="2"> <span style=" font-size:10pt">
>use a different provider? Or; - Can I use the open source .NET</span></font></div><div align="left"><font
color="#7f0000"face="Arial" size="2"> <span style=" font-size:10pt"> > implementation "Mono" on Windows
CE?</span></font></div><divalign="left"><font color="#7f0000" face="Arial" size="2"> <span style=" font-size:10pt">
></span></font></div><div align="left"><font color="#7f0000" face="Arial" size="2"> <span style=" font-size:10pt">
>All helpfull suggesions are very much appreciated!</span></font></div><div align="left"><font color="#7f0000"
face="Arial"size="2"> <span style=" font-size:10pt"> > </span></font></div><div align="left"><font color="#7f0000"
face="Arial"size="2"> <span style=" font-size:10pt"> > Rob </span></font></div><div align="left"><font
color="#7f0000"face="Arial" size="2"> <span style=" font-size:10pt"> > </span></font></div><div align="left"><font
color="#7f0000"face="Arial" size="2"> <span style=" font-size:10pt"> > ---------------------------(end
of</span></font></div><divalign="left"><font color="#7f0000" face="Arial" size="2"> <span style=" font-size:10pt"> >
broadcast)---------------------------TIP 9: In versions below 8.0,</span></font></div><div align="left"><font
color="#7f0000"face="Arial" size="2"> <span style=" font-size:10pt"> > the planner will ignore your desire
to</span></font></div><divalign="left"><font color="#7f0000" face="Arial" size="2"> <span style=" font-size:10pt">
>       choose an index scan if your joining column's datatypes do</span></font></div><div align="left"><font
color="#7f0000"face="Arial" size="2"> <span style=" font-size:10pt"> >        not match</span></font></div><div
align="left"><fontcolor="#7f0000" face="Arial" size="2"> <span style=" font-size:10pt"> > </span></font></div><div
align="left"><fontface="Arial" size="2"> <span style=" font-size:10pt"><br /></span> </font></div><div
align="left"><fontface="Arial" size="2"> <span style=" font-size:10pt"><br /></span> </font></div><div
align="left"><fontface="Arial" size="2"> <span style=" font-size:10pt"> -- </span></font></div><div align="left"><font
face="Arial"size="2"> <span style=" font-size:10pt"><br /></span> </font></div><div align="left"><font face="Arial"
size="2"><span style=" font-size:10pt">       === The PostgreSQL Company: Command Prompt, Inc.
===</span></font></div><divalign="left"><font face="Arial" size="2"> <span style=" font-size:10pt"> Sales/Support:
+1.503.667.4564|| 24x7/Emergency: +1.800.492.2240</span></font></div><div align="left"><font face="Arial" size="2">
<spanstyle=" font-size:10pt"> Providing the most comprehensive  PostgreSQL solutions since 1997</span></font></div><div
align="left"><fontface="Arial" size="2"> <span style=" font-size:10pt">             
http://www.commandprompt.com/</span></font></div><divalign="left"><font face="Arial" size="2"> <span style="
font-size:10pt"><br/></span> </font></div><div align="left"><font face="Arial" size="2"> <span style=" font-size:10pt">
Donateto the PostgreSQL Project:</span></font></div><div align="left"><font face="Arial" size="2"> <span style="
font-size:10pt">http://www.postgresql.org/about/donate PostgreSQL Replication:</span></font></div><div
align="left"><fontface="Arial" size="2"> <span style=" font-size:10pt">
http://www.commandprompt.com/products/</span></font></div><divalign="left">  </div>