 |
Post AvpBZmdKTfLQ1vSni4 by [email protected] |
 |
More posts by [email protected] |
|
Post #Avokc0agrEDX8R48My by [email protected] |
|
0 likes, 1 repeats |
|
|
|
Why #Ao3 was down yesterday: |
|
|
|
Post #Avom7jgzJx37wjhiSG by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@vashti and this is why we shouldn't store numbers in fixed width fields, o… |
|
|
|
Post #Avom7jp8pdZUM1WEAC by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @vashti 264 microseconds is approximately 580 000 years (more tha… |
|
|
|
Post #Avom7jvsQaxWgufbf6 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@catgirlQueer @vashti As I myself wrote, years ago,"At nanosecond resoluti… |
|
|
|
Post #Avom7k3fxbCJ56Jpom by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @catgirlQueer @vashti Fun fact:Until 1972-01-01Z we used rubber-t… |
|
|
|
Post #AvomSIdX6mru7EtSaG by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @catgirlQueer @vashti Also:Until we ditch leap-seconds, we cannot… |
|
|
|
Post #AvomfE9T5vLzyEzm4G by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @catgirlQueer @vashti So there is no "fix it once and for al… |
|
|
|
Post #AvomngLe92Rljkitnc by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @catgirlQueer @vashti And as for nanosecond resolution: Now you … |
|
|
|
Post #Avot5nsZTzHA219DcG by [email protected] |
|
0 likes, 1 repeats |
|
|
|
@simon_brooke @catgirlQueer @vashti Good point.Once Upon A Time two second reso… |
|
|
|
Post #Avoxd91YHrmiz4VBoG by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@bsdphk @catgirlQueer @vashti Rubber time in this sense?https://medium.com/know… |
|
|
|
Post #Avp1hh6DwBEPdr70y0 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@bsdphk @simon_brooke @vashti I thought leap seconds are excluded from Unix tim… |
|
|
|
Post #Avp3Jpm2EbMTVGQ41Y by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@jornane @simon_brooke @vashti That is a slightly less precise way to say the s… |
|
|
|
Post #Avp3VXEoyYAbUUSn32 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @catgirlQueer @vashti No, rubber time in the sense of "I kno… |
|
|
|
Post #Avp3cPGf0WlMnYbH3g by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@bsdphk @catgirlQueer @vashti so a canonical ordering of events, without precis… |
|
|
|
Post #Avp3yh1XffpWEs9iMa by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @catgirlQueer @vashti Ordering is an entirely different issue. |
|
|
|
Post #Avp4EDthjKl4XQtYLQ by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@bsdphk @catgirlQueer @vashti ok, now I'm not understanding. When you say &… |
|
|
|
Post #Avp8QzpTkK7YUJGTRI by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@vashti i hope the last one was a bad horny one |
|
|
|
Post #Avp8QzxdG0dutb4z9E by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@root @vashti I mean, the odds are good on that one >_< |
|
|
|
Post #Avp8RML83KVgIqF3pI by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@vashti amused and impressed that AO3 has been around long enough to collect 2 … |
|
|
|
Post #Avp8RMSDcyBIepYisS by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@dotjayne @vashti no, yeah, good point, that's the only aspect of the decis… |
|
|
|
Post #Avp8Rae4rfzAffDOIy by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @catgirlQueer @vashti Just to be safe you should follow RFC2550.h… |
|
|
|
Post #Avp8VMBoYMPszln7js by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @vashti Bignum is not useful here. As identifiers, 128 bit is alr… |
|
|
|
Post #Avp8VllTSunOJbfSIC by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke ok but it's hard to index |
|
|
|
Post #Avp8Vq43Tm2FeOOLoG by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @vashti what a shockingly bad take, most programs are packed full… |
|
|
|
Post #Avp8VqA57Mr7x5DACe by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@kevingranade @vashti no, absolutely it wouldn't. Any sensible language run… |
|
|
|
Post #Avp8ebLtY3wkcxulVI by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@bsdphk @simon_brooke @catgirlQueer @vashti time is a fundamentally local pheno… |
|
|
|
Post #Avp8o6JRo6xjFwIcxk by [email protected] |
|
0 likes, 0 repeats |
|
|
|
good news |
|
|
|
Post #Avp8pJ9RYiWXMdCCHY by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @vashti the constraint comes from a db column. Fixed width column… |
|
|
|
Post #Avp8psB5KbdJzrEVCS by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @vashti I assume it's using SQL for the database. Does SQL ev… |
|
|
|
Post #Avp8psIAuFIwLqYAFc by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@Rusty @vashti strictly speaking, no, although some databases can store extreme… |
|
|
|
Post #Avp8qRD55B1geBR5fc by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@dotjayne I'm not sure which database they're using, but PostgreSQL sad… |
|
|
|
Post #Avp8qRKWdUyt1Gv2H2 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@argv_minus_one @dotjayne @vashti On the other hand, signed integers mean that … |
|
|
|
Post #Avp8tQLIlQWepFhlfU by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @catgirlQueer @vashti https://en.wikipedia.org/wiki/Network_Time_… |
|
|
|
Post #Avp8tQUWD9tlHq182C by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @catgirlQueer @vashti The only larger thing I know of (aside from… |
|
|
|
Post #Avp8tQv6cJAKcISMTY by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @catgirlQueer @vashti Anyway the compelling thing about using NTP… |
|
|
|
Post #Avp8xPbTSDE1gwAffU by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brookeApples v Oranges Programming Languages v Data Base Managers. Bignu… |
|
|
|
Post #Avp8xPhV5o2tzczU3s by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@unusnemo I don't agree. There's no reason at all why a database manage… |
|
|
|
Post #Avp8xivJcfNzbybHjU by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @kevingranade @vashti i would imagine this depends on the runtime… |
|
|
|
Post #Avp90sLH3p13gxFGlc by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@vashti for the record the bookmark that killed the site was on one direction d… |
|
|
|
Post #Avp90sTmYBp07LE41o by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@[email protected] @[email protected] @[email protected]: https://wet… |
|
|
|
Post #Avp93nZNGGqFl6EaNE by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @kevingranade @vashti and now my pointer is pointing to …what, … |
|
|
|
Post #Avp93nfksXwi4tDgJs by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@purple @kevingranade @vashti to the number. |
|
|
|
Post #Avp93nm8Up3AOgCmGW by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @kevingranade @vashti except the number isn't there anymore i… |
|
|
|
Post #Avp93nsA8Ps2hN1aeu by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@purple @kevingranade @vashti well that depends. But in a system designed for m… |
|
|
|
Post #Avp94Zq1negTSeOYzo by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke I'd love to live in your fantasy land where you can do that w… |
|
|
|
Post #Avp94ZwPPvmvmRNewS by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@kevingranade why are you working with such constrained hardware? The phone in … |
|
|
|
Post #Avp94a2R3Wbo58CTKq by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke All hardware is constrained if your problem domain is ambitious e… |
|
|
|
Post #Avp9GuMNKIVwaDPBU8 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke The machines you did bignum arithmetic on in the 1980s weren'… |
|
|
|
Post #Avp9JH9hXmilrTbddg by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @vashti Yeah, AO3 is pretty old though so I'd imagine it woul… |
|
|
|
Post #Avp9OLRz0Fuyd6ZfjE by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@LW44 @kevingranade @vashti obviously it depends on the runtime. But the idea t… |
|
|
|
Post #Avp9OLZ4Ztaaz5tKmO by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke Okay but now try benchmarking the performance of bignum arithmeti… |
|
|
|
Post #Avp9OLf6DUPTHmi9Am by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@argv_minus_one @LW44 @kevingranade @vashti it won't win for (positive) va… |
|
|
|
Post #Avp9P12aN4YfcV0yyO by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @kevingranade @vashti threads have nothing to do with this.But I … |
|
|
|
Post #Avp9P2hkBX4imRHMlU by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @catgirlQueer @vashti it would be incredibly funny if "there… |
|
|
|
Post #Avp9PNPjBi8r0e0m6C by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@kmohrf @catgirlQueer @vashti perhaps. It's a convenient assumption, howeve… |
|
|
|
Post #Avp9WkcdIb0R10Z2A4 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@rexo @vashti @root Thank you for your service 😂 |
|
|
|
Post #Avp9akqiOdcysV3mXg by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@dotjayne @vashti Every pen tester in the world just salivated at the challenge… |
|
|
|
Post #Avp9g1DgxTi76AJjcG by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke I thought you meant 32-bit + bignum. 64+bignum seems unnecessary.… |
|
|
|
Post #Avp9hlIj7BuSJ3VHSS by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@purple @kevingranade @vashti I've written a wee essay on why you already d… |
|
|
|
Post #Avp9m0FdTMhtpd51ea by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@kevingranade @simon_brooke There was an article about how increasing index siz… |
|
|
|
Post #Avp9mvdi6WphonmYam by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@dotjayne @vashti IIRC SQL doesn’t have unsigned types.But, a migration takin… |
|
|
|
Post #AvpBDs9xFawonZHAO0 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @catgirlQueer @vashti What I'm trying to say is that timestam… |
|
|
|
Post #AvpBOdNUY5608hjtaa by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @catgirlQueer @vashti It literally means that the years 1973 and … |
|
|
|
Post #AvpBZmdKTfLQ1vSni4 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@bsdphk @catgirlQueer @vashti like any other human measurement, it's arbitr… |
|
|
|
Post #AvpCNSb1FXZwMg4Rii by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @catgirlQueer @vashti They all important difference is that we co… |
|
|
|
Post #AvpCjmp2jJ93SxHBj6 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @catgirlQueer @vashti But time is still different, because it is … |
|
|
|
Post #AvpDIMzSlRPJU8dmd6 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @purple @vashti good for you, keep being wrong and leave the fun… |
|
|
|
Post #AvpDiRrvFVAW90Y5s8 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@[email protected] Can you provide the "2147483647th bookmark" link? |
|
|
|
Post #AvpDiS04lBgsYIMba4 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@Orca @vashti 👋 hi i'm /u/scratchisthebestit just links to their public … |
|
|
|
Post #AvpDiS7sIBvewU0pjk by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@quat @Orca hi!! I tried so hard to find your original comment, that's a ve… |
|
|
|
Post #AvpDiWrkfZ0FdvVWng by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@vashti @Orca ITHOTIU I DELETED IT |
|
|
|
Post #AvpDiXU2NDczYfQ6TY by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@Orca @vashti however, if you do want to see the fabled bookmark, someone repli… |
|
|
|
Post #AvpPZOVnYjaMZpeLAm by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@kevingranade @simon_brooke I can only imagine how well our codes would perform… |
|
|
|
Post #AvrTfcNBj0rBR8lVVQ by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@unusnemo @simon_brooke PostgreSQL has bignums as a native type.https://www.pos… |
|
|
|
Post #AvrTfcVLEhNXqQa1DM by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@mathew @unusnemo These aren't strictly bignums. They're still fixed pr… |
|
|
|
Post #AvrTfccmn1KkDW3xom by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@simon_brooke @unusnemo I mean, all bignums have a limit, if for no other reaso… |
|
|
|
Post #AvrTftVxzcyobI0G36 by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@mathew @unusnemo Aye, if you tried to index every atom in the universe, I susp… |
|
|
|
Post #Avz0URrd77y0Fh0OFk by [email protected] |
|
0 likes, 0 repeats |
|
|
|
@vashti This is one of the things we think about at work constantly - how big s… |
