lol, I briefly thought of such a technique, but in the end, found it simpler to just use a synchronization primitive at the application level to serialize db access on transactions where I knew I was going to write. it amounts to about the same honor code.
busy_timeout is often sidestepped (ignored) when a transaction attempts to upgrade from a read to a write producing SQLITE_BUSY.
By default, SQLite transactions start in DEFERRED mode, acting as read transactions until an actual write operation occurs.
If another connection begins writing to the database while your transaction is in this read state, an immediate SQLITE_BUSY error is triggered regardless of what you set busy_timeout to
The alternative is a High-Dimensional / Embedding-Like Approach where question responses aren't tied to fixed axes, but rather the full response set is treated as a point in latent space.
Then it's on the researcher to examine the clusters and assign labels. There's also not a nice mapping that's a-priori interpretable in low-dimensional pre-existing axes.
Probably only used in research than consumer websites, under more controlled conditions; there are very few public political tests doing this transparently
2016 (up to 2018 or so) may have been the peak of such varied activity in the developer ecosystem, including articles like this, whether it was discussion, ideation, OSS variety, language development.
There has been growth since but it's been concentrated into fewer channels and somewhat industrialized.
if your definition requires universal observer agreement you already have that issue with special relativity / light cones / the spacetime metric.
many worlds posits a single universal quantum state it's just only partially accessible to observers, which is different from saying that it simply doesn't objectively exist.
Actually, we're already past the peak of star formation in the universe. So the universe is well on its way winding down.. less and less stars are being created.
We're seeing the universe more middle aged than especially young