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

[Augori]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20200731/248f82d0/attachment.html>