platz

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

what exactly is 'calling a function in two parts'

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.

you made a funny

what's an example of something you made happen

whats an example of things that you have your agents do that use workflows and sqlite db

irrelevant to the definition, thanks anyway

A democracy means political authority ultimately comes from the people.

What exactly is 'sustainability'

I like how OBS has subsumed (often low-quality) screen recording apps for me; apart from the apps original intent for streaming

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.

maybe it depends on your definition of objective

peak FP debate was 2015/2016-ish

In the 2010-2020 era, readers of Hacker News used to know how to read Haskell and had strong opinions (pro and con) of it.

That era is now over.

I assume it depends on the amount of detail you're expecting to get.

Generally there are some broad categories:

1) tracked vs untracked mounts

2) shooting single frames vs shooting with high FPS and processing that into a resulting image.

whoever came up with the name 'earworm' needs to be shot

Boltzmann Brains usually mean something is wrong in your cosmology

Licenses communicate your intent; if you choose the most permissive one possible that is also implicitly communicated.

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

https://www.reddit.com/r/space/s/0oVjIo0XMi

Where did the the values of the coupling constants between the various fields come from?

There are many parameters that do not have a reason for their value.

learning

can we just come up with one common term to to refer to all of my these between sites

How do you know the bird just isn't entertaining itself with its own reflection.

But there's nowhere to put your coffee mug

the owner

It's not in the habitable zone 100% of the time because of its eccentric orbit.

How is a jump realized by Not Gates?

we have not a single shred of evidence that exceeding Turing computability is possible

if your basis that anything that has equal to or less than turing computability is a computer, then everything is a computer.

there is no rational basis for assuming the brain is a "computer" in the same way an intel x86 chip is a "computer" or that the universe is a "computer". Using language in this way without defining terms like what even is a computer is folly.