can it be a sqlite db in s3 with locking implemented with s3?

Hello, Stategraph developer here, the answer is: probably not. That doesn't resolve the core issue of state being managed as a big blob.

but that big blob is a database. surely it's better than a json file right?

In terms of the semantics er care about, not really. You still have to lock the whole thing to some with it.

	▲	tuananh 4 days ago \| parent [-]
		for locking individual resources right?