MerginMaps / MerginMaps/db-sync

Unable to sync multiple geopackages from a single MM project

Open
#163 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

bug
Dominant language
Python
Stars
53
Forks
24
PR merge metrics
No merged PRs in 30d

Description

Right now, syncing multiple geopackages from a single MM project on a single computer does not work:
- if there's one config file with multiple connections (to the same MM project), these connections use the same working project directory (in `$TEMP/dbsync`) - and that causes issues, because each connection should have its independent working directory
- even if there are multiple db-sync daemons running, each with a separate config file, this is still not going to work because of the working project directory collision as above. There are two ways to avoid working directory collisions in this case:
1. run db-sync in docker containers (each container has its own temporary directory); or
2. set a different temporary dir (using env variable) for each db-sync run

Both of these cases should ideally work without any fiddling needed... Probably we could just fix the local project directory naming so that they are more unique (e.g. include gpkg name, db schema name?)

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

No files or tests are named. Start by locating where db-sync creates the local project directory under $TEMP/dbsync and reproduce two connections targeting one MM project; done means multiple geopackages can sync independently without Docker containers or separate temporary-directory environment settings.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
50/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.