pull down to refresh
@LivingOnBitcoin visited Melville Deli and made a video.
It's more complicated than just unpaid items or deletions. Rollbacks after inserts also leave "holes" in sequences.
Because smallserial, serial and bigserial are implemented using sequences, there may be "holes" or gaps in the sequence of values which appears in the column, even if no rows are ever deleted. A value allocated from the sequence is still "used up" even if a row containing that value is never successfully inserted into the table column. This may happen, for example, if the inserting transaction rolls back.
Afaik the best we can say about sequences is that they're monotonically increasing (if
NO CYCLE
is used (which is the default)).The
id
is not the item count. It's a rough overestimate of the item count.Also, just a tip (take or leave it): chill on the AI writing a bit if you can. It tends to sound inauthentic and folks here won't zap it very hard. Writing is hard but you get what you work for (usually). Even if your grammar is bad or whatever, most of us would prefer to see the real you in writing.
Are you trying to live on Bitcoin too?
No, I don't really want to trade one intermediary for another more cumbersome one. So until more merchants accept bitcoin, or I have more free time, I probably won't.
What’s the biggest challenge you face in spending or saving BTC?
0.001% of merchants accept bitcoin as payment.
Any tools or apps you can’t live without?
Zeus is great. I'm glad you're using it and running your own node.
There was a guy in my Theory of Computation class that routinely outperformed me and was way quicker on the draw when the professor asked a question (I'd never speak up, but I'd always try to come up with the answer). I've always had to work hard for what little understanding I end up with, struggling to accept/organize the rules that make something understood.1 This guy seemed to do it easily.
I'm sure I've come across many people like this. They can be hard to spot if you're just a peer - most smart people I've met learn to downplay the disagreeable effects of intelligence. I know many stackers are very smart.
The professor of my Theory of Computation class once described an encounter with his wunderkind: a guy, unenrolled in his class, would come in only to take the tests and would do perfectly on them, performing several standard deviations better than the mean. Apparently the guy would do that in other classes too. Rogaway eventually pulled some strings to get him transferred to MIT (CalTech was too elitist to accept a transfer).
Footnotes
-
With most subjects I never seem to fully organize the rules. Once I get them organized enough, such that I see the implications of fully organizing them, I tend to move onto something else, seeking breadth rather than depth. ↩
Will Block Rewards integrate with something like Gusto or Remote? I'd love to pay SN's team in bitcoin, but I need all the tax stuff to be easy.
I wish they explained or link to somewhere where I could learn what a compiler does when it vectorizes appropriately. I imagine it’s at least putting handling params in a way that takes advantage of cache locality, but are some compilers making use of gpus now? Or do cpus have some support for vectorization?
count
.