We use Postgresql, python and PostGIS.
Nearly all our data access is via Postgres functions, both DML and
queries. Our system is a vehicle GPS tracking and business
function analysis system, with quite a lot of data.
Most of our reports require accessing hundreds to 100s of thousands of
records f
We are using python on top of Postgresql / PostGIS, for a vehicle
tracking system.
THis is quite data intensive, and we have some 'interesting' GIS queries
where we see where a vehicle or fleet has stopped within specific areas,
where it has traveled, any incidents along the way and much more.
Pos
You may write stored procedures using PL/pgSQL,alternatively you may
write your queries in python.
You may use psycopg2 to query the DB from Python.
You may have a mix of the two, it will depend on your preference.
Ideally you may not want your users running queries against the data by
connecting t
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?
Would the performance be better?
Regards,
Shao
