Date: Thu, 15 Dec 2022 00:07:25 +0100
From: Jiri Vlasak <jiri.hubacek@gmail.com>
To: siiky <github-siiky@net-c.cat>
Cc: ~qeef/damn-project@lists.sr.ht
Subject: Re: SQLite as DB alternative
Message-ID: <Y5pXLYdxQWdGW1fh@gmail.com>
References: <bd4eeb77-f669-9aa4-8e20-58e67003bb22@net-c.cat>
 <Y5i8UQLaHmpKQ7Lx@gmail.com>
 <27ef17e6-7fe2-fe5e-5338-776207cd17e0@net-c.cat>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <27ef17e6-7fe2-fe5e-5338-776207cd17e0@net-c.cat>

> 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
area.

> 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
	cd 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 [1] and the
following workflow:

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.

[1]: https://git.sr.ht/~qeef/py-geojson/tree/master/item/divide_to_squares.py