[postgis-users] Querying PostgreSQL / PostGIS Databases in Python

[Shaozhong SHI]

Hi, Laura,

Thank you for your reply.

1.  Please look at this documentation link.
https://www.postgresql.org/docs/9.1/external-pl.html

There is also PL/sh language.

So many varieties.  I wonder the use cases for all these.

2.  My immediate concern is to know which one is good for periodically
processing Big Data.

Standard queries in PostgreSQL may fail or keep running for days, weeks
when data is very big.

If you do a programme with standard queries of PostgreSQL, I would think
that it could run forever.

3.  Does that mean Python can be treated as a native language in
PostgreSQL/PostGIS?  Will it run faster?

Regards,

Shao

On Fri, 31 Jul 2020 at 12:01, Augori <augori at gmail.com> wrote:

> Hi Shao,
> Using Python allows you to integrate a query into a workflow that has some
> batch component to it. Examples would be a query which allows you to select
> a set of records that need to be updated daily. Or it could be a query that
> needs to be run on hundreds of files to build a summary of the data or it
> could be part of a process that is triggered by some outside event, like a
> file being updated.  I hope I haven't misinterpreted your question but you
> seem to be asking why you'd want to automate interactions with a database,
> a question to which there are thousands of responses. Please clarify if
> that is not the case.
>
> Kind regards,
> Laura
>
> On Fri, Jul 31, 2020, 5:05 AM Shaozhong SHI <shishaozhong at gmail.com>
> wrote:
>
>> Hi,
>>
>> What is the advantage of querying in Python?
>>
>> Has anyone got much experience?
>>
>> What not just use standard query?
>>
>> What is the rationale for querying in Python?
>>
>> Regards,
>>
>> Shao
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200731/f2ad5c39/attachment.html>