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 <[email protected]> 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 <[email protected]> > 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 >> [email protected] >> https://lists.osgeo.org/mailman/listinfo/postgis-users > > _______________________________________________ > postgis-users mailing list > [email protected] > https://lists.osgeo.org/mailman/listinfo/postgis-users
_______________________________________________ postgis-users mailing list [email protected] https://lists.osgeo.org/mailman/listinfo/postgis-users
