pull down to refresh

I think that's a bug. Should probably be fixed asap.
40 sats \ 13 replies \ @ek 14h
It's not a bug, it always worked like that.
The ids are sequential, and you can always still pay for an item.
Once an id was assigned, it's gone.
reply
120 sats \ 1 reply \ @grayruby 14h
I still think it should be fixed. Haha
reply
20 sats \ 0 replies \ @ek 14h
I respect that opinion haha
reply
60 sats \ 6 replies \ @k00b 14h
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.
reply
You could just make a temporary buffer (new table) until the item paid.
reply
40 sats \ 4 replies \ @k00b 12h
100% not worth it.
reply
I bet that's a pain in the ass. Any way to know the real number of paid items right now?
reply
30 sats \ 2 replies \ @k00b 12h
SQL's count.
What about a sudden spike in total daily items? Is SN going parabolic all of a sudden?
reply
THE RETAIL IS COMING!
lol, cope
reply
If you give a look at recent/all, there's certainly a new wave of stackers who are creating items. And the old ones have also been more activated. Certainly it looks like the rough patch has been mended all of a sudden.
reply
Copium and hopium
reply
90 sats \ 2 replies \ @k00b 14h
There's a bug in your bet. Our ids are working as intended. :P
reply
0 sats \ 1 reply \ @grayruby 14h
Haha there is only a bug if I lose.
reply
40 sats \ 0 replies \ @ek 12h
not too late to join the bright side
reply
Yes, I also think so. The way daily item numbers have increased in last two days, it's more likely a bug.
Even then I think @ek has suggested how we can manipulate that market and make profit.
Should we try it?
reply