Python Forum
maintain a postgresql database using osm2pgsql
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
maintain a postgresql database using osm2pgsql
#2
if you use SqlAlchemy, rather than osm2pgsql, you can easily tract all transactions.
see: https://docs.sqlalchemy.org/en/13/orm/se...vents.html
I have a short tutorial on this forum which shows the basics for SqlAlchemy here: https://python-forum.io/Thread-SqlAlchem...-Data-Load

the tutorial is for sqlite, but you should be able to use PostgreSQL with a one line change to line 17 of the database model.
It's well worth the small learning curve.
Reply


Messages In This Thread
RE: maintain a postgresql database using osm2pgsql - by Larz60+ - Aug-03-2020, 10:33 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  How to Connect to PostgreSQL Through Jump Server and SSH Tunnel using Python? nishans 1 3,970 Jan-02-2024, 10:37 AM
Last Post: khanzain
  PostgreSQL psycopg2.errors.DuplicateColumn: column specified more than once rajnish_nationfirst 2 5,114 Jun-21-2020, 08:17 AM
Last Post: ibreeden
  StopIteration exception when mock PostgreSQL connection in several tests igor87z 1 3,806 Jun-10-2020, 06:16 PM
Last Post: ibreeden
  Python and Postgresql syntax select statement Nesreenmhd 1 5,744 Sep-07-2019, 06:08 PM
Last Post: ndc85430
  Create table with psycopg2 on postgreSQL DB yhecohen 2 4,243 Aug-23-2019, 05:56 AM
Last Post: massimo_m
  Error while fetching data from PostgreSQL linu 3 5,639 May-13-2019, 02:38 PM
Last Post: rxndy
  Return Row ID postgresql takaa 1 4,329 Nov-24-2017, 03:32 AM
Last Post: Larz60+
  PostgreSQL- import package elhetch 2 5,456 Jun-07-2017, 02:07 PM
Last Post: snippsat
  error while inserting values into a table from form in flask in postgreSQL sahilsiddharth 3 8,402 Jun-05-2017, 07:49 PM
Last Post: sahilsiddharth
  Nginx Setup Django Postgresql Eclipse Adelton 3 5,079 Mar-27-2017, 09:40 PM
Last Post: snippsat

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020