Thanks for the reply!
There's at least SpatiaLite as a GIS extension for SQLite. How good
it is, and how it compares to PostGIS (feature-wise and language-wise) I
don't know, I haven't used either.
RE loads: that makes sense, though it's possible to tweak SQLite for
better performance in concurrent contexts (such as enbaling WAL
mode). It's also possible to serialize SQLite access (e.g. with a
"proxy class"), and with more SQLite tweaks (allowing it to assume
single-process and single-thread, plus ), I doubt it would be much
slower than Postgres.
(Aside: I had a big performance improvement by enabling WAL mode in a
two-writers scenario, where one of them rarely writes and the other
mostly reads. But I can't comment much more than that, I would need to
try things out in context.)
For context, what prompted the email was that I'd like to use DAMN for
small (1 person) tasks and but feel it's overkill to use your public
instance. So I'd like to run DAMN on my desktop/laptop but I'm not too
keen on having to setup Postgres+PostGIS (it's just overkill for this
> For context, what prompted the email was that I'd like to use DAMN for> small (1 person) tasks and but feel it's overkill to use your public> instance.
Feel free to use it, if it is not a problem that you need to be online
to lock/unlock squares. You may set the priority to 0 to unlist the
> So I'd like to run DAMN on my desktop/laptop but I'm not too keen on> having to setup Postgres+PostGIS (it's just overkill for this> usecase).
You don't need to set up Postgres + PostGIS, if you can run docker and
docker-compose. I have updated the damn-deploy repository, so the
instructions in the damn-server README works now:
git clone https://git.sr.ht/~qeef/damn-deploy
sed -i '/POSTGRES_PASSWORD=.*/d' .env
docker-compose -f http.yml up db
However, running damn project on localhost for the purpose of personal
maping is overkill, indeed.
I think that the proper solution is to improve JOSM TODO plugin.
Meanwhile, you may try to use divide_to_squares.py script  and the
1. Create GeoJSON of area you want to map.
2. ./divide_to_squares.py area.geojson
3. Open squares.geojson in JOSM.
4. Ctrl + F -> put tmp to Search string -> Enter.
5. Add selected squares to TODO plugin.
I do not say it is perfect.